数据访问类

? public class Cls_Sqlserver
??? {
??????? SqlCommand myComm;

??????? public string GetConnctionString()
??????? {
??????????? return "Data Source=.;Initial Catalog=Test;Integrated Security=True";
??????? }

??????? private void DisponseComm()
??????? {
??????????? if (myComm == null)
??????????? {
??????????????? return;
??????????? }
??????????? else
??????????? {
??????????????? myComm.Connection.Close();
??????????????? myComm.Connection.Dispose();
??????????? }
??????????? myComm.Dispose();
??????? }

??????? public DataSet GetDataSet(string CommandText)
??????? {
??????????? SqlDataAdapter myDA = new SqlDataAdapter();
??????????? DataSet ds = new DataSet();
??????????? try
??????????? {
??????????????? myComm = new SqlCommand(CommandText,new SqlConnection(GetConnctionString()));
??????????????? myComm.CommandType = CommandType.Text;
??????????????? myDA.SelectCommand = myComm;
??????????????? myDA.Fill(ds);
??????????? }
??????????? catch
??????????? {
??????????????? ds = null;
??????????? }
??????????? return ds;

??????? }
??????? public bool ExecSql(string CommandText)
??????? {
??????????? bool b = true;
??????????? try
??????????? {
??????????????? myComm = new SqlCommand(CommandText,new SqlConnection(GetConnctionString()));
??????????????? myComm.CommandType = CommandType.Text;
??????????????? myComm.ExecuteNonQuery();
??????????? }
??????????? catch
??????????? {
??????????????? b = false;

??????????? }
??????????? finally
??????????? {
??????????????? this.DisponseComm();
??????????? }
??????????? return b;
??????? }

??? }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!