usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Data.SqlClient;usingMyshoolmodels;namespacemyshooldal{ Public classDBHelper {stringconn ="Data Source=.;i Nitial Catalog=myschool; User Id=sa"; SqlConnection SC; PublicSqlConnection sc//Connection {Get { if(sc==NULL) {SC=NewSqlConnection (conn); } returnSC; } } Public voidOpenSc ()//Open {if(SC. State==system.data.connectionstate.broken | | Sc. state==System.Data.ConnectionState.Closed) {sc. Close (); Sc. Open (); } } Public voidClosesc ()//close {if(SC. State = = System.Data.ConnectionState.Broken | | Sc. state = =System.Data.ConnectionState.Open) {sc. Close (); } } Public intExecuteque (stringSql,sqlparameter[] Paras) {SqlCommand cmd=NewSqlCommand (SQL,SC); Cmd. Parameters.addrange (paras); intResul =cmd. ExecuteNonQuery (); returnResul; } }}
DBHELP Data Processing class