Let me describe the scenario iam using
Iam generating xml files at a particular place and sending them to a server
xml1|------->dataset1---------->adapter1.update(dataset1)
xml2|-------->dataset2---------->adapter2.update(dataset2)
xml3|-------->dataset3---------->adapter3.update(dataset3)
all thethree updates should happen in onlyone transaction if any one of the update fails then the transaction should rollback
can anyone tell me a way to do it
i am desperately in search of any ways to do it can anybody help please
If the 3 SqlDataAdapters are using the same connection, maybe you can try to embed the updates in a single transaction opened on the connection:
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myConn"].ToString()))
{
conn.open;
//build your SqlDataAdapters on the same conneciton
SqlTransaction st;
st=conn.BeginTransaction("tran1");
adapter1.update(dataset1);
adapter2.update(dataset2);
adapter3.update(dataset3);
st.Commit();
}
ExecuteReader requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized
This is the error iam getting bcoz iam using the command builder to update the table using dataset cant we use command builder and transaction at the same time
or we should use only sqlcommand to the method
can anybody tell me the solution cant we use transaction and adapter and commandbuilder at the same time
[:'(]
tgopi99: