We have an ASP.NET 2.0 site that uses SQL Server 2000/2005. I am working on a page that updates our user table. But it will also update multiple related tables. For example, the user could be a member of several different companies and/or organizations and may have 1 to many roles out of a list of available roles. These are handled with listboxes and stored in related Companies, Organizations and Role tables, along with normalized linking tables. We are also using the ObjectDataSource control, and
Posted to
Data Access and ObjectDataSource Control
(Forum)
by
nickpup
on
4/19/2007
Filed under: object data source, ObjectDataSource DataSet Multitable, passing object, sql, SQL Performance, Stored Procedures, VB.Net, ADO.NET, ASP.NET, Business Object, Data, Data Access, data set, DataAdapter, Database, databind, DataSet, DataTable, DataView SqlDataSource, design, SQL Server ADO.NET Transactions