hi all,
i'm developing a WebApplication with VisualStudio2005 (with C# code).
i've defined a DataSet with some TableAdatpter. For each TableAdapter, i've definet some "customized" commands, performing specialized operations over the table on DB. (db is SqlServer2000).
For each TableAdapter, i've set as "public" the connection, so that i can use it within my code for beginning a new transaction. Now, how can i set that transaction, to the specialized commands I defined for each TableAdapter?
Thanks all.
Andrea.
Hi Andrea,
I think you can begin transactions by doing db.BeginTransaction and then transferring the same db to through the different commands so that the whole set of operations take place as one Transaction(hope this is ur requirement!) and once you have filled the adapters u can commit the transaction.
sql