朋友给的一段连接数据库的类,不知道从那里来的
using System;
using System.Collections;
using System.Data;
using System.Data.SqlClient;
namespace DaTest
{
/// <summary>
/// DataAccess 的摘要说明。
/// </summary>
public class DataAccess
{
private string cnnStr;
public string CnnStr
{
get
{
return cnnStr;
}
set
{
cnnStr=value;
}
}
private string cmdStr;
public string CmdString
{
get
{
return cmdStr;
}
set
{
cmdStr=value;
}
}
private ParamCollections sqlParamCollections=new ParamCollections();
public ParamCollections SqlParamCollections
{
get
{
return sqlParamCollections;
}
}
private int cmdint;
public int Cmdint
{
get
{
return cmdint;
}
set
{
cmdint=value;
}
}
public DataAccess() //构造函数,初始化cnnStr
{
cnnStr=System.Configuration.ConfigurationSettings.AppSettings["cnnStr"].ToString();
cmdStr="";
}
private SqlConnection objConnection;
private SqlCommand objCommand;
private SqlDataAdapter objAdapter;
public DataSet SelectCommand()//执行一个SQL,并返回一个DataSet
{
DataSet retDataSet=new DataSet();//定义一个DataSet
objConnection=new SqlConnection(cnnStr);//创建一个新的连接对象
objConnection.Open();//连接
objCommand=new SqlCommand(cmdStr, objConnection);//执行cmdStr
objAdapter=new SqlDataAdapter();//
objAdapter.SelectCommand=objCommand;
objAdapter.Fill(retDataSet);//填充DataSet
objConnection.Close();
return retDataSet;//返回
}
public int OtherCommand()//受影响的行数
{
int intRet;
objConnection=new SqlConnection(cnnStr);
objConnection.Open();
objCommand=new SqlCommand(cmdStr, objConnection);
intRet=objCommand.ExecuteNonQuery();
objConnection.Close();
return intRet;
}
public int ParamCommandLine()//添加数据时受影响的行数
{
int intRet;
objConnection=new SqlConnection(cnnStr);
objConnection.Open();
objCommand=new SqlCommand(cmdStr, objConnection);
foreach(SqlParameter objParam in sqlParamCollections)
objCommand.Parameters.Add(objParam);
intRet=objCommand.ExecuteNonQuery();
objConnection.Close();
return intRet;
}
public int ParamCommand()
{
int intRet;
objConnection=new SqlConnection(cnnStr);
objConnection.Open();
objCommand=new SqlCommand(cmdStr, objConnection);
objCommand.CommandType=CommandType.StoredProcedure;//
foreach(SqlParameter objParam in sqlParamCollections)
objCommand.Parameters.Add(objParam);
intRet=objCommand.ExecuteNonQuery();
objConnection.Close();
return intRet;
}
}
//参数的集合类
public class ParamCollections : CollectionBase
{
public void Add(SqlParameter objParam)
{
List.Add(objParam);
}
public SqlParameter this[int Index]
{
get
{
return (SqlParameter)List[Index];
}
}
}
}
using System.Collections;
using System.Data;
using System.Data.SqlClient;
namespace DaTest
{
/// <summary>
/// DataAccess 的摘要说明。
/// </summary>
public class DataAccess
{
private string cnnStr;
public string CnnStr
{
get
{
return cnnStr;
}
set
{
cnnStr=value;
}
}
private string cmdStr;
public string CmdString
{
get
{
return cmdStr;
}
set
{
cmdStr=value;
}
}
private ParamCollections sqlParamCollections=new ParamCollections();
public ParamCollections SqlParamCollections
{
get
{
return sqlParamCollections;
}
}
private int cmdint;
public int Cmdint
{
get
{
return cmdint;
}
set
{
cmdint=value;
}
}
public DataAccess() //构造函数,初始化cnnStr
{
cnnStr=System.Configuration.ConfigurationSettings.AppSettings["cnnStr"].ToString();
cmdStr="";
}
private SqlConnection objConnection;
private SqlCommand objCommand;
private SqlDataAdapter objAdapter;
public DataSet SelectCommand()//执行一个SQL,并返回一个DataSet
{
DataSet retDataSet=new DataSet();//定义一个DataSet
objConnection=new SqlConnection(cnnStr);//创建一个新的连接对象
objConnection.Open();//连接
objCommand=new SqlCommand(cmdStr, objConnection);//执行cmdStr
objAdapter=new SqlDataAdapter();//
objAdapter.SelectCommand=objCommand;
objAdapter.Fill(retDataSet);//填充DataSet
objConnection.Close();
return retDataSet;//返回
}
public int OtherCommand()//受影响的行数
{
int intRet;
objConnection=new SqlConnection(cnnStr);
objConnection.Open();
objCommand=new SqlCommand(cmdStr, objConnection);
intRet=objCommand.ExecuteNonQuery();
objConnection.Close();
return intRet;
}
public int ParamCommandLine()//添加数据时受影响的行数
{
int intRet;
objConnection=new SqlConnection(cnnStr);
objConnection.Open();
objCommand=new SqlCommand(cmdStr, objConnection);
foreach(SqlParameter objParam in sqlParamCollections)
objCommand.Parameters.Add(objParam);
intRet=objCommand.ExecuteNonQuery();
objConnection.Close();
return intRet;
}
public int ParamCommand()
{
int intRet;
objConnection=new SqlConnection(cnnStr);
objConnection.Open();
objCommand=new SqlCommand(cmdStr, objConnection);
objCommand.CommandType=CommandType.StoredProcedure;//
foreach(SqlParameter objParam in sqlParamCollections)
objCommand.Parameters.Add(objParam);
intRet=objCommand.ExecuteNonQuery();
objConnection.Close();
return intRet;
}
}
//参数的集合类
public class ParamCollections : CollectionBase
{
public void Add(SqlParameter objParam)
{
List.Add(objParam);
}
public SqlParameter this[int Index]
{
get
{
return (SqlParameter)List[Index];
}
}
}
}