建立一个连接类:
public class Class1
{
public Class1()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public SqlConnection condb()
{ SqlConnection con = new SqlConnection("server=HPC;uid=sa;pwd=;database=Northwind");
return con;
}
}
引用: Class1 cl = new Class1();
SqlConnection con = cl.condb();
con.Open();
第二种方法:
在WEBconfig中写:
<appSettings>
<add key="constr" value="server=.;uid=sa;pwd=;database=northwind"></add>
</appSettings>
引用:
string constr=System.Configuration.ConfigurationManager.AppSettings["constr"];
SqlConnection con = new SqlConnection(constr);
第三种直连:
Web.config中写:
<connectionStrings>
<add name="ConnStr" connectionString="data source=.; initial catalog=GuestBook;user id=sa; pwd=sa;"/>
</connectionStrings>
引用:
SqlConnection con = new SqlConnection("server=HPC;uid=sa;pwd=;database=Northwind");
con.Open();
或:
private static string ConnStr = System.Configuration.ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;