根据自己平时的经验写的针对SQLSERVER操作的通用类库 using System; using System.Data; using System.Data.SqlClient; using System.Web;
namespace Whgw_lc { /// <summary> /// Data 的摘要说明。 /// </summary> /// <summary> /// 数据库相关操作类 /// 作者:DarkAngel /// 时间:2004-9-24 /// </summary> public class Data { /// <summary> ///连接数据库字符串 /// </summary> protected static string con="data source=10.68.19.203;initial catalog=Whgw;persist security info=False;user id=sa;password=sc2000;workstation id=DARKANGEL;packet size=4096"; /// <summary> /// 数据库连接对象 /// </summary> protected System.Data .SqlClient.SqlConnection DataConnection; /// <summary> /// SqlDataAdapter对象 /// </summary> protected System.Data.SqlClient.SqlDataAdapter DataAdapter; /// <summary> /// SqlCommand对象 /// </summary> protected System.Data.SqlClient.SqlCommand DataCommand; /// <summary> /// SqlCommandBuilder对象 /// </summary> protected System.Data.SqlClient.SqlCommandBuilder DataComBuilder; /// <summary> /// DataSet对象 /// </summary> protected System.Data.DataSet DataSet; /// <summary> /// DataRow对象 /// </summary> protected System.Data.DataRow DataRow; /// <summary> /// SqlDataReader对象 /// </summary> protected System.Data.SqlClient.SqlDataReader DataReader; //protected System.Web.UI.Page mypage; /// <summary> ///构造函数 /// </summary> public Data() { // // TODO: 连接数据库参数 // //con= DataConnection=DataConn(); } /// <summary> /// 数据库连接参数属性 /// </summary> public string Con { get{return con;} set{con= value;} } /// <summary> /// 建立数据库连接 /// </summary> /// <returns>返回数据库连接对象</returns> public SqlConnection DataConn() { SqlConnection DataConnection=new SqlConnection(Con); return DataConnection; } /// <summary> /// 查询结果,返回 /// </summary> /// <param name="mysql">查询语句</param> /// <returns>返回datareader</returns> public SqlDataReader DataQuery(string Sql) { DataConnection=DataConn(); DataConnection.Open(); DataReader=null; DataCommand=new SqlCommand(Sql,DataConnection); DataReader=DataCommand.ExecuteReader(); return DataReader; } /// <summary> /// 查询结果,返回DataSet /// </summary> /// <param name="mysql">查询语句</param> /// <param name="tabName">表名</param> /// <returns>DataSet</returns> public virtual DataSet DataSetQuery(string Sql,string TableName) { DataConnection=DataConn(); DataConnection.Open(); DataAdapter=new SqlDataAdapter(Sql,DataConnection); DataSet=new DataSet(); DataAdapter.Fill(DataSet,TableName); return DataSet; } public DataSet DataSetQuery(DataSet myds,string TableName,string Sql) { DataConnection=DataConn(); DataConnection.Open(); DataAdapter=new SqlDataAdapter(Sql,DataConnection); DataAdapter.Fill(myds,TableName); return DataSet;
} /// <summary> /// 查询结果,返回DataSet,带起始和结束 /// </summary> /// <param name="mysql">查询语句</param> /// <param name="tabName">表名</param> /// <param name="starIndex">起始行</param> /// <param name="count">终止行</param> /// <returns>返回DataSet</returns> public DataSet DataSetQuery(string Sql,string TableName,int StarIndex,int Count) { DataConnection=DataConn(); DataConnection.Open(); DataAdapter=new SqlDataAdapter(Sql,DataConnection); DataSet=new DataSet(); DataAdapter.Fill(DataSet,StarIndex,Count,TableName); return DataSet; } /// <summary> /// 修改数据库内容 /// </summary> /// <param name="mysql">查询语句</param> /// <returns>如果执行成功返回真,否者返回假</returns> public bool EditData(string Sql) { DataConnection=DataConn(); DataConnection.Open(); DataCommand=new SqlCommand(Sql,DataConnection); try { DataCommand.ExecuteNonQuery(); return true; } catch(Exception ex) { System.Console.Write(ex.Message.ToString()); return false; } DataConnection.Close(); } /// <summary> /// 修改DataSet内容,并更新数据库 /// </summary> /// <param name="DataSet">DataSet对象</param> /// <param name="myda">SqlDataAdapter容器</param> /// <param name="tbName">表名</param> /// <returns>返回DataSet</returns> public DataSet EditData(DataSet DataSet,SqlDataAdapter myda,string TableName) { DataComBuilder=new SqlCommandBuilder(myda); myda.UpdateCommand=DataComBuilder.GetUpdateCommand(); myda.DeleteCommand=DataComBuilder.GetDeleteCommand(); myda.InsertCommand=DataComBuilder.GetInsertCommand(); myda.Update(DataSet,TableName); DataSet.AcceptChanges(); return DataSet; } /// <summary> /// 无参数存储过程的执行 /// </summary> /// <param name="proName">存储过程名称</param> /// <returns>是否执行成功</returns> public bool DataProcedure(string ProcedureName) { DataConnection=DataConn(); DataConnection.Open(); DataCommand=new SqlCommand(); DataCommand.CommandText=ProcedureName; & [1] [2] 下一页 [办公软件]在sybase中插入图片、PDF、文本文件 [办公软件]安装Sybase ASE [办公软件]linux指令大全(完整篇) [办公软件]Linux新手入门常用命令大全 [办公软件]在RedHat Linux 9里安装gaim0.80 [办公软件]浅谈Linux 下Java 1.5 汉字方块问题解决方法 [办公软件]Linux程序员必读:中文化与GB18030标准 [办公软件]linux指令大全 [办公软件]制作Linux启动盘的四种方法 [办公软件]Linux文件系统的反删除方法
|