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