SqlHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.Common;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;

namespace _201210803021李香明
{
    /// <summary>
    ///SqlHelper 的摘要说明
    /// </summary>
    public class SqlHelper
    {
        private readonly static string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

        #region 执行非查询语句
        public static int ExecuteNonQuery(string sqlStr, params SqlParameter[] paras)
        {
            using (DbConnection conn = new SqlConnection(connStr))
            {
                conn.Open();
                using (DbCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sqlStr;
                    cmd.Parameters.AddRange(paras);
                    return cmd.ExecuteNonQuery();                   
                }
            }
        } 
        #endregion
        // 下载于www.51aspx.com
        #region 得到DataRow
        public static DataRow GetOneRowBysql(string sqlStr, params SqlParameter[] paras)
        {
            DataSet ds = new DataSet();
            DbConnection conn = new SqlConnection(connStr);
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandText = sqlStr;
            cmd.Parameters.AddRange(paras);
            DbDataAdapter da = new SqlDataAdapter((SqlCommand)cmd);
            da.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
                return ds.Tables[0].Rows[0];
            else
                return null;
        } 
        #endregion

        #region 得到一张表
        public static DataTable ExecuteDataReader(string sqlStr, params SqlParameter[] paras)
        {
            DataSet ds = new DataSet();
            DbConnection conn = new SqlConnection(connStr);
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandText = sqlStr;
            cmd.Parameters.AddRange(paras);
            DbDataAdapter da = new SqlDataAdapter((SqlCommand)cmd);