ayuda URGENTE enlazar dropdownlist con datagrid hola a todos necesito hacer lo siguiente enlazar un dropdownlist con un datagrid para poder filtrar los datos del grid tengo lleno el grid y el dropdownlist pero no logro enlazarlos alguien me podria ayudar
aqui les pongo el codigo de como lleno mi datagrid y como lleno el dropdownlist
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
bindgrid()
DropDownList2.DataTextField = "item"
DropDownList2.DataSource = MyQueryMethod()
DropDownList2.DataBind()
End If
End Sub
Sub bindgrid()
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionStri ng)
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand()
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter()
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet()
dataAdapter.Fill(dataSet)
DataGrid1.DataSource = dataSet
DataGrid1.DataKeyField = "IDDEInventario"
DataGrid1.DataBind()
End Sub
Function MyQueryMethod() As System.Data.DataSet
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionStri ng)
Dim queryString As String = "SELECT distinct[Inventario].[Item] FROM [Inventario]order by item"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand()
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dataAdapter As System.Data.IDbDataAdapter = New System.Data.SqlClient.SqlDataAdapter()
dataAdapter.SelectCommand = dbCommand
Dim dataSet As System.Data.DataSet = New System.Data.DataSet()
dataAdapter.Fill(dataSet)
Return dataSet
End Function
de antemano muchas gracias
