Hi,
Can anyone please help me..
im performing insert update and Delete within a transaction and i want to use Select Command.
It is possible to select data with in a Transaction?
My Code--
SqlConnection Con = new SqlConnection(connectionStr);
Con.Open();
SqlTransaction Trans = Con.BeginTransaction();
try
{
CommonMethods.ExecuteNonQueryWithTrans("Insert into tbldata(Name) Values('" + TextBox1.Text.Trim() + "')", Con, Trans);
CommonMethods.ExecuteNonQueryWithTrans("Update tbldata set Name='Surendra'", Con, Trans);
CommonMethods.LoadGridData(GridView1,"Select * from tbldata");
Trans.Commit();
Response.Write("<font color='green'>Transaction Committed Successfully!!</font>");
}
catch (Exception ExX)
{
Trans.Rollback();
Con.Close();
Response.Write("<font color='Red'>Transaction rollbacked due to error!!</font>");
}
If i Use this Like below code im able to use select Command because Transaction is Commited now
and Second option is With Nolock
SqlConnection Con = new SqlConnection(connectionStr);
Con.Open();
SqlTransaction Trans = Con.BeginTransaction();
try
{
CommonMethods.ExecuteNonQueryWithTrans("Insert into tbldata(Name) Values('" + TextBox1.Text.Trim() + "')", Con, Trans);
Trans.Commit();
CommonMethods.LoadGridData(GridView1, "Select * from tbldata");
Response.Write("<font color='green'><b>Transaction Committed Successfully!!</b></font>");
}
catch (Exception ExX)
{
Trans.Rollback();
Con.Close();
Response.Write("<font color='Red'><b>Transaction rollbacked due to error!!<b></font>");
}