SqlHelper类
来源:互联网 发布:nemo阿拉伯语软件 编辑:程序博客网 时间:2024/05/21 11:09
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
/// <summary>
/// SqlHelper 的摘要说明
/// </summary>
public static class SqlHelper1
{
// readonly static string constr = ConfigurationManager.ConnectionStrings["constr"].ToString();
readonly static string constr = "data source=10.1.1.247;database=haitian_MSCRM;uid=ht_crmselect;pwd=htpass@228";
/// <summary>
/// 提交返回数据集
/// </summary>
/// <param name="commandtype">选择执行方式的枚举</param>
/// <param name="commandtext">sql语句或者存储过程名称</param>
/// <param name="sps">参数的数组</param>
/// <returns></returns>
public static DataTable ExecuteDataSet(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
}
}
/// <summary>
/// 用于执行insert、update、delete
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static int ExecuteNonQuery(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
int count = cmd.ExecuteNonQuery();
con.Close();
return count;
}
}
}
/// <summary>
/// 返回聚合函数值
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static object ExecuteScalar(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
object o = cmd.ExecuteScalar(); //sql的聚合函数 Count(*)
con.Close();
return o;
}
}
}
/// <summary>
/// 用于返回一行数据
/// </summary>
/// <param name="commandtype"></param>
/// <param name="commandtext"></param>
/// <param name="sps"></param>
/// <returns></returns>
public static SqlDataReader ExecuteReader(CommandType commandtype, string commandtext, params SqlParameter[] sps)
{
SqlConnection con = new SqlConnection(constr);
using (SqlCommand cmd = new SqlCommand(commandtext, con))
{
cmd.CommandType = commandtype;
if (sps != null)
{
foreach (SqlParameter var in sps)
{
cmd.Parameters.Add(var);
}
}
con.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); //关闭读取器,将自动关闭该读取器上的连接对象
return dr;
}
}
}
- SQLHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- sqlhelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- SQLHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper类
- SqlHelper 类
- SqlHelper类
- SqlHelper类
- SQLHelper类
- 有用的awk脚本
- 在win7(64位)中填加网络打印机(hp2015)
- 新人如何适应新工作环境
- 新浪微博 SDK for Windows Phone 7 (API)
- VS2008下OpenCV 2.3环境的搭建
- SqlHelper类
- oracle 触发器
- 聊胜于无 Java之Caesar与Vigenere实现
- mysql触发器的实战经验
- (转)SQL 里的 EXISTS与in、not exists与not in
- ToString(f02) 的用法
- C#构告函数的继承问题
- zz: 如何改变PDF文档的背景颜色
- WIN7以上IIS局域网访问