How do I bind a multi-table DataSet to a Web Forms DataGrid
-
How do input a multi-table DataSet to a Web Forms DataGrid that can be inserted, updated, and deleted? Visual Studio 2003, SqlServer DataBase I am trying to create a datagrid that will have fields from 4 separate tables. When I drag in a SqlDataAdapter and add all four tables to my query I get the following Messages: Generate insert statement The original query has a select list that has columns from multiple tables. The statement cannot be generated automatically for this type of query. Generate Update statement The original query has a select list that has columns from multiple tables. The statement cannot be generated automatically for this type of query. Generate Delete statement The original query has a select list that has columns from multiple tables. The statement cannot be generated automatically for this type of query.