UC知道VS高手来看一下
来源：百度知道 编辑：UC知道 时间：2024/06/23 17:03:44
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string connectString = "Data Source=3A3D55782164CA\\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";
SqlConnection cn = new SqlConnection();
cn.ConnectionString = connectString;
cn.Open();
SqlTransaction tran = null;
try
{
tran = cn.BeginTransaction();
SqlCommand cmd = new SqlCommand("Delect Production.Culture where CultureID=ar",cn,tran);
cmd.ExecuteNonQuery();
tran.Commit();
Console.WriteLine("Transaction Committed\n");
}
catch (SqlException ex)
{
tran.Rollback();
{
class Program
{
static void Main(string[] args)
{
string connectString = "Data Source=3A3D55782164CA\\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";
SqlConnection cn = new SqlConnection();
cn.ConnectionString = connectString;
cn.Open();
SqlTransaction tran = null;
try
{
tran = cn.BeginTransaction();
SqlCommand cmd = new SqlCommand("Delect Production.Culture where CultureID=ar",cn,tran);
cmd.ExecuteNonQuery();
tran.Commit();
Console.WriteLine("Transaction Committed\n");
}
catch (SqlException ex)
{
tran.Rollback();
Delect Production.Culture where CultureID=ar
SQL语句有错，具体错误是什么在在不知道你的表结构之前不好猜度，建议你把SQL语句放到查询分析器里测试
附：delete打错了
哪个".”附近啊?
另外我觉得应该在catch那加上:tran.rollback()
new SqlCommand("Delect Production.Culture //这句有错误
是 Delete 不是Delect
如果你是要删除Production表中CultureID为ar的记录的话,
SQL语句应该这么写
Delect Production where CultureID=ar;;
如果你的表名是Production.Culture的话,请这样写:
Delete [Production.Culture]
同意2楼