C#(SQL-StoreProcedure with commet transaction)

public bool SaveAndEdit()

{

 DALayer layer = new DALayer();

        SqlConnection cn = layer.ReturnConnection();

        SqlTransaction trans = null;

        try

        {

            trans = cn.BeginTransaction();

            string strSql = "<StoreProcedure_Name>";

            SqlCommand command = new SqlCommand(strSql, cn);

            command.CommandType = CommandType.StoredProcedure;

            command.Transaction = trans;

            command.Parameters.AddWithValue("@Parameter01", NString.getString(DBNull.Value));

           

            SqlDataReader reader = command.ExecuteReader();     

            reader.Close();

            trans.Commit();

            if (userId > 0)

            {

                return true;

            }

            else

            {

                return false;

            }

        }

        catch (Exception ex)

        {

            if (trans != null) trans.Rollback();

            return false;

        }

        finally

        {

            cn.Close();

            cn.Dispose();

        }

}