当前位置:Gxlcms > mysql > 数据库连接

数据库连接

时间:2021-07-01 10:21:17 帮助过:32人阅读

appSettings add key="sqlCon" value="Data Source=(local);Database=Northwind;Uid=sa;Pwd=;"/ /appSettings protected void Page_Load(object sender, EventArgs e) { string con_sqlserver = ConfigurationManager.AppSettings["sqlCon"].ToString();//获



protected void Page_Load(object sender, EventArgs e)
{
string con_sqlserver = ConfigurationManager.AppSettings["sqlCon"].ToString();//获取配置文件中的数据库字符串信息
Response.Write("SQL Server数据库连接字符串:"+con_sqlserver);//输出配置文件中的数据库字符串信息
SqlConnection con = new SqlConnection(con_sqlserver);//创建数据库连接对象
try
{
con.Open();//打开数据库连接
Response.Write("