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
}
Asp.net中DateReader读取数据库操作类!
最新推荐文章于 2021-01-04 12:46:18 发布