pelegk1
04-20-2006, 03:55 PM
i have a code L
conPubs = New SqlConnection(conStr)
conPubs.Open()
'**>> building select box for מצב המסלול
cmdSelect = New SqlCommand("Select * From course_type;SELECT UploadTrail_id, UploadTrail_select_types_id FROM UploadTrail_select_values WHERE (UploadTrail_id = 54) AND (UploadTrail_select_types_id = 6);", conPubs)
Dim Reader As SqlDataReader
Reader = cmdSelect.ExecuteReader()
course_type.DataSource = Reader
course_type.DataValueField = "course_id"
course_type.DataTextField = "course_name"
course_type.DataBind()
if u look u will see 2 select's that are delimited with ; (semicolon)
how can i access the second recordset after i bind the first one on the last line
(i want to get values from the rows in the second "select")
thnaks in advance
peleg
conPubs = New SqlConnection(conStr)
conPubs.Open()
'**>> building select box for מצב המסלול
cmdSelect = New SqlCommand("Select * From course_type;SELECT UploadTrail_id, UploadTrail_select_types_id FROM UploadTrail_select_values WHERE (UploadTrail_id = 54) AND (UploadTrail_select_types_id = 6);", conPubs)
Dim Reader As SqlDataReader
Reader = cmdSelect.ExecuteReader()
course_type.DataSource = Reader
course_type.DataValueField = "course_id"
course_type.DataTextField = "course_name"
course_type.DataBind()
if u look u will see 2 select's that are delimited with ; (semicolon)
how can i access the second recordset after i bind the first one on the last line
(i want to get values from the rows in the second "select")
thnaks in advance
peleg