c#中数据库操作--

《c#中数据库操作--》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、C#中数据库操作>>/********************************功能：数据库操作相关*：FlashICP*时间：2005-7-22*******************************/usingSystem;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.espacemoban{publicclassdata{protectedstaticstringcon="server=[yourserver];database=[yourdata

2、];userid=[yourid];pass.Data.SqlClient.SqlConnectionDataConnection;//数据库连接对象protectedSystem.Data.SqlClient.SqlDataAdapterDataAdapter;//SqlDataAdapter对象protectedSystem.Data.SqlClient.SqlmandDatamand;//Sqlmand对象protectedSystem.Data.SqlClient.SqlmandBuilderDataBuilder;//S

3、qlmandBuilder对象protectedSystem.Data.DataSetDataSet;//DataSet对象protectedSystem.Data.DataRo.Data.SqlClient.SqlDataReaderDataReader=null;//构造函数publicdata(){DataConnection=DataConn();}//连接数据库参数publicstringCon{get{returncon;}set{con=value;}}//数据库连接参数publicSqlConnectionData

4、Conn(){DataConnection=neand=neand(Sql,DataConnection);DataReader=Datamand.ExecuteReader();Datamand.Dispose();returnDataReader;}//返回DataSetpublicvirtualDataSetDataSetQuery(stringSql,stringTableName){DataConnection=DataConn();DataAdapter=nee);DataAdapter.Dispose();DataC

5、onnection.Close();DataConnection.Dispose();returnDataSet;}//返回DataSetpublicDataSetDataSetQuery(DataSetmyds,stringTableName,stringSql)123下一页>>>>这篇文章来自..，。{DataConnection=DataConn();DataAdapter=neyds,TableName);DataConnection.Close();DataConnection.Dispose();returnDataS

6、et;}//返回DataSetpublicDataSetDataSetQuery(stringSql,stringTableName,intStarIndex,intCount){DataConnection=DataConn();DataConnection.Open();DataAdapter=nee);DataConnection.Close();DataConnection.Dispose();returnDataSet;}publicvoidDataDo(stringsqlstr){DataConnection=Data

7、Conn();Sqlmandmy=DataConnection.Createmand();my.mandText=sqlstr;DataConnection.Open();my.ExecuteNonQuery();DataConnection.Close();}//返回DataSet开始行到结束行publicboolEditData(stringSql){DataConnection=DataConn();DataConnection.Open();Datamand=neand(Sql,DataConnection);try{Da

8、tamand.ExecuteNonQuery();DataConnection.Close();returntrue;}catch(Exceptionex){System.Console.essage.ToString());DataConnect