Query about SQLDatasource in ASP.Net 2.0
-
:)Hi all, Greetings.i need a help in sqldatasource configuration in asp.net. i'm using multiple drop down list in a project.for that i've to bound data from three different tables in a database using a single sqldatasource.how can i do this.looking for faster reply. Thanks & Regards Babu
-
:)Hi all, Greetings.i need a help in sqldatasource configuration in asp.net. i'm using multiple drop down list in a project.for that i've to bound data from three different tables in a database using a single sqldatasource.how can i do this.looking for faster reply. Thanks & Regards Babu
The SqlDataSource control only supports a single view, it means you cannot use a single SqlDataSource object to return multiple result sets. Instead, you can use multiple SqlDataSource objects, or write code to return a single dataset object having 3 difference tables and bind it to the dropdownlist controls, also you remember to set the DataMember property accordingly.