Question

asp.net 连接SQL数据库的封装类，及其调用方法

在WEB操作页面上写一个连接SQL数据库的通用方法进行封装，然后在别的地方绑定数据的时候只需调用这个方法就可以。谁有类似的例子和调用方法，请给个谢谢！

Answer 1

1.web.config 中
<add key="ConnectionString" value="server=(local);uid=sa;pwd=123456;database=News"/>

调用的时候
string strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"].ToString();
SqlConnection Conn = new SqlConnection(strConn);

2.或者不用web.config直接在文件中写

SqlConnection conn = new SqlConnection("server=.\\SQLEXPRESS;uid=sa;pwd=123456;database=login");

如何是Express版的数据库，一定要在服务器名的后面加上 \\SSQLEXPRESS

Answer 2

db.cs

public static SqlConnection createconnection()
{
SqlConnection con = new SqlConnection("Server=.;Database=nowshop;uid=sa;pwd=;");
return con;
}

Select.cs

public SqlDataReader Sel_titles()
{
SqlConnection con = db.createconnection();
SqlCommand cmd = new SqlCommand(titles, con);
SqlDataReader dr = null;
try
{
con.Open();
dr = cmd.ExecuteReader();
}
catch (SqlException ex)
{
throw new Exception(ex.Message, ex);

}
return dr;
}

xx.aspx

Select SelTitles = new Select();
SqlDataReader dr = SelTitles.Sel_titles();
DataList1.DataSource = dr;
DataList1.DataBind();
dr.Close();

Answer 3

在WebConfig里配置
Web.config<connectionStrings>
<add name="connstr" connectionString="server=(local);database=stu;user=sa;pwd=123" /> </connectionStrings>

类里调用string conns = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString; SqlConnection conn = new SqlConnection(conns);

Answer 4

用 Web.config
<connectionStrings>
<add name="connstr" connectionString="server=(local);database=stu;user=sa;pwd=123" />
</connectionStrings>