ADO Universal Access Class

PublicclassDbhelpersql {PrivateStatic stringconnstring = configurationmanager.connectionstrings["SqlDataSource"].        ToString (); #regionGet a connection Channel/// <summary>        ///get a connection channel/// </summary>        /// <returns></returns>PublicStaticSqlConnection Createconn () {returnNewSqlConnection (connstring); }        #endregion        #regionGet Data source/// <summary>        ///Get Data source/// </summary>        /// <param name= "SQL" ></param>        /// <param name= "parms" ></param>        /// <returns></returns>PublicStaticDataSet Query (stringsql, CommandType cmdtype = CommandType.Text, params sqlparameter[] parms) {DataSet dt =NewDataSet (); using (SqlConnection conn = Createconn ()) {SqlDataAdapter da =NewSqlDataAdapter (); SqlCommand cmd =NewSqlCommand (SQL, conn);                Cmd.commandtype = Cmdtype; if(Parms! =NULL) {cmd.                Parameters.addrange (parms); } da.                SelectCommand = cmd; Da.            Fill (DT);        } return DT; }        #endregion        #regionExecution transactions/// <summary>        ///Execution Transactions/// </summary>        /// <param name= "SQL" >Stored Procedure name</param>        /// <param name= "Parmslist" >The parameters contained in each stored procedure</param>        /// <returns></returns>PublicStatic intExectran (stringsql, list<sqlparameter[]> parmslist,commandtype cmdtype = commandtype.text) {            introw =0; using (SqlConnection conn = Createconn ()) {Conn.                Open (); SqlTransaction TRAN = conn.                BeginTransaction (); SqlCommand cmd =NewSqlCommand (SQL, Conn, Tran);                Cmd.commandtype = Cmdtype; if(Parmslist! =NULL&& parmslist.count>0) {foreach (sqlparameter[] parmsinchparmslist) {cmd.                        Parameters.clear (); if(Parms! =NULL) {cmd.                        Parameters.addrange (parms); }                         Try{row + = cmd.                        ExecuteNonQuery (); } catch {tran.                            Rollback (); Return0;                }} tran.commit ();        }} return row; }        #endregion        #regionExecuting transactions that contain primary and child tables/// <summary>        ///executing transactions that contain primary and child tables/// </summary>        /// <param name= "Mainsql" >Main Table stored procedures</param>        /// <param name= "Mainparmslist" >parameters contained in the main table stored procedure</param>        /// <param name= "Childsql" >child table Stored procedures</param>        /// <param name= "childparmslist" ></param>        /// <returns></returns>PublicintExectran (stringMainsql, CommandType cmdtype, list<sqlparameter[]> mainparmslist,stringChildsql, list<sqlparameter[]> childparmslist) {            introw =0; using (SqlConnection conn = Createconn ()) {Conn.                Open (); SqlTransaction TRAN = conn.                BeginTransaction (); SqlCommand cmd =NewSqlCommand (MAINSQL, Conn, Tran);                               Cmd.commandtype = Cmdtype; if(Mainparmslist! =NULL) {foreach (sqlparameter[] parmsinchmainparmslist) {cmd.                        Parameters.clear (); if(Parms! =NULL) {cmd.                                                   Parameters.addrange (parms); }                        Try{row = cmd.                        ExecuteNonQuery (); } catch {tran.                            Rollback (); Return0;                }}} Cmd.commandtext = Childsql; if(Childparmslist! =NULL) {foreach (sqlparameter[] parminchchildparmslist) {cmd.                        Parameters.clear (); if(Parm! =NULL) {cmd.                        Parameters.addrange (Parm); }                        Try{row = cmd.                        ExecuteNonQuery (); } catch {tran.                            Rollback (); Return0;                }} tran.commit ();        }} return row; }        #endregion        #regionExecute SQL statement/// <summary>        ///Execute SQL statement/// </summary>        /// <param name= "SQL" ></param>        /// <param name= "parms" ></param>        /// <returns></returns>PublicStatic intExecuteSQL (stringsql, CommandType cmdtype = CommandType.Text, params sqlparameter[] parms) {            introw =0; using (SqlConnection conn = Createconn ()) {Conn.                Open (); SqlCommand cmd =NewSqlCommand (SQL, conn);                Cmd.commandtype = Cmdtype; if(Parms! =NULL) {cmd.                Parameters.addrange (parms); } row = cmd.            ExecuteNonQuery ();        } return row; }        #endregion        #regionGet First line column/// <summary>        ///get first line column/// </summary>        /// <param name= "SQL" ></param>        /// <param name= "parms" ></param>        /// <returns></returns>PublicStatic ObjectGetsingle (stringsql, CommandType cmdtype= CommandType.Text, params sqlparameter[] parms) {using (SqlConnection conn = Createconn ()) {Conn.                Open (); SqlCommand cmd =NewSqlCommand (SQL, conn);                Cmd.commandtype = Cmdtype; if(Parms! =NULL) {cmd.                Parameters.addrange (parms); } return cmd.            ExecuteScalar (); }        }        #endregion    }

ADO Universal Access Class