UC知道连接字符串出错 csharp
来源：百度知道 编辑：UC知道 时间：2024/06/07 07:35:03
.aspx文件
using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
public partial class Test_File_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string conStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
//Configuration.ConfigurationSettings.AppSettings.Get("connectionString");
SqlConnection sqlconnection = new SqlConnection(conStr);
try
{
sqlconnection.Open();
Response.Write("successful");
}
catch
{
throw;
}
}
}
config文件:
<?xml version="1.0"?>
<configuration>
<connectionStrings></connectionStrings>
<appSettings>
using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
public partial class Test_File_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string conStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
//Configuration.ConfigurationSettings.AppSettings.Get("connectionString");
SqlConnection sqlconnection = new SqlConnection(conStr);
try
{
sqlconnection.Open();
Response.Write("successful");
}
catch
{
throw;
}
}
}
config文件:
<?xml version="1.0"?>
<configuration>
<connectionStrings></connectionStrings>
<appSettings>
连接字符串是在<connectionStrings></connectionString>里的
<connectionStrings>
<add name="connectionString" connectionString="Server=127.0.0.1;uid=sa;password=;database=****;" providerName="System.Data.SqlClient" />
</connectionString>
string conStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
改成
string conStr = ConfigurationSettings.AppSettings["connectionString"];