Reload DataGrid on DropDownList onChangeIndex

[hansiman]

I have a drop down list and a datagrid.
The dropdownlist is populated on pageload.
I' like to databind the datagrid when user selects in dropdownlist:

Something like this:

Private Sub cbo1_SelectedIndexChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles cbo1.SelectedIndexChanged

dgr.DataSource = GetDataSet(connection, _
"SELECT * FROM Orders Where CustomerID = " _
"'" & cbo1.SelectedItem.Value & "';")
dgr.DataBind()
End Sub
If I add a button it works just fine.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As _
System.EventArgs) Handles Button1.Click
dgr.DataSource = GetDataSet(connection, _
"SELECT * FROM Orders Where CustomerID = " _
"'" & cbo1.SelectedItem.Value & "';")
dgr.DataBind()
End Sub
/morten

[Michael Ramey]

And your problem is...??..(since you never told us)

If I had to guess, your code isn't fired when you create the sub
"cbo1_SelectedIndexChanged". because you haven't set "AutoPostBack"
attribute is set to "true" for this control. By default it is false.

HTH,
--Michael

"hansiman" <ha***@hotmail.com> wrote in message
news:6l********************************@4ax.com...

I have a drop down list and a datagrid.
The dropdownlist is populated on pageload.
I' like to databind the datagrid when user selects in dropdownlist:

Something like this:

Private Sub cbo1_SelectedIndexChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles cbo1.SelectedIndexChanged

dgr.DataSource = GetDataSet(connection, _
"SELECT * FROM Orders Where CustomerID = " _
"'" & cbo1.SelectedItem.Value & "';")
dgr.DataBind()
End Sub
If I add a button it works just fine.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As _
System.EventArgs) Handles Button1.Click
dgr.DataSource = GetDataSet(connection, _
"SELECT * FROM Orders Where CustomerID = " _
"'" & cbo1.SelectedItem.Value & "';")
dgr.DataBind()
End Sub
/morten

[hansiman]

you're the man :)

- I'm just getting into asp.net (finding time in between classic asp
projects. cant wait to put my new sills to good use).
On Tue, 3 Feb 2004 15:17:12 -0500, "Michael Ramey" <raterus@localhost>
wrote:

And your problem is...??..(since you never told us)

If I had to guess, your code isn't fired when you create the sub
"cbo1_SelectedIndexChanged". because you haven't set "AutoPostBack"
attribute is set to "true" for this control. By default it is false.

HTH,
--Michael

"hansiman" <ha***@hotmail.com> wrote in message
news:6l********************************@4ax.com.. .

I have a drop down list and a datagrid.
The dropdownlist is populated on pageload.
I' like to databind the datagrid when user selects in dropdownlist:

Something like this:

Private Sub cbo1_SelectedIndexChanged(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles cbo1.SelectedIndexChanged

dgr.DataSource = GetDataSet(connection, _
"SELECT * FROM Orders Where CustomerID = " _
"'" & cbo1.SelectedItem.Value & "';")
dgr.DataBind()
End Sub
If I add a button it works just fine.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As _
System.EventArgs) Handles Button1.Click
dgr.DataSource = GetDataSet(connection, _
"SELECT * FROM Orders Where CustomerID = " _
"'" & cbo1.SelectedItem.Value & "';")
dgr.DataBind()
End Sub
/morten