using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace test3
{
public static partial class SqlHelper
{
//public static string connstr = "data source=.;Initial catalog=test;integrated security=SSPI";
{
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand(sql,conn);
if(p.Length>0){
cmd.Parameters.AddRange(p);
}
conn.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
public static DataTable ExecuteTable(string sql, params SqlParameter[] p)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
ada.SelectCommand.Parameters.AddRange(p);
DataTable dt = new DataTable();
ada.Fill(dt);
return dt;
}
}
public static int ExecuteNonQuery(string sql, params SqlParameter[] p)
{
using(SqlConnection conn = new SqlConnection(connstr)){
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddRange(p);
conn.Open();
return cmd.ExecuteNonQuery();
}
}
public static object ExecuteScalar(string sql, params SqlParameter[] p)
{
using(SqlConnection conn = new SqlConnection(connstr)){
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddRange(p);
conn.Open();
return cmd.ExecuteScalar();
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace test3
{
public static partial class SqlHelper
{
//public static string connstr = "data source=.;Initial catalog=test;integrated security=SSPI";
//public static string connstr = "data source=.;initial catalog=test;user id=sa;pwd=123456";
//string str = "server=.;database=(你的数据库名称);uid=sa;pwd=(密码)";
{
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand(sql,conn);
if(p.Length>0){
cmd.Parameters.AddRange(p);
}
conn.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
public static DataTable ExecuteTable(string sql, params SqlParameter[] p)
{
using (SqlConnection conn = new SqlConnection(connstr))
{
SqlDataAdapter ada = new SqlDataAdapter(sql, conn);
ada.SelectCommand.Parameters.AddRange(p);
DataTable dt = new DataTable();
ada.Fill(dt);
return dt;
}
}
public static int ExecuteNonQuery(string sql, params SqlParameter[] p)
{
using(SqlConnection conn = new SqlConnection(connstr)){
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddRange(p);
conn.Open();
return cmd.ExecuteNonQuery();
}
}
public static object ExecuteScalar(string sql, params SqlParameter[] p)
{
using(SqlConnection conn = new SqlConnection(connstr)){
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddRange(p);
conn.Open();
return cmd.ExecuteScalar();
}
}
}
}
https://pan.baidu.com/s/1X_iBzy7D2rq__ymMNteFOQ