For some time, engage in .NET, some database operations, if each is written so much. It is not exhausted, I want to write a class, put the operation, because I am studying it. Net is only 1, 2 weeks, I don't want to change it, I don't want to change again, my personal thinking is fixed, how The change is almost almost, hehe ~~ First in the web.config file:
Namespace Dboprate {///
public string SelectString {set {objSelectString = value;}} public string InsertString {set {objInsertString = value; DBInsert ();}} public string UpdateString {set {objUpdateString = value; DBUpdate ();}} public string DeleteString {set { objDeleteString = value; DBDelete ();}} public string ErrMessage {get {tempErrMessage = objErrMessage; objErrMessage = null; return tempErrMessage;}} public SqlDataReader DR {get {GetDR (); return objDR;}} public void DRClose () { objDR.Close ();} public void GetDR () {try {using (objCmd = new SqlCommand (objSelectString, objConn)) {objDR = objCmd.ExecuteReader ();}} catch (System.Exception e) {objErrMessage = "data Read the error: "; ObjerrMessage ="
"; ObjerrMessage = E.Message; ObjerrMessage ="
";}} public void objdrread () {objdr.read ();} public bool selectempty () {IF (Objdr.Read ()) Return False; E lse return true;} public string GetDRItem (string objDRItem) {return objDR [objDRItem] .ToString ();} public DataSet DS {get {try {using (objDA = new SqlDataAdapter (objSelectString, objConn)) {objDS = new DataSet ( ); Objda.fill (Objds);}} catch (system.exception e) {ObjerrMessage = "data read error:"; ObjerrMessage = "
"; ObjerrMessage = E.MESSAGE; ObjerrMessage = "
" } Returnobjds;}} public dataview dw {get {{using (objda =
new SqlDataAdapter (objSelectString, objConn)) {objDS = new DataSet (); objDA.Fill (objDS); objDW = new DataView (objDS.Tables [0]); objDW.RowFilter = objViewRowFilter; objDW.Sort = objViewSort;}} catch (System.Exception e) {objErrMessage = "error data read:"; objErrMessage = "
"; objErrMessage = e.Message; objErrMessage = "
";} return objDW;}} public DataGrid DGridBindDS { set {objDataGrid = value; BindDS ();}} public DataGrid DGridBindDR {set {objDataGrid = value; BindDR ();}} public string ViewRowFilter {set {if (objViewRowFilter == null) {objViewRowFilter = value;} else {objViewRowFilter = "and"; objViewRowFilter = value;}}} public string ViewSort {set {objViewSort = value;}} private void BindDR () {try {using (objCmd = new SqlCommand (objSelectString, objConn)) {objDR = objCmd.ExecuteReader (); ObjDataGrid.datasource = OBJ DR; objDataGrid.database (); objdr.close ();}} catch (system.exception e) {ObjerrMessage = "data read error:"; ObjerrMessage = "
"; ObjerrMessage = E.MESSAGE; ObjerrMessage = "
";}} private void BindDS () {try {using (objDA = new SqlDataAdapter (objSelectString, objConn)) {objDS = new DataSet (); objDA.Fill (objDS); objDataGrid.DataSource = objDS; objDataGrid .DATABIND ();}} catch (system.exception e) {ObjerrMessage = "
