I m new to asp.net is there any way that i could display different data in one row where the data is pulled from same column of another table? where the column is name hello and contains 3 types of data let`s say my code is like this:
cmd1.CommandText = " SELECT hello FROM link where mode=@model and procedure =@procedure "
cmd1.CommandType = System.Data.CommandType.Text
Dim da1 As New SqlDataAdapter()
da1.SelectCommand = cmd1
Dim dt1 As New DataTable()
da1.Fill(dt1)
Dim myDataReader1 As SqlDataReader
myDataReader1 = cmd1.ExecuteReader()
Dim hello As String
If myDataReader1.HasRows Then
Do While myDataReader1.Read()
hello= myDataReader1("hello").ToString()
Loop
lblhello.Text = hello
Else
lblhello.Text = ""
End If
myDataReader1.Close()
my data output should be like:
hihi,yoyo,heyhey
but i ended up getting
heyhey
only please help me on this issue
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire