DBHelp数据处理类
发布时间:2016-07-14 22:00:09
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;u ...
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using System.Data.SqlClient;using MyShoolModels;namespace MyShoolDAL{ public class DBhelper { get='_blank'>string conn = "Data Source=.;Initial Catalog=MySchool;User ID=sa"; SqlConnection sc; public SqlConnection Sc//连接 { get { if(sc==null) { sc = new SqlConnection(conn); } return sc; } } public void OpenSc() //打开 { if(sc.State==System.Data.ConnectionState.Broken || sc.State==System.Data.ConnectionState.Closed) { sc.Close(); sc.Open(); } } public void CloseSc()//关闭 { if (sc.State == System.Data.ConnectionState.Broken || sc.State == System.Data.ConnectionState.Open) { sc.Close(); } } public int ExecuteQue(string sql,SqlParameter[] paras) { SqlCommand cmd = new SqlCommand(sql,Sc); cmd.Parameters.AddRange(paras); int resul = cmd.ExecuteNonQuery(); return resul; } }}
原标题:DBHelp数据处理类
关键词:
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。