哪位能给这个ADO.NET的SQL Server引擎把事物控制和数据库更新,添加上去或修改!100分!
下面是一个数据访问的引擎,里面的查询部分都没有问题了,但是事物控制和数据库更新部分有问题,哪位知道是什么错误或则能添加上去吗?
using System;
using System.Collections;
using System.Windows.Forms;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using Atu;
using System.Diagnostics;
namespace Atu.DataModules
{
/// <summary>
/// DataModule 的摘要说明。
/// </summary>
public class DMSqlServer
{
// INI文件名
private string IniFileName = "";
private string Section = "";
private string ConnectionString = "";
#region 数据库连接引擎的配置参数声明
private string data_source;
private string initial_catalog;
private string integrated_security;
private string persist_security_info;
private string user_id;
private string workstation_id;
private string packet_size;
private string password;
private string connect_timeout;
#endregion
#region 数据库操作的数据控件声明
private SqlConnection baseConnection;
private SqlTransaction baseTransaction;
private SqlCommand baseCommand;
private BindingContext bindingContext;
private SqlDataAdapter baseDataAdapter;
#endregion
public DMSqlServer()
{
// 初始化
InitDMSqlServer();
}
public DMSqlServer(string IniFileName, string Section)
{
// 设置读取配置文件属性
this.IniFileName = IniFileName;
this.Section = Section;
// 初始化
InitDMSqlServer();
}
public DMSqlServer(string ConnectionString)
{
// 设置连接属性
this.ConnectionString = ConnectionString;
// 初始化
InitDMSqlServer();
}
public void InitDMSqlServer()
{
try
{
// 初始化连接属性
SetConnectionString();
// 创建连接对象并打开它
baseConnection = new SqlConnection(ConnectionString);
baseConnection.Open();
baseCommand = new SqlCommand();
bindingContext = new BindingContext();
baseDataAdapter = new SqlDataAdapter();
baseCommand.Connection = baseConnection;
}
catch
{
MessageBox.Show( "数据库连接失败!","信息",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
#region 记录/读取程序设置
//Windows方式
private void LoadIniWindows()
{
data_source = Atu.Ini.IniReadValue (IniFileName, Section, "data_source");
initial_catalog = Atu.Ini.IniReadValue (IniFileName, Section, "initial_catalog");
integrated_security = Atu.Ini.IniReadValue (IniFileName, Section, "integrated_security");
persist_security_info = Atu.Ini.IniReadValue (IniFileName, Section, "persist_security_info");
user_id = Atu.Ini.IniReadValue (IniFileName, Section, "user_id");
workstation_id = Atu.Ini.IniReadValue (IniFileName, Section, "workstation_id");
packet_size = Atu.Ini.IniReadValue (IniFileName, Section, "packet_size");
connect_timeout = Atu.Ini.IniReadValue (IniFileName, Section, "connect_timeout");
}
//SqlServer方式
private void LoadIniSqlServer()
{
workstation_id = Atu.Ini.IniReadValue(IniFileName,Section,"workstation_id");
data_source = Atu.Ini.IniReadValue(IniFileName,Section,"data_source");
initial_catalog = Atu.Ini.IniReadValue(IniFileName,Section,"initial_catalog");
packet_size = Atu.Ini.IniReadValue(IniFileName,Section,"packet_size");
password = Atu.Ini.IniReadValue(IniFileName,Section,"password");
persist_security_info = Atu.Ini.IniReadValue(IniFileName,Section,"persist_security_info");
user_id = Atu.Ini.IniReadValue(IniFileName,Section,"user_id");
connect_timeout = Atu.Ini.IniReadValue (IniFileName, Section, "connect_timeout");
}
#endregion
//设置Ini文件的位置
private void SetIniFileName()
{
if (IniFileName == "") IniFileName = Application.StartupPath + "\\Ini.ini";
}
//设置Ini文件的Section
private string SetIniSectionSqlServerConnection()
{
if (Section == "") Section = "Connection1";
return Section;
}
private string SetIniSectionWindowsConnection()
{
if (Section == "") Section = "WindowsConnection";
return Section;
}
#region 创建连接字符串
public void SetConnectionString()
{
if ( Section == "WindowsConnection")
{
SetIniFileName();
LoadIniWindows();
ConnectionString = "workstation id="+ workstation_id +";"+
"packet size="+ packet_size+";"+
"user id=" + user_id +";"+
"integrated security="+ integrated_security +";"+
"data source=" + data_source +";"+
"persist security info=" + persist_security_info+";"+
"initial catalog=" + initial_catalog +";"+
"Connect Timeout="+connect_timeout;
}
else
{
SetIniSectionSqlServerConnection();
SetIniFileName();
LoadIniSqlServer();
ConnectionString = "workstation id="+ workstation_id +";"+
"packet size="+ packet_size+";"+
"user id=" + user_id +";"+
"data source=" + data_source +";"+
"persist security info=" + persist_security_info+";"+
"initial catalog=" + initial_catalog +";"+
"password=" + password+";"+
"initial catalog=" + initial_catalog +";"+
"Connect Timeout="+connect_timeout;
}
}
#endregion