Hi,
I have a dropdown list that is populated with table names from my
database using SqlDataSource1. When I change the selected index I can
get the table name back from the dropdown and display it in a label.
What I want to do is display the data from the table selected in the
dropdown in the GridView control but I have no idea how to do it. So
basically everytime the user selects a different table from the
dropdown the data is displayed in the GridView. The columns in each of
the tables could be different.
I used to do this kind of thing all the time in ASP, but can't work
out the way or approach to do this.
I'm using Framework 2.0, VS Express 2008 and SQL Server 2000.
Many Thanks
Paul
I have a dropdown list that is populated with table names from my
database using SqlDataSource1. When I change the selected index I can
get the table name back from the dropdown and display it in a label.
What I want to do is display the data from the table selected in the
dropdown in the GridView control but I have no idea how to do it. So
basically everytime the user selects a different table from the
dropdown the data is displayed in the GridView. The columns in each of
the tables could be different.
I used to do this kind of thing all the time in ASP, but can't work
out the way or approach to do this.
I'm using Framework 2.0, VS Express 2008 and SQL Server 2000.
Many Thanks
Paul