Update Data Using Transactions : Transactions « Database ADO.net « C# / C Sharp

Update Data Using Transactions

 * C# Programmers Pocket Consultant
 * Author: Gregory S. MacBeth
 * Email: gmacbeth@comporium.net
 * Create Date: June 27, 2003
 * Last Modified Date:
 * Version: 1
using System;
using System.Data;
using System.Data.SqlClient;

namespace Client.Chapter_13___ADO.NET
    public class UpdatingDataUsingTransactions
        static void Main(string[] args)
            SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");


            String MyString = "INSERT INTO Test(ID, Contact, Email)VALUES(1, 'Greg', 'Mac')";
            SqlTransaction MyTransaction = MyConnection.BeginTransaction();
            SqlCommand MyCmd = new SqlCommand(MyString, MyConnection, MyTransaction);


Related examples in the same category

1.Set a savepoint in a transaction
2.Use of a transaction
3.illustrates the use of transactions
4.Transaction roll back and commit
5.Commit two delete sql command