程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> 其他數據庫知識 >> 更多數據庫知識 >> 使用MyDBase連接SQL Server

使用MyDBase連接SQL Server

編輯:更多數據庫知識

   使用ADO.NET自定義類MyDBase連接SQL Server數據庫

  using System;

  using System.Data;

  using System.Data.SqlClient;

  public class MyDBase

  {

  bool ECode=false;

  string ES;

  SqlConnection cn=new System.Data.SqlClient.SqlConnection();

  DataSet Rs;

  public MyDBase(string MyDBServerName,string MyDataBaseName)

  {

  ECode = false;

  cn.ConnectionString="workstation id="+MyDBServerName+";packet size=4096;integrated security=SSPI;data source="+MyDBServerName+";persist security info=False;initial catalog="+MyDataBaseName;

  try

  {

  cn.Open();

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  }

  }

  public MyDBase(string MyDBServerName, string MyDataBaseName, string sUerName, string sPasswd)

  {

  ECode = false;

  string sConn = "workstation id=" + MyDBServerName + ";packet size=4096;user id=" + sUerName + ";pwd=" + sPasswd + ";data source=" + MyDBServerName + ";persist security info=False;initial catalog=" + MyDataBaseName;

  cn.ConnectionString = sConn;

  try

  {

  cn.Open();

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  }

  }

  public DataSet GetRecordset(string Sqls)

  {

  SqlCommand sqlCmd= new SqlCommand();

  sqlCmd.Connection = cn;

  sqlCmd.CommandText = Sqls;

  try

  {

  SqlDataAdapter adp = new SqlDataAdapter(sqlCmd);

  Rs = new DataSet();

  adp.Fill(Rs);

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  return null;

  }

  return (Rs);

  }

  public int ExecuteSQLScalar(string Sqls)

  {

  string s;

  SqlCommand sqlCmd= new SqlCommand();

  sqlCmd.Connection = cn;

  sqlCmd.CommandText = Sqls;

  sqlCmd.CommandType = CommandType.Text;

  try

  {

  s = sqlCmd.ExecuteScalar().ToString();

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  return -1;

  }

  return(int.Parse(s));

  }

  public string ExecuteSQLScalarTOstring(string Sqls)

  {

  string s;

  SqlCommand sqlCmd = new SqlCommand();

  sqlCmd.Connection = cn;

  sqlCmd.CommandText = Sqls;

  sqlCmd.CommandType = CommandType.Text;

  try

  {

  s = sqlCmd.ExecuteScalar().ToString();

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  return "-1";

  }

  return s;

  }

  public string ExecuteSQLWithTrans(string Sqls)

  {

  string s;

  SqlTransaction myTrans;

  myTrans=cn.BeginTransaction();

  SqlCommand sqlCmd= new SqlCommand();

  sqlCmd.Connection = cn;

  sqlCmd.CommandText = Sqls;

  sqlCmd.CommandType = CommandType.Text;

  sqlCmd.Transaction =myTrans;

  sqlCmd.ExecuteNonQuery();

  //Sqls="SELECT @@IDENTITY AS ID";

  sqlCmd.CommandText =Sqls;

  try

  {

  s = sqlCmd.ExecuteScalar().ToString();

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  myTrans.Commit();

  return "";

  }

  myTrans.Commit();

  return(s);

  }

  public void ExecuteSQL(string Sqls)

  {

  SqlCommand sqlCmd= new SqlCommand();

  sqlCmd.Connection = cn;

  sqlCmd.CommandText = Sqls;

  sqlCmd.CommandType = CommandType.Text;

  try

  {

  sqlCmd.ExecuteNonQuery();

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  }

  }

  public SqlDataReader DBDataReader(string Sqls)

  {

  SqlCommand sqlCmd= new SqlCommand();

  sqlCmd.Connection = cn;

  sqlCmd.CommandText = Sqls;

  sqlCmd.CommandType = CommandType.Text;

  try

  {

  return sqlCmd.ExecuteReader(CommandBehavior.CloseConnection);

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  return null;

  }

  }

  public void DBClose()

  {

  try

  {

  cn.Close();

  }

  catch (Exception e)

  {

  ES = e.Message;

  ECode = true;

  }

  }

  public bool ErrorCode()

  {

  return ECode;

  }

  public string ErrMessage()

  {

  return ES;

  }

  ~MyDBase()

  {

  //if (cn.State==ConnectionState.Open ) cn.Close();

  }

  }

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved