using System;
using System.Data;
using System.Data.SqlClient;
using System.Transactions;
//REFDLL System.Data;System.Xml;System.Transactions
public class CSharpLab
{ private static void querySqlServer()
{ string cnStr = "Data Source=theSql;User Id=theUser;Password=thePasswd;";
using (SqlConnection cn = new SqlConnection(cnStr))
{ SqlCommand cmd = new SqlCommand("SELECT getdate() as D", cn); cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
Console.WriteLine(dr["D"]);
cn.Close();
}
}
public static void Test()
{ using (TransactionScope tx=new TransactionScope())
{ querySqlServer();
querySqlServer();
tx.Complete();
}
}
}