Por favor alguien me puede ayudar con un button1 doy
click y me funciona bien el grid y me despliega la
informacion
pero deseo que al escojer una opcion del DropDownList me
despliegue en el grid
escoji este evento DropDownList3_SelectedIndexChanged
pero al escojer una opcion no me despliega alguien me
puede decir como hago para que me funcioe bien
Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
Me.SqlSelectCommand1.CommandText = "SELECT * FROM
contactos_banred" & _
" where banco = '" & Me.DropDownList3.SelectedValue & "'"
Me.SqlSelectCommand1.Connection = Me.SqlConnection1
Me.SqlDataAdapter2.SelectCommand = Me.SqlSelectCommand1
Me.SqlDataAdapter2.Fill(Me.DataSet21)
Me.DataGrid1.DataSource = Me.DataSet21
Me.DataGrid1.DataBind()
End Sub
Private Sub DropDownList3_SelectedIndexChanged(ByVal
sender As System.Object, ByVal e As System.EventArgs)
Handles DropDownList3.SelectedIndexChanged
Me.SqlSelectCommand1.CommandText = "SELECT * FROM
contactos_banred" & _
" where banco = '" & Me.DropDownList3.SelectedValue & "'"
Me.SqlSelectCommand1.Connection = Me.SqlConnection1
Me.SqlDataAdapter2.SelectCommand = Me.SqlSelectCommand1
Me.SqlDataAdapter2.Fill(Me.DataSet21)
Me.DataGrid1.DataSource = Me.DataSet21
Me.DataGrid1.DataBind()
End Sub
Gracias de antemano
Caro
Leer las respuestas