ConfigurationManager.ConnectionStrings 属性

最新推荐文章于 2024-05-11 08:31:42 发布

n北斗

最新推荐文章于 2024-05-11 08:31:42 发布

阅读量1.1k

点赞数 2

分类专栏： asp.net 文章标签：数据库 java c#

原文链接：https://learn.microsoft.com/zh-cn/dotnet/api/system.configuration.configurationmanager.connectionstrings?view=netframework-4.7.2&f1url=%3FappId%3DDev16IDEF1%26l%3DZH-CN%26k%3Dk(System.Configuration.ConfigurationManager.ConnectionStrings)%3Bk(TargetFramewo

版权

asp.net 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

以下示例演示如何使用连接字符串从数据库读取数据。

using System;  
using System.Configuration;  
using System.Data.SqlClient;  

namespace ConsoleApplication1  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            ReadProducts();  
        }  

        static void ReadProducts()  
        {  
            var connectionString = ConfigurationManager.ConnectionStrings["WingtipToys"].ConnectionString;  
            string queryString = "SELECT Id, ProductName FROM dbo.Products;";  
            using (var connection = new SqlConnection(connectionString))  
            {  
                var command = new SqlCommand(queryString, connection);  
                connection.Open();  
                using (var reader = command.ExecuteReader())  
                {  
                    while (reader.Read())  
                    {  
                        Console.WriteLine(String.Format("{0}, {1}", reader[0], reader[1]));  
                    }  
                }  
            }  
        }  
    }  
}

上一个示例假定项目具有如下所示的App.config。

<?xml version="1.0" encoding="utf-8" ?>  
<configuration>  
    <startup>   
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />  
    </startup>  
    <connectionStrings>  
      <add name="WingtipToys" connectionString="Data Source=(LocalDB)\v11.0;Initial Catalog=WingtipToys;Integrated Security=True;Pooling=False" />  
    </connectionStrings>  
</configuration>