62,017
社区成员
发帖
与我相关
我的任务
分享
public class SQLHelper
{
private static string ConnStr = DAL.DBConnection.Connection;//读取数据库连接语句
/// <summary>
/// 功能描述:打开数据库
/// </summary>
/// <returns></returns>
public static SqlConnection Openconn()
{
SqlConnection conn = new SqlConnection(ConnStr);
if (conn.State.Equals(ConnectionState.Closed)) { conn.Open(); }
return conn;
}
public static DataSet ExecuteDataSet(string SQLString, params SqlParameter[] cmdParms)
{
using (SqlConnection conn = Openconn())
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = SQLString;
PrepareCommand(cmd, cmdParms);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
return ds;
}
}
}
}