Multiple tables updation using Enterprise Library

Topics: Data Access Application Block, Enterprise Library Core, General discussion, Pre-release discussions
Feb 6, 2007 at 6:04 AM
I am using Enterprise Library to retrive data from 3 tables in sql server database(using 1 sql statement only).One master and two child tables.



Then i want to store data in dataset and dispaly it in gridview. then on edit i want to edit data in in three diffrent forms. Every control i.e gridview, forms, buttons will be on same page.

Now using Adapter i want to perform insertion, updation and deletion in a single transaction. How can i do this using Enterprise Library?

Feb 8, 2007 at 4:12 PM
I recommend checking out the quickstarts that come with Enterprise Library. It has examples of using the DAAB with DataSets.

I also recommend the ASP.NET 2.0 Data Tutorials. There is an extensive list of examples using ADO.NET with many of them discussing master-detail relationships:

http://www.asp.net/learn/dataaccess/default.aspx?tabid=63

Regards,

Dave

_________________

David Hayden
Microsoft MVP C#