using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
namespace ADONET2
{
class SqlHelper
{
private static string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;
// : ,
////public static int ExecuteNonQuery(string sql)
////{
//// using (SqlConnection conn = new SqlConnection(connStr))
//// {
//// conn.Open();
//// using (SqlCommand cmd = conn.CreateCommand())
//// {
//// cmd.CommandText = sql;
//// 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();
//// }
//// }
////}
////// sql
////public static DataTable ExecuteDataTable(string sql)
////{
//// using (SqlConnection conn = new SqlConnection(connStr))
//// {
//// conn.Open();
//// using (SqlCommand cmd = conn.CreateCommand())
//// {
//// cmd.CommandText = sql;
//// SqlDataAdapter adapter = new SqlDataAdapter(cmd);
//// DataSet dataset = new DataSet();
//// adapter.Fill(dataset);
//// return dataset.Tables[0];
//// }
//// }
////}
//
//public static int ExecuteNonQuery(string sql,SqlParameter[] parameters)
//{
// using (SqlConnection conn = new SqlConnection(connStr))
// {
// conn.Open();
// using (SqlCommand cmd = conn.CreateCommand())
// {
// cmd.CommandText = sql;
// //foreach (SqlParameter param in parameters)
// //{
// // cmd.Parameters.Add(param);
// //}
// cmd.Parameters.AddRange(parameters);
// return cmd.ExecuteNonQuery();
// }
// }
//}
//public static object ExecuteScalar(string sql,SqlParameter[] parameters)
//{
// using (SqlConnection conn = new SqlConnection(connStr))
// {
// conn.Open();
// using (SqlCommand cmd = conn.CreateCommand())
// {
// cmd.CommandText = sql;
// cmd.Parameters.AddRange(parameters);
// return cmd.ExecuteScalar();
// }
// }
//}
//// sql
//public static DataTable ExecuteDataTable(string sql, 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 int ExecuteNonQuery(string sql,params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
//foreach (SqlParameter param in parameters)
//{
// cmd.Parameters.Add(param);
//}
cmd.Parameters.AddRange(parameters);
return cmd.ExecuteNonQuery();
}
}
}
public static object ExecuteScalar(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.ExecuteScalar();
}
}
}
// sql
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];
}
}
}
}
}