I have the below code in one of my ASP.NET pages. The ConnectionTimeout is not working I am getting an error after just 15 sec. Can some one suggest me the correct code.
********************************************************
Dim ConnectionString As String = ConfigurationSettings.AppSettings("ConnectionString"
Dim myConnection as New OdbcConnection(ConnectionString)
myConnection.ConnectionTimeout = 50000
Dim CommandText As String
CommandText = "select * from clst_rpt1 WHERE req_no=" & reqNo & " ORDER BY st_no desc,str_clu"
Dim myCommand As New OdbcDataAdapter(CommandText, myConnection)
Dim ds As New DataSet()
myCommand.Fill(ds)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
************************************************************
Any help will be appreciated
********************************************************
Dim ConnectionString As String = ConfigurationSettings.AppSettings("ConnectionString"
Dim myConnection as New OdbcConnection(ConnectionString)
myConnection.ConnectionTimeout = 50000
Dim CommandText As String
CommandText = "select * from clst_rpt1 WHERE req_no=" & reqNo & " ORDER BY st_no desc,str_clu"
Dim myCommand As New OdbcDataAdapter(CommandText, myConnection)
Dim ds As New DataSet()
myCommand.Fill(ds)
DataGrid1.DataSource = ds
DataGrid1.DataBind()
************************************************************
Any help will be appreciated