Transaction in ADO.NET for multiple dataTabel

Question

hi, I want to set a single transaction to update multiple DataTable. Now I set transaction for each DataAdapter/dataTable. Is it possible? thanks, Tal

tal mandelson · Answer

thank you very much Akkiraju, I tried to do that but it didn't work. the sda.InsertCommand is null. the thing is that i am working with strongly typed dataSet and datatable. the commands (insert,update,delete) are already there for me. so when I tried to set something to the insertcommand it didn't work also. thanks, tal

Akkiraju Ivaturi · Answer

It should be something as below: Dataset ds = new dataset(); DataTable dt1 = new DataTable("Table1"); DataTable dt2=new DataTable("Table2"); ds.Tables.add(dt1); ds.Tables.add(dt2); SqlDataAdapter sda = new SqlDataAdapter(); SqlConnection cn = new SqlConnection(connectionString); cn.open(); SqlTransaction trans = cn.BeginTransaction(); sda.InsertCommand.Transaction=trans; sda.UpdateCommand.Transaction=trans; sda.DeleteCommand.Transaction=trans; //Do whatever changes you want to do for each data table like insertions, deletions and updations and then update the dataset as below: try { sda.update(ds); trans.commit(); } catch { trans.Rollback(); } cn.close();

Transaction in ADO.NET for multiple dataTabel

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)