无法连接到SQL Server数据库(ASP.NET C#)

本文关键字：ASP NET 数据库 Server 连接 SQL | 更新日期: 2023-09-27 18:21:19

当我尝试在ASP.NET（C#）中建立与SQL server数据库的连接时，我会收到以下错误：

ConnectionString属性尚未初始化。

Web.config

<connectionStrings>
   <add name="ConnectionString" 
        connectionString="Data Source=SERVER'SQLEXPRESS;Initial Catalog=FIRE;Integrated Security=SSPI;User ID=firedba;Password=firedba;"/>

C#代码

SqlConnection myConnection = new SqlConnection();
System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
System.Configuration.ConnectionStringSettings connString;
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
        connString = rootWebConfig.ConnectionStrings.ConnectionStrings["ConnectionString"];
        if (connString != null)
            myConnection.Open();
}

我正在SQL Server（本地）中运行数据库。测试应用程序位于Visual Studio 2008中。

你能帮我吗？

无法连接到SQL Server数据库(ASP.NET C#)

您需要在SqlConnection对象中设置ConnectionString。

用途：

if (connString != null){
        myConnection.ConnectionString=connString;
        myConnection.Open();
}

或者只需在获得Connection String:后创建SqlConnection对象

            SqlConnection myConnection = new SqlConnection(connString);
            myConnection.Open();

当您尝试打开数据库的链接时，您应该通知SqlConnection对象要使用的连接字符串

System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
System.Configuration.ConnectionStringSettings connString;
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
    connString = rootWebConfig.ConnectionStrings.ConnectionStrings["ConnectionString"];
    if (connString != null)
    {
        // Create the connection, open, use and destroy releasing the resources used
        using(SqlConnection myConnection = new SqlConnection(connString))
        {
             myConnection.Open();
             .... other database code here
        } 
   }
}
相关文章：