how to create transaction concept in asp.net?

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString))

{

                    con.Open();

                    SqlCommand objSqlCmd = new SqlCommand();

                    SqlTransaction objSqlTrans;

                    objSqlTrans = con.BeginTransaction();

                    objSqlCmd.Transaction = objSqlTrans;

                    try

                    {

                        objSqlCmd.Connection = con;

                        objSqlCmd.CommandType = CommandType.Text;//TEXT OR STORED PROCEDURE

                        objSqlCmd.CommandText = 'YOUR COMMAND OR SP';// DML commands

                        //Parameters if any

                        int result = objSqlCmd.ExecuteNonQuery();//YOUR Execution

                        if (result > 0)

                        {

                            objSqlTrans.Commit();

                            objSqlTrans.Dispose();

                        }

                    }

                    catch (SqlException)

                    {

                       objSqlTrans.Rollback();

                    }

}

Thank you,
Govind

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif