如何在dotnet代码中设置连接字符串 [英] how to set up connection string in dotnet code

问题描述

我创建了一个包含用户名，密码，年龄和全名的简单申请表，我在db中创建了一个ms sql server的表。但我不知道如何在网络配置中连接它。 plz help

解决方案

web.config中的ConnectionStrings部分。



< b> Sql身份验证

 <   connectionStrings  >  
 <   add     name   =  ConnectDBString    connectionString   =  server = SqlServerName; database = DatabaseName; uid = User; password = Password;    /  >  
 <   / connectionSt戒指 >  

将连接字符串读入您的代码，使用ConfigurationSettings类。

 string connStr = ConfigurationManager.ConnectionStrings [ConnectDBString]。ConnectionString; 

如需了解更多信息，请浏览以下链接

1）ConnectionStrings

2） ConnectionStrings



查看此答案以供参考：

如何在asp.net中建立数据库连接 [ ^ ]

查看在web.config中放置连接字符串的方法

在web.config中存储连接字符串

http://weblogs.asp.net/owscott/archive/2005/08/26/Using-connection-strings-from-web.config-in- ASP.NET-v2.0.aspx [ ^ ]

http://peterkellner.net/2008/02 / 23 / webconfigbestpractice / [ ^ ]



你也可以用visual studio创建连接

见

http://www.c-sharpcorner.com/uploadfile/suthish_nair/how-to-generate-or- find-connection-string-from-visual-studio / [ ^ ]

这将对你有帮助。



首先使用System.Data.SqlClient使用命名空间



;

使用System.Web .Configuration;

  public   partial   class 默认值：System.Web.UI.Page 
 {
 私人 静态  readonly   string  _connString =  String  .Empty; 
 SqlConnection con =  new  SqlConnection（_connString）; 

  static 默认（）
 {
 _connString = WebConfigurationManager.ConnectionStrings [< span class =code-string>  DataBaseNameConnectionString]。ConnectionString; 
} 

}





和WEB中的这段代码.Config文件

 <   connectionStrings  >  
 <   add     name   =   DataBaseNameConnectionString    connectionString  < span class =code-keyword> = 数据源=系统名称或服务器名称;初始目录=数据库名称;用户ID = sa;密码= 123    providerName   =  System.Data.SqlClient     /  >  
 <   / connectionStrings  >  

i m creating a simple application form with username , password, age and full name and i have created a table in db which is ms sql server. but i dont knw how to connect it in web config. plz help

解决方案

ConnectionStrings section in web.config.

Sql Authentication

<connectionStrings>
  <add name="ConnectDBString" connectionString="server=SqlServerName;database=DatabaseName;uid=User;password=Password;" />
</connectionStrings>

To read the connection string into your code, use the ConfigurationSettings class.

string connStr = ConfigurationManager.ConnectionStrings["ConnectDBString"].ConnectionString;

For further information please go through the following links
1) ConnectionStrings
2) ConnectionStrings

Check this answer for reference:
How to make database connectivity in asp.net[^]

see the way to put connection string in web.config
Store connection string in web.config
http://weblogs.asp.net/owscott/archive/2005/08/26/Using-connection-strings-from-web.config-in-ASP.NET-v2.0.aspx[^]
http://peterkellner.net/2008/02/23/webconfigbestpractice/[^]

you can also create connection using visual studio
see
http://www.c-sharpcorner.com/uploadfile/suthish_nair/how-to-generate-or-find-connection-string-from-visual-studio/[^]

This will be Helpful to u.

First use the Namespaces

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

public partial class Default : System.Web.UI.Page
{
    private static readonly string _connString = String.Empty;
    SqlConnection con = new SqlConnection(_connString);

static Default()
    {
  _connString = WebConfigurationManager.ConnectionStrings["DataBaseNameConnectionString"].ConnectionString;
    }

}


and this code in WEB.Config File

<connectionStrings>
  <add name="DataBaseNameConnectionString" connectionString="Data Source=system name or Server name;Initial Catalog=DataBaseName;user id=sa;password=123" providerName="System.Data.SqlClient"" />
</connectionStrings>

这篇关于如何在dotnet代码中设置连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！