I have a dropdown list which is populated from the database. The second should then be populated with items from the database according to what was selected in the first. How do I say to only display the items if they have the category selected in the first box???
PS I am only using one table.
Thanks loadsProblem solved, I've noticed that loasds of people have the same problem so here is the code for the SelectedIndexChanged event:
Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
Dim myconnection As SqlConnection
Dim mydata As SqlDataAdapter
Dim mydata7 As SqlDataAdapter
Dim ds7 As DataSet
myconnection = New SqlConnection("workstation id=****;packet size=4096;integrated security=SSPI;data source=""****\*" & _
"CGA"";persist security info=False;initial catalog=table")
mydata7 = New SqlDataAdapter("Select * from table ", myconnection)
ds7 = New DataSet
mydata7.Fill(ds7, "table")
Dim dav1 As New DataView(ds7.Tables("table"))
Dim strFilter As String
strFilter = "Category='" & DropDownList1.SelectedValue & "'".ToString
dav1.RowFilter = strFilter
DropDownList3.DataSource = dav1
DropDownList3.DataTextField = ds7.Tables(0).Columns("Question").ColumnName.ToString()
DropDownList3.DataValueField = ds7.Tables(0).Columns("Question").ColumnName.ToString()
DropDownList3.DataBind()
End Sub
Hope this helps anyone in the same situation!
PS I am only using one table.
Thanks loadsProblem solved, I've noticed that loasds of people have the same problem so here is the code for the SelectedIndexChanged event:
Private Sub DropDownList1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged
Dim myconnection As SqlConnection
Dim mydata As SqlDataAdapter
Dim mydata7 As SqlDataAdapter
Dim ds7 As DataSet
myconnection = New SqlConnection("workstation id=****;packet size=4096;integrated security=SSPI;data source=""****\*" & _
"CGA"";persist security info=False;initial catalog=table")
mydata7 = New SqlDataAdapter("Select * from table ", myconnection)
ds7 = New DataSet
mydata7.Fill(ds7, "table")
Dim dav1 As New DataView(ds7.Tables("table"))
Dim strFilter As String
strFilter = "Category='" & DropDownList1.SelectedValue & "'".ToString
dav1.RowFilter = strFilter
DropDownList3.DataSource = dav1
DropDownList3.DataTextField = ds7.Tables(0).Columns("Question").ColumnName.ToString()
DropDownList3.DataValueField = ds7.Tables(0).Columns("Question").ColumnName.ToString()
DropDownList3.DataBind()
End Sub
Hope this helps anyone in the same situation!