BDHelper
/// <summary> /// 数据库连接字符串 /// </summary> private static string sConn = “server=.\\SQLEXPRESS;uid=sa;pwd=sa;database=csgl”; /// <summary> /// 数据库连接对象 /// </summary> private static SqlConnection conn = new SqlConnection(sConn); /// <summary> /// 打开数据库连接 /// </summary> public static void Open() { //判断数据库连接是否关闭 if (conn.State == ConnectionState.Closed) { conn.Open(); } } /// <summary> /// 关闭数据库连接 /// </summary> public static void Close() { //判断数据库连接是否打开 if (conn.State == ConnectionState.Open) { conn.Close(); } } /// <summary> /// 执行Command对象的ExecuteScalar方法 /// </summary> /// <param name=”sSql”>要执行的SQL语句</param> /// <returns></returns> public static object ExecuteScalar(string sSql) { object obj = null;
继续阅读