<?xml version="1.0" encoding="utf-8" ?> <configuration> <connectionStrings> <add name="SqlServer" connectionString="Server =.;uid=sa;pwd=123;database=ihospitalhis;"/> </connectionStrings> </configuration>
DataTable dt = SqlHelper.FillDt(sql, new SqlParameter("Tm_WaiId", type));
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Configuration; using System.Data; using System.Data.SqlClient; namespace WinForm { class SqlHelper { static string ConString = ConfigurationManager.ConnectionStrings["Sql2005"].ConnectionString; /// <summary> /// 增删改 /// </summary> /// <param name="sql"></param> /// <param name="pars"></param> /// <returns></returns> public static int ExecuteNonQuery(string sql, params SqlParameter[] pars) { using(SqlConnection SqlCon = new SqlConnection(ConString) ) {
SqlCon.Open();
using(SqlCommand SqlCmd = SqlCon.CreateCommand()) { SqlCmd.CommandText = sql; foreach (SqlParameter par in pars) { SqlCmd.Parameters.Add(par); } return SqlCmd.ExecuteNonQuery(); } } } /// <summary> /// 查询,返回DataTable /// </summary> /// <param name="sql"></param> /// <param name="pars"></param> /// <returns></returns> public static DataTable FillDt(string sql, params SqlParameter[] pars) { using (SqlConnection SqlCon = new SqlConnection(ConString)) {
using(SqlCommand SqlCmd = SqlCon.CreateCommand()) { SqlCmd.CommandText = sql; foreach (SqlParameter par in pars) { SqlCmd.Parameters.Add(par); } DataTable Dt = new DataTable(); using (SqlDataAdapter SqlAdapter = new SqlDataAdapter(SqlCmd)) { SqlAdapter.Fill(Dt); return Dt; } } } } /// <summary> /// 查询,返回Reader /// </summary> /// <param name="sql"></param> /// <param name="pars"></param> public static SqlDataReader ExecuteReader(string sql,params SqlParameter[] pars) { using(SqlConnection SqlCon = new SqlConnection(ConString)) { using(SqlCommand SqlCmd = SqlCon.CreateCommand()) { SqlCmd.CommandText=sql; foreach(SqlParameter par in pars) { SqlCmd.Parameters.Add(par); } using(SqlDataReader SqlReader = SqlCmd.ExecuteReader(CommandBehavior.CloseConnection)) { return SqlReader; } } } } /// <summary> /// 查询第一行第一列 /// </summary> /// <param name="sql"></param> /// <param name="pars"></param> /// <returns></returns> public static object ExecuteScalar(string sql, params SqlParameter[] pars) { using(SqlConnection SqlCon = new SqlConnection(ConString)) { using(SqlCommand SqlCmd = SqlCon.CreateCommand()) { SqlCmd.CommandText = sql; foreach (SqlParameter par in pars) { SqlCmd.Parameters.Add(par); } return SqlCmd.ExecuteScalar(); } } } } }