I am getting a timeout every so often when performing a long query. (VS 2005).
I have a typed Dataset and I am calling a stored procedure from a TableAdapter.
How can I set the CommandTimeout? I searched through the forum but couldn't find a way to do it.
Thanks!
setting the CommandTimeout for a dataset?
-
- Posts: 20
- Joined: Thu 31 Aug 2006 18:19
-
- Posts: 20
- Joined: Thu 31 Aug 2006 18:19
I think I did figure it out.
Here's the function to modify in case others run into it:
At the top of the page it says that this file is auto-generated and changes may be lost. Is there any way to avoid that?
Here's the function to modify in case others run into it:
Code: Select all
_
Private Sub InitCommandCollection()
Me._commandCollection = New CoreLab.MySql.MySqlCommand(0) {}
Me._commandCollection(0) = New CoreLab.MySql.MySqlCommand
Me._commandCollection(0).Connection = Me.Connection
Me._commandCollection(0).CommandText = "thomas_global_reports_masters.Bot_SelectSessions"
Me._commandCollection(0).CommandType = System.Data.CommandType.StoredProcedure
Me._commandCollection(0).CommandTimeout = 0
End Sub
At the top of the page it says that this file is auto-generated and changes may be lost. Is there any way to avoid that?