- class SqlHelper
- {
- private static string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;
- public static int ExecuteNonQuery(string sql, params SqlParameter[] parameters)
- {
- using (SqlConnection conn = new SqlConnection(connStr))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- cmd.Parameters.AddRange(parameters);
- return cmd.ExecuteNonQuery();
- }
- }
- }
- public static object ExecuteScalar(String sql)
- {
- using (SqlConnection conn = new SqlConnection(connStr))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- return cmd.ExecuteScalar();
- }
- }
- }
- public static DataTable ExecuteDataTable(string sql, params SqlParameter[] parameters)
- {
- using (SqlConnection conn = new SqlConnection(connStr))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- cmd.Parameters.AddRange(parameters);
- SqlDataAdapter adapter = new SqlDataAdapter(cmd);
- DataSet dataSet = new DataSet();
- adapter.Fill(dataSet);
- return dataSet.Tables[0];
- }
- }
- }
- public static object FromDbValue(object value)
- {
- if (value == DBNull.Value)
- {
- return null;
- }
- else
- { return value; }
- }
- public static object ToDbvalue(object value)
- {
- if (value == null)
- {
- return DBNull.Value;
- }
- else
- {
- return value;
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/0607201614778.html
来源: http://www.codesnippet.cn/detail/0607201614778.html