我需要帮助make vb.net应用程序与sql serverdatabase在本地网络上工作 [英] I need help in make vb.net application with sql serverdatabase works on local network

问题描述

大家好

 

我需要一些帮助，使用sqlserver数据库部署vb.net应用程序以在本地网络上工作我知道我必须在 中更改连接字符串app.config但我不知道如何在app.config中更改连接字符串

因为我有这个部分 几乎每种形式的代码

    Private cs As New SqlConnection（"Data Source = .\SQLEXPRESS; AttachDbFilename = | DataDirectory | \Mas-Database.mdf; Integrated Security = True; Connect Timeout = 30; User Instance = True"）

感谢您的帮助

 

解决方案

您需要放置配置文件中的connectionstring。并且需要使用它而不是硬编码的连接字符串。下面是相同的示例。

配置文件

<？xml version =" 1.0"？ > 
< configuration> 
< connectionStrings> 
< add name =" CompanyName_ProjectName_SQL" connectionString =" Data Source = .\SQLEXPRESS; Initial Catalog = Northwind; Integrated Security = True;" /> 
< / connectionStrings> 
< / configuration> 

VB.NET代码

您需要添加System.Configuration.dll的引用ConfigurationManager。

私有cs为新SqlConnection（System.Configuration.ConfigurationManager.ConnectionStrings [" CompanyName_ProjectName_SQL"]。ConnectionStrings）
 

Hi guys

 

I need some help in deploying vb.net application using sqlserver database to work on local network I know I have to change connection string in  app.config but I don't know how to change connection string in app.config

Since I have this piece  of code almost in every form

    Private cs As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Mas-Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")

thanks for help

 

解决方案

You need to place the connectionstring in config file. And need to use from that instead of hardcoded connectionstring. Below is sample example for the same.

Configuration File

<?xml version="1.0"?>
<configuration>
 <connectionStrings>
  <add name="CompanyName_ProjectName_SQL" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True;"/>
 </connectionStrings>
</configuration>

VB.NET Code

You need to add reference of System.Configuration.dll for ConfigurationManager.

Private cs As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["CompanyName_ProjectName_SQL"].ConnectionStrings)

这篇关于我需要帮助make vb.net应用程序与sql serverdatabase在本地网络上工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！