学步园

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;        // WebConfigurationManager
using System.Web.Configuration;    // WebConfigurationManager
using System.Text;     //  stringbuilder引用

    public class Sql_Class
    {
        #region ===================================== \\ ★ 【操作数据库  -- DataReader类 -- Select】
            public SqlDataReader Sql_Select(string sql)   // 读取数据类 - [Select语句]
            {
                 
                string connectionString = WebConfigurationManager.ConnectionStrings["b3_dbConnectionString"].ConnectionString;
                SqlConnection con = new SqlConnection(connectionString);

                try
                {
                    // ========================== \\ 打开
                    con.Open();

                }
                catch (Exception ex)
                {
                    // ========================== \\ 如果出错
                }
                finally
                {
                }

                SqlCommand cmd = new SqlCommand(sql, con);  // 执行Sql语句

                SqlDataReader dr = cmd.ExecuteReader();
                return dr;

            }
        #endregion

    }