The general class library of SQL Server is written according to our usual experience; use system.data; use system.data.sqlclient; use system.web;
Namespace WHGW_LC {/// /// DATA 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, bring start and end /// /// Query statement /// Table name /// starting line /// Termination line /// Back DataSet 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;} /// /// Modify Database content /// /// Query statement /// If the execution is successful, it returns to the false 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 () } /// /// Modify DataSet content, and update database /// /// DataSet object /// Table name /// Return Dataset Public DataSet EditData (Dataset Dataset, SqlDataAdapter MyDa, String Tablename) {DatacomBuilder = New Sqlcommandbuilder (myda); myda.UpdateCommand = DatacomBuilder.getUpdateCommand (); myda.deleteCommand =
