• SqlHelper


    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using System.Data;
    using System.Data.SqlClient;
    using System.Configuration;
    namespace MyPhotos.DAL
    {
        class SQLHelper
        {
            //读取配置文件中的连接字符串
            private static string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;
    
            //
            public static DataTable GetTable(string sql,params SqlParameter[] param)
            {
                DataTable dt = new DataTable();
                using (SqlConnection conn = new SqlConnection(connStr))
                {
                    using (SqlCommand cmd = new SqlCommand(sql,conn))
                    {
                        cmd.Parameters.AddRange(param);
    
                        using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                        {
                            sda.Fill(dt);
                        }
                    }
                }
                return dt;
            }
    
            //调用存储过程的方法
            public static DataTable GetTable(string sql, CommandType ct,params SqlParameter[] param)
            {
                DataTable dt = new DataTable();
                using (SqlConnection conn = new SqlConnection(connStr))
                {
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                    {
                        //设置执行存储过程还是sql语句
                        cmd.CommandType = ct;
                        cmd.Parameters.AddRange(param);
    
                        using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                        {
                            sda.Fill(dt);
                        }
                    }
                }
                return dt;
            }
            /// <summary>
            /// 
            /// </summary>
            /// <param name="sql"></param>
            /// <param name="param"></param>
            /// <returns></returns>
            public static int ExecuteNonQuery(string sql, params SqlParameter[] param)
            {
                int r = -1;
                using (SqlConnection conn = new SqlConnection(connStr))
                {
                    using (SqlCommand cmd = new SqlCommand(sql, conn))
                    {
                        cmd.Parameters.AddRange(param);
    
                        conn.Open();
    
                        r = cmd.ExecuteNonQuery();
                    }
                }
                return r;
            }
    
        }
    }
    

      

  • 相关阅读:
    列表
    *
    Model/View
    文件
    提示用户输入并获得输入
    编码
    使用静态QT库编译的程序不显示中文
    rm命令
    高阶函数
    jquery checkbox 操作
  • 原文地址:https://www.cnblogs.com/wangguowen27/p/sql_itcast_sqlhelper.html
Copyright © 2020-2023  润新知