Hi
I have tried to set the connectiontimeout to 20 sec. but doesn't seem to work.
im using a straight forward select command
Private _con As MySqlConnection
Public Function getDataTable(ByRef strSQL As String) As DataTable
Dim strcon As String = ""
strcon = ConfigurationManager.AppSettings("ConnectionString")
_con = New MySqlConnection(strcon)
Dim da As New MySqlDataAdapter(strSQL, _con)
Dim objDataTable As New DataTable()
_con.Open()
Try
da.Fill(objDataTable)
Catch
_con.ConnectionTimeout = 20
da.Fill(objDataTable)
End Try
_con.Close()
_con.Dispose()
Return objDataTable
End Function
in my database table there are 15- 20 rows and 6 columns!
what can i do?