Apply Transactions RSS

• • Reply
  The Teacher

  None

  0 Points

  1 Post

  Apply Transactions

  Jan 05, 2013 01:54 PM|The Teacher|LINK

  using System;
  using System.Configuration;
  using System.Data;
  using System.Linq;
  using System.Web;
  using System.Web.Security;
  using System.Web.UI;
  using System.Web.UI.HtmlControls;
  using System.Web.UI.WebControls;
  using System.Web.UI.WebControls.WebParts;
  using System.Xml.Linq;
  using System.Data.SqlClient;
  
  public partial class _Default : System.Web.UI.Page
  {
      protected void Page_Load(object sender, EventArgs e)
      {
  
      }
      protected void btnSave_Click(object sender, EventArgs e)
      {
          string ConStr = "Data Source=ADMIN\\SQLEXPRESS;Database=shail;Integrated Security=True;";
          SqlConnection con = new SqlConnection(ConStr);
          con.Open();
          using (SqlTransaction Trans = con.BeginTransaction())
          {
  
              try
              {
                  SqlCommand com = new SqlCommand("SaveUpdateStuPer",con);
                  com.CommandType = CommandType.StoredProcedure;
                  com.Parameters.AddWithValue("@Action", 0);
                  com.Parameters.AddWithValue("@StdId", 0);
                  com.Parameters.AddWithValue("@Name", txtName.Text);
                  com.Parameters.AddWithValue("@Age", Convert.ToString(txtAge.Text));
                  com.Transaction = Trans;
                  com.ExecuteNonQuery();
  
                  SqlCommand com1 = new SqlCommand("SaveUpdateStuClass", con);
                  com1.CommandType = CommandType.StoredProcedure;
                  com1.Parameters.AddWithValue("@Action", 0);
                  com1.Parameters.AddWithValue("@ClassId", txtClassId.Text);
                  com1.Parameters.AddWithValue("@Class", txtClass.Text);
                  com1.Transaction = Trans;
                  com1.ExecuteNonQuery();
  
                  SqlCommand com2 = new SqlCommand("SaveUpdateStuSub", con);
                  com2.CommandType = CommandType.StoredProcedure;
                  com2.Parameters.AddWithValue("@Action", 0);
                  com2.Parameters.AddWithValue("@SubId", txtSubId.Text);
                  com2.Parameters.AddWithValue("@Subject", txtSubject.Text);
                  com2.Transaction = Trans;
                  com2.ExecuteNonQuery();
  
                  Trans.Commit();
                  con.Close();
                  lblMsg.Text = "Saving Done..";
              }
              catch (Exception ex)
              {
                  Trans.Rollback();
                  lblMsg.Text = "Saving Failed..";
              }
          }
  
          txtName.Text = "";
          txtAge.Text = "";
          txtClassId.Text = "";
          txtClass.Text = "";
          txtSubId.Text = "";
          txtSubject.Text = "";
  
  
      }
  }