Hi All,
I just want to know the concept of commit Transaction and Begin Transaction in Asp.net with c# language, i have no idea about the requested concept,
i have a certain code in c# given below by this i have no idea where i declare commit transaction and begin transaction. please draw a code given below.
my code is:
public void dial(string traid, string trakey, string account, string ttref)
{
try
{
string[] result = new string[4];
SqlConnection sqlconn_cms = new SqlConnection(sqlconn_cmsstr);
{
if (sqlconn_cms.State == ConnectionState.Closed)
{
sqlconn_cms.Open();
}
}
SqlCommand sqlCmd = new SqlCommand("ccTranscationchecktest", sqlconn_cms);
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@traid", traid);
sqlCmd.Parameters.AddWithValue("@trakey", trakey);
sqlCmd.Parameters.AddWithValue("@account", account);
sqlCmd.Parameters.AddWithValue("@transref", ttref);
sqlCmd.ExecuteNonQuery();
sqlconn_cms.Close();
}
catch (Exception ex)
{
}
}
if you drop an solution for me its very useful for me. So please give a solution for that.
thanks in advance