how to implement sql transaction in 3 tier architecture.

Yes. You can use sqltransaction in your data access layer.

Please refer this article in Code Project and if you still need any help, please reply and I'll assist you accordingly.

Using Transactions in ADO.NET

Here are few articles which give you the idea about transactions:
A Beginner's Tutorial for Understanding Transactions and TransactionScope in ADO.NET[^]
All About TransactionScope[^]
Transaction in .NET Application[^]

Hope it helps.

Hi,

Adding one more link for reference.

http://www.c-sharpcorner.com/UploadFile/rohatash/performing-sql-server-transaction-using-ado-net/[^]

Thanks

protected void btnSumbit_Click(object sender, EventArgs e)
{
//Begin Transaction
string conn = ConfigurationManager.AppSettings["YourConnectionString"];
SqlConnection objConnection = new SqlConnection(conn);
SqlTransaction trans = objConnection.BeginTransaction();
try
{


InsertData(ref trans, objConnection);
//Do Multiple Operations
trans.Commit();
}
catch
{

//Rollback Transaction
trans.Rollback();
}



}
private void InsertData(ref SqlTransaction trans, SqlConnection objConnection)
{
//Delete Product
SqlCommand cmd = new SqlCommand("Delete From Table Where ID=1", objConnection, trans);

cmd.ExecuteNonQuery();
}


//Put InsertData function in any Tier
www.learnlogic.blogspot.com

Ok 3 Tier.....

Ok I'd create a method in my data access layer which creates and adds a transaction to my current connection.

Then I would call this through my BusinessLogic when Inserting and Updating my records. So I would have a class in BusinessLogic SystemMethods, or something to that affect.

Then wherever I am doing my processing I would just call using(DbTransaction _trans = SystemMethods.CreateTransaction())
{
try
{
//add here
_trans.Commit();
}
catch(Exception ex)
{
_trans.Rollback();
}

}

hope that helps......

/Begin Transaction
SqlTransaction trans = conn.BeginTransaction("RemoveProducts");


//Delete Product
SqlCommand cmd = new SqlCommand("", conn, trans);
cmd.CommandText = "Delete from Products where ID=5";
cmd.ExecuteNonQuery();


//Save Transaction
trans.Save("ProductRemoved");

//Delete another product
cmd.CommandText = "Delete from Products where ID=13";
cmd.ExecuteNonQuery();

//Rollback Transaction to Save Point
trans.Rollback("ProductRemoved");