According to your usual experience, the general class library for SQL Server is written for SQL Server; use system.data; use system.data.sqlclient; use system.Web; Namespace WHGW_LC {/// /// Data's summary description .
/// /// /// /// classes of database-related actions: DarkAngel /// Time: 2004-9-24 /// public class Data {/// /// Connection database string /// 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 "; /// /// database connection object /// protected system.data .sqlclient.sqlConnection DataConnection; /// /// sqldataadapter Object /// protected system.data.sqlclclient.sqldataadapter dataadapter; /// /// SQLCOMMAND object /// protected system.data.sqlclient.sqlcommand datacommand; /// < summary> /// SqlCommandBuilder Object /// protected System.Data.SqlClient.SqlCommandBuilder DataComBuilder; /// /// DataSet Object /// protected System.Data.DataSet DataSet; /// /// DATAROW object /// protected system.data.datarow datarow; /// /// sqlDataReader object /// protected system.data.sqlclient.sqldataReader DataReader; // protected system.web.ui.page mypage; /// /// Constructor /// public data () {// / / TODO: Connection database parameter // // con = Dataconnection = DataConn ();} /// /// database connection parameter property /// public string con {Get {return;} set {Con = Value;}} /// /// Establish Database Connection /// /// Return to Database Connection Object Public SqlConnection DataConn () {SQLConnection DataConnection =
NEW SQLCONNECTION (CON); RETURN DATACONNECTION;} /// /// query result, return /// /// Query statement /// table /// DataSet 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, DAT aconnection); DataAdapter.Fill (MYDS, TABLENAME); RETURN DATASET;} /// /// Query results, return to DataSet, with start and end /// /// query statement /// table name /// starting line /// Termination line /// Return Dataset DataSetQuery (String SQL, String Tablename, Int StarIndex, Int Count) {Dataconnection = DataConn ();
DataAdapter = New SqldataAdapter (SQL, Dataconnection); DataAdApter, DataApter, StarIndex, Count, Tablename; Return DataSet;} /// /// Modify Database content /// /// Query statement /// If the execution is successful, return to the fake 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 ( EXMESSAGE.TOSTRING ()); returnnection.close ();} /// // / Modify DataSet content, and update database /// /// DataSet object /// SQLDataAdapter container /// table name /// Return Dataset Public DataSet Editdata (Dataset Dataset, SqlDataAdapter MyDa, String Tablename) {DatacomBuilder = New SqlcommandBuilder (MyDa); MyDa.Updatec ommand = DataComBuilder.GetUpdateCommand (); myda.DeleteCommand = DataComBuilder.GetDeleteCommand (); myda.InsertCommand = DataComBuilder.GetInsertCommand (); myda.Update (DataSet, TableName); DataSet.AcceptChanges (); return DataSet;} /// /// No parameter stored procedure /// /// Stored Procedure Name /// Perform success Public Bool DataProcedure (String ProcedureName) {Dataconnection = Dataconn (); Dataconnection.Open (); Datacommand = New SqlCommand ();
