Insert Data more than 1 Table using Transaction

Insert Data more than 1 Table using Transaction

using System;

using System.Collections;

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 Default3 : System.Web.UI.Page

{

    SqlConnection cn = new SqlConnection();

    SqlCommand cmd = new SqlCommand();

    SqlTransaction Tr;  // Create transcation
object

   

  

    DataTable dt = new DataTable();

    protected void Page_Load(object sender, EventArgs e)

    {

    
cn.ConnectionString = @"Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated
Security=True;User Instance=True";

    
cn.Open();

    }

    protected void Button2_Click(object sender, EventArgs e)

    {

    
Tr = cn.BeginTransaction();
// Begin Transaction

    
cmd.Connection = cn;

     cmd.Transaction = Tr;
// Assign Transaction object value to the command object

    
try    // Try block for Error
checking block

    
{

cmd.CommandText =  
"INSERT INTO employee(eid,ename,epass)VALUES(@eid,@ename,@epass)";

cmd.Parameters.AddWithValue("@eid", TextBox1.Text); // @eid used in insert query;

   
cmd.Parameters.AddWithValue("@ename",TextBox2.Text);
// @ename used in insert query;

    
cmd.ExecuteNonQuery();

        
cmd.CommandText = "INSERT
INTO password(eid,epass)VALUES(@eid,@epass)";

        
cmd.Parameters.AddWithValue("eid", TextBox1.Text);

       
cmd.Parameters.AddWithValue("@epass",TextBox3.Text);

        
cmd.ExecuteNonQuery();

        
Tr.Commit();   // Commint
statement save the transcation complete

    

    
}

    
catch (Exception a)  // Cathch block is used for catching the  error type in try block

    
{

        
Tr.Rollback(); // Now rollback statement undo the changes and not saved data

    
}

    }

   

}