SqlHelper类

<?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))

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!