哪个是VB.NET的最佳连接字符串& SQL Server 2008连接 [英] Which is the Best Connection String For VB.NET & SQL Server 2008 Connection

问题描述

Hello All！



我只是想知道在VB.NET 2010和SQL Server 2008之间建立连接的最佳方式。



这是VB.NET 2010和SQL Server 2008之间最好，最有效，最快的连接字符串。



非常非常感谢提前!!

Hello All !

I just want to know about the best way to make connection between VB.NET 2010 and SQL Server 2008.

Which is the best and the most efficient and the fastest Connection string between VB.NET 2010 and SQL Server 2008.

Very very thanks in advance !!

推荐答案

哪个是VB.NET 2010和SQL Server 2008之间最好，最有效，最快的连接字符串。



工作的那个。

连接字符串速度不是可测量的统计信息：它适用于您的SQL Server实例，或者它没有 - 速度不是问题。

所以找一个有效的，并使用它！



尝试设置连接VS与服务器资源管理器窗格：

1）打开服务器资源管理器。

2）右键单击数据连接并选择添加连接

3）在随后的对话框中，选择您的Da taSource和数据库，指定安全信息，然后按测试连接按钮。

4）当连接正常时，按确定

5）突出显示你的服务器资源管理器窗格中的数据库，然后查看属性窗格将显示连接字符串的工作示例，您可以将其复制并粘贴到您的应用程序或配置文件中。

"Which is the best and the most efficient and the fastest Connection string between VB.NET 2010 and SQL Server 2008."

The one that works.
"Connection string speed" is not a measurable statistic: it either works for your instance of SQL Server, or it doesn't - speed is not an issue.
So find one that works, and use it!

Try setting up a connection in VS with the Server Explorer pane:
1) Open Server Explorer.
2) Right click "Data connections" and select "Add connection"
3) In the dialog that follows, select your DataSource, and database, specify the security info, and press the "Test connection" button.
4) When the connection works, press "OK"
5) Highlight your database in the Server Explorer pane, and look at the Properties pane. A working example of the connection string will be shown, which you can copy and paste into your app or config file.

使用SqlConnection。



https://connectionstrings.com/sqlconnection/ [ ^ ]

Use SqlConnection.

https://connectionstrings.com/sqlconnection/[^]

这篇关于哪个是VB.NET的最佳连接字符串& SQL Server 2008连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！