using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;namespace StudentDAL.Operator
{
public class DataAccess
{
private SqlConnection objSqlConnection;
private SqlCommand objSqlCommand;
private SqlDataAdapter objSqlDataAdapter;
public DataAccess()
{
//连接数据库
string con="";
try
{
con=ConfigurationManager.ConnectionStrings["sql2000"].ConnectionString;
objSqlConnection=new SqlConnection(con);
objSqlCommand=new SqlCommand("",objSqlConnection);
objSqlDataAdapter=new SqlDataAdapter(objSqlCommand); }catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
}
//使用事物执行对学员信息表和成绩表的数据删除
public bool Del(int id)
{ try
{
objSqlConnection.Open();
//开始事物
objSqlTransaction = objSqlConnection.BeginTransaction();
objSqlCommand.Connection = objSqlConnection;
objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.CommandText = "delete from Student where StudentId=" + id +"";
objSqlCommand.ExecuteNonQuery();
objSqlCommand.CommandText = "delete from Score where StudentId=" + id + "";
objSqlCommand.ExecuteNonQuery();
objSqlTransaction.Commit();
return true; }
catch (Exception ex)
{
Console.WriteLine(ex.Message);
objSqlTransaction.Rollback();
}
finally
{
objSqlConnection.Close();
}
return false;
}
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;namespace StudentDAL.Operator
{
public class DataAccess
{
private SqlConnection objSqlConnection;
private SqlCommand objSqlCommand;
private SqlDataAdapter objSqlDataAdapter;
public DataAccess()
{
//连接数据库
string con="";
try
{
con=ConfigurationManager.ConnectionStrings["sql2000"].ConnectionString;
objSqlConnection=new SqlConnection(con);
objSqlCommand=new SqlCommand("",objSqlConnection);
objSqlDataAdapter=new SqlDataAdapter(objSqlCommand); }catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
}
//使用事物执行对学员信息表和成绩表的数据删除
public bool Del(int id)
{ try
{
objSqlConnection.Open();
//开始事物
objSqlTransaction = objSqlConnection.BeginTransaction();
objSqlCommand.Connection = objSqlConnection;
objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.CommandText = "delete from Student where StudentId=" + id +"";
objSqlCommand.ExecuteNonQuery();
objSqlCommand.CommandText = "delete from Score where StudentId=" + id + "";
objSqlCommand.ExecuteNonQuery();
objSqlTransaction.Commit();
return true; }
catch (Exception ex)
{
Console.WriteLine(ex.Message);
objSqlTransaction.Rollback();
}
finally
{
objSqlConnection.Close();
}
return false;
}
解决方案 »
- 绑定DataGridView问题(在线等)
- 我的电脑--属性--外观--“窗口和按钮”修改为:Windows 经典。用c#代码怎么实现?修改注册表里面的那些字段呢?
- 关于"Open File"对话框选择文件后的处理问题
- 判断所有子线程都以结束?
- 一个封锁操作被对WSACancelBlockingCall的调用中断(在线)
- 关于System.InvalidOperationException: 句柄未初始化的问题
- c# showdialog(this) 与showdialog()的不同??
- 求助:vs2005新建网站没有ASP.net模板
- C#编译错误!
- window ce 程序检测是否连接到webservice服务器
- 我的XP SP2无法安装VS2005,提示未能安装NET Famework 2.0, Error code 1603
- C#索引器中的异常
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Configuration; namespace StudentDAL.Operator
{
public class DataAccess
{
private SqlConnection objSqlConnection;
private SqlCommand objSqlCommand;
private SqlDataAdapter objSqlDataAdapter;
public DataAccess()
{
//连接数据库
string con="";
try
{
con=ConfigurationManager.ConnectionStrings["sql2000"].ConnectionString;
objSqlConnection=new SqlConnection(con);
objSqlCommand=new SqlCommand("",objSqlConnection);
objSqlDataAdapter=new SqlDataAdapter(objSqlCommand); }catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
}
//使用事物执行对学员信息表和成绩表的数据删除
public bool Del(int id)
{ try
{
objSqlConnection.Open();
//开始事物
objSqlTransaction = objSqlConnection.BeginTransaction();
objSqlCommand.Connection = objSqlConnection;
objSqlCommand.Transaction = objSqlTransaction;
objSqlCommand.CommandText = "delete from Student where StudentId=" + id +" delete from Score where StudentId=" + id + "";
objSqlCommand.ExecuteNonQuery();
objSqlTransaction.Commit();
return true; }
catch (Exception ex)
{
Console.WriteLine(ex.Message);
objSqlTransaction.Rollback();
}
finally
{
objSqlConnection.Close();
}
return false;
}
//开始事物
objSqlCommand.Connection = objSqlConnection;
SqlTransaction tran=objSqlCommand.Transaction.BeginTransaction();
objSqlCommand.CommandText = "delete from Student where StudentId=" + id +"";
objSqlCommand.ExecuteNonQuery();
objSqlCommand.CommandText = "delete from Score where StudentId=" + id + "";
objSqlCommand.ExecuteNonQuery();
tran.Commit();
return true;
点都点不出的
不好意思。好久没用了。忘记了,应该是connection中的BeginTransaction