邮局报刊订阅代码.docVIP

邮局报刊订阅代码 class SqlHelper { private SqlConnection conn = null; private SqlCommand cmd = null; private SqlDataReader sdr=null; public SqlHelper() { string connStr = @Data Source=.;Initial Catalog=NewsPaperSystem;Integrated Security=True; conn = new SqlConnection(connStr); } private SqlConnection GetConn() { if (conn.State == ConnectionState.Closed) { conn.Open(); } return conn; } public void ExecuteQ(string sql) { try { cmd = new SqlCommand(sql, GetConn()); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } } //该方法执行传入的SQL语句 public DataTable ExecuteQuery(string sql) { DataTable dt = new DataTable(); cmd = new SqlCommand(sql, GetConn()); using(sdr=cmd.ExecuteReader(CommandBehavior.CloseConnection)) { dt.Load(sdr); } return dt; } //返回DataSet中的第一个数据 public string ExecuteReturn(string sql) { DataSet ds = new DataSet(); string resulting; cmd = new SqlCommand(sql, GetConn()); SqlDataAdapter adapter = new SqlDataAdapter(cmd); try { adapter.Fill(ds); } catch { return null; } resulting = ds.Tables[0].Rows[0][0].ToString(); return resulting; } } class SqlManager { public SqlHelper sqlhelper; public SqlManager() { sqlhelper = new SqlHelper()