G
Guest
Hi all. I would like to show child elements in a datagrid of the parent
element in a DDL. I have populated the DDL ok, but how do I dynamically
update the Datagrid? I am trying the folowing~:
Dim selectedItem = DropDownList1.SelectedValue
Me.Label1.Text = "" + selectedItem + ""
Me.DataGrid1.Visible = False
Me.MySqlCommand2.CommandText = "select * from filename where
Customer_id=" + selectedItem
Me.MySqlDataTable2.SelectCommand = Me.MySqlCommand2
Me.MySqlDataAdapter2.Fill(DataSet21)
DataGrid1.DataBind()
Me.DataGrid1.Visible = True
element in a DDL. I have populated the DDL ok, but how do I dynamically
update the Datagrid? I am trying the folowing~:
Dim selectedItem = DropDownList1.SelectedValue
Me.Label1.Text = "" + selectedItem + ""
Me.DataGrid1.Visible = False
Me.MySqlCommand2.CommandText = "select * from filename where
Customer_id=" + selectedItem
Me.MySqlDataTable2.SelectCommand = Me.MySqlCommand2
Me.MySqlDataAdapter2.Fill(DataSet21)
DataGrid1.DataBind()
Me.DataGrid1.Visible = True