#region 查询数据 public void SelectData(SqlDataAdapter DataAdapter, string CommandText, string TableName)
{
baseCommand.Connection = baseConnection;
baseCommand.CommandText = CommandText;
DataAdapter.SelectCommand = baseCommand;
if (TableName != "") DataAdapter.TableMappings.Add("Table", TableName);
baseConnection.Close();
} public void SelectData(SqlDataAdapter DataAdapter, string CommandText)
{
SelectData(DataAdapter, CommandText, "");
} public void SelectData(DataSet DataSet, string CommandText, string TableName)
{
SelectData(baseDataAdapter, CommandText, TableName);
if (TableName == "")
{
baseDataAdapter.Fill(DataSet);
}
else
{
baseDataAdapter.Fill(DataSet, TableName);
}
} public void SelectData(DataSet DataSet, string CommandText)
{
SelectData(DataSet, CommandText, "");
} public void SelectData(string xmlFileName, string CommandText, string TableName)
{
DataSet dataSet = new DataSet(TableName);
SelectData(dataSet, CommandText, TableName);
dataSet.WriteXml(xmlFileName);
dataSet.Dispose();
} public void SelectData(string xmlFileName, string CommandText)
{
SelectData(xmlFileName, CommandText, "");
}
#endregion #region 更新数据 public void UpdateData(string CommandText)
{
baseCommand.Connection = baseConnection;
baseCommand.CommandText = CommandText;
try
{
baseCommand.ExecuteNonQuery();
}
catch(SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
}
public void UpdateData(DataSet MyDataSet, string MyTableName)
{
SqlDataAdapter TmpDataAdapter = new SqlDataAdapter("Select * From " + MyTableName, ConnectionString); TmpDataAdapter.Update(MyDataSet, MyTableName);
} public void UpdateData(SqlDataAdapter MyDataAdapter, DataSet MyDataSet, string MyTableName)
{
MyDataAdapter.Update(MyDataSet, MyTableName);
}
#endregion #region 事务控制
//开始执行事务
public void TransactionBegin()
{
baseTransaction = baseConnection.BeginTransaction();
baseCommand.Transaction = baseTransaction;
}
//执行事物
public void TransactionExecute(string CommandText)
{
//TransactionBegin();
try
{
baseCommand.CommandText = CommandText;
baseCommand.ExecuteNonQuery();
//baseTransaction.Commit();
}
catch
{
baseTransaction.Rollback();
//MessageBox.Show( "输入有错误,请重新输入!","信息",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
finally
{
baseConnection.Close();
} //baseCommand.CommandText = CommandText;
//int testcount = baseCommand.ExecuteNonQuery();
}
//完成事务
public void TransactionCommit()
{
baseTransaction.Commit();
}
//取消事务
public void TransactionRollback()
{
baseTransaction.Rollback();
}
#endregion
{
baseCommand.Connection = baseConnection;
baseCommand.CommandText = CommandText;
DataAdapter.SelectCommand = baseCommand;
if (TableName != "") DataAdapter.TableMappings.Add("Table", TableName);
baseConnection.Close();
} public void SelectData(SqlDataAdapter DataAdapter, string CommandText)
{
SelectData(DataAdapter, CommandText, "");
} public void SelectData(DataSet DataSet, string CommandText, string TableName)
{
SelectData(baseDataAdapter, CommandText, TableName);
if (TableName == "")
{
baseDataAdapter.Fill(DataSet);
}
else
{
baseDataAdapter.Fill(DataSet, TableName);
}
} public void SelectData(DataSet DataSet, string CommandText)
{
SelectData(DataSet, CommandText, "");
} public void SelectData(string xmlFileName, string CommandText, string TableName)
{
DataSet dataSet = new DataSet(TableName);
SelectData(dataSet, CommandText, TableName);
dataSet.WriteXml(xmlFileName);
dataSet.Dispose();
} public void SelectData(string xmlFileName, string CommandText)
{
SelectData(xmlFileName, CommandText, "");
}
#endregion #region 更新数据 public void UpdateData(string CommandText)
{
baseCommand.Connection = baseConnection;
baseCommand.CommandText = CommandText;
try
{
baseCommand.ExecuteNonQuery();
}
catch(SqlException ae)
{
MessageBox.Show(ae.Message.ToString());
}
}
public void UpdateData(DataSet MyDataSet, string MyTableName)
{
SqlDataAdapter TmpDataAdapter = new SqlDataAdapter("Select * From " + MyTableName, ConnectionString); TmpDataAdapter.Update(MyDataSet, MyTableName);
} public void UpdateData(SqlDataAdapter MyDataAdapter, DataSet MyDataSet, string MyTableName)
{
MyDataAdapter.Update(MyDataSet, MyTableName);
}
#endregion #region 事务控制
//开始执行事务
public void TransactionBegin()
{
baseTransaction = baseConnection.BeginTransaction();
baseCommand.Transaction = baseTransaction;
}
//执行事物
public void TransactionExecute(string CommandText)
{
//TransactionBegin();
try
{
baseCommand.CommandText = CommandText;
baseCommand.ExecuteNonQuery();
//baseTransaction.Commit();
}
catch
{
baseTransaction.Rollback();
//MessageBox.Show( "输入有错误,请重新输入!","信息",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
finally
{
baseConnection.Close();
} //baseCommand.CommandText = CommandText;
//int testcount = baseCommand.ExecuteNonQuery();
}
//完成事务
public void TransactionCommit()
{
baseTransaction.Commit();
}
//取消事务
public void TransactionRollback()
{
baseTransaction.Rollback();
}
#endregion
解决方案 »
- C#中的dev控件,怎么获取gridcontrol过滤后的数据源
- 自定义打印模板
- datagrid导出到excel或word问题
- 在VS2005里调试C#程序。
- 超简单问题,刚刚发错在ASP区了,试下就给
- ListBox中怎么实现自动换行
- c#读取Excel2003中的数据时出现错误!!小弟不知道该怎么解决。那位老大来帮帮忙啊!!!!
- C#中窗体排列
- C# 状态栏的 Label 如何设定成扩充整个空间
- 给ListView控件增加列标题,没有起作用啊
- 安装 Crystal Report 9.2 后,Crystal Report Viewe 创建及复制时,VS.NET 时产生问题解疑(作者:海波.NET,更新:2003-10-19)
- 如何设计才叫多层???
using System;
using System.IO;
using System.Runtime.InteropServices;
using System.Text;
using Atu;namespace Atu
{
/// <summary>
/// Ini 的摘要说明。
/// </summary>
public class Ini
{
// INI文件名
private string FileName; public Ini(string FileName)
{
this.FileName = FileName;
} // 声明写INI文件的API函数
[DllImport("kernel32")]
public static extern long WritePrivateProfileString(string section,string key,string val,string filePath); // 声明读INI文件的API函数
[DllImport("kernel32")]
private static extern int GetPrivateProfileString(string section,string key, string def, StringBuilder retVal,int size,string filePath);
// 写INI文件
public static void IniWriteValue(string FileName, string Section, string Key, string Value)
{
WritePrivateProfileString(Section, Key, Value, FileName);
} public void IniWriteValue(string Section, string Key, string Value)
{
WritePrivateProfileString(Section, Key, Value, this.FileName);
} // 读取INI文件
public static string IniReadValue(string FileName, string Section, string Key)
{
StringBuilder temp = new StringBuilder(255);
GetPrivateProfileString(Section, Key, "无法读取对应数值!", temp, 255, FileName);
return temp.ToString();
} public string IniReadValue(string Section, string Key)
{
StringBuilder temp = new StringBuilder(255);
GetPrivateProfileString(Section,Key,"无法读取对应数值!",temp,255,this.FileName);
return temp.ToString();
}
}
}