using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace dbtest
{
class Program
{
static void Main(string[] args)
{
string ConnectionString = "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI;";
SqlConnection sc = new SqlConnection(ConnectionString);
sc.Open();
SqlTransaction transaction = sc.BeginTransaction();
SqlCommand commmand = new SqlCommand();
commmand.Connection = sc;
commmand.Transaction = transaction;
commmand.CommandText = "update customers set CompanyName='Alfreds Futterkist' where"+ "CustomerID='alfki'";
commmand.ExecuteNonQuery();
commmand.CommandText = "select * from customers where CustomerID='alfki'";
SqlDataReader reader = commmand.ExecuteReader();
while(reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
Console.WriteLine(reader[i]);
}
}
//transaction.Commit();
}
}
}