更改连接字符串以使应用程序可在线访问

问题描述

我有一个使用SQL Server数据库的winforms应用程序。数据源中的连接字符串类似于

Hi,
I have a winforms application that uses SQL Server Databases. The connection string in data source is something like

Data Source=Office1\SQLEXPRESS;Initial Catalog=dbRepHost;Integrated Security=True

现在我已在网络服务器上托管数据库以访问在线数据库。我已经附加了数据库。



新的必需连接字符串是

Now I have hosted the DBs on a web server to access the online DBs. I have attached the DBs.

The new required connection string is

Data Source=dbRepHost.mssql.somee.com;Initial Catalog=dbRepHost;Persist Security Info=True;User ID=nouman;Password=abc123

我的问题是如果它足以改变app.config文件中的连接字符串，或者我需要编辑所有数据集并更改连接字符串？





谢谢

My question is if it is enough to change the connection string in app.config file or I need to edit all data sets to and change the connection string?


Thanks

推荐答案

这篇关于更改连接字符串以使应用程序可在线访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！