要增加超时时间

本文介绍了要增加超时时间的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我要增加超时period.Following是我的code。

I have to increase timeout period.Following is my code.

Private Function GetConnectionInstance() As SqlConnection Dim objConn As SqlConnection Dim strConnection As String strConnection = ConfigurationSettings.AppSettings("conn") Try objConn = New SqlConnection(strConnection) Catch ex As Exception End Try Return objConn End Function

什么$ C $词要在上面添加，以增加超时时间。

What code i have to add in above to increase timeout period.

推荐答案

您需要到下一个项目添加到您的连接字符串：

You need to add the next item into your connection string:

连接超时= 30;

如果您需要更改超时只为目标连接，而不是在整个应用程序，下一步：

If you need to change Timeout only for target connection, not in the whole application, do next:

Dim connString as String = ConfigurationSettings.AppSettings("conn") Dim builder As New SqlConnectionStringBuilder(connString) builder.ConnectTimeout = 30; Dim connection = New SqlConnection(builder.ToString())