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 (insertupdatedelete) 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();