Time out expired in widows Application?How?

Hi,

If you talk about retrieving the data from database to bind to dataset, in this case if you get connection timeout error, then set the commandtimeout to zero(0) to the command object.

You said you are getting "error when loading the dataset". What dataset? What do you mean by that? We assume that you mean database, but if not then we need to know what you mean. If you mean database and it is a SQL Server database then please confirm that that is what it is and then someone can help you further.

Hi Srinivas!

Set commandtimeout to upper value..

Thanks!

-----------------------------------------------------------------------
If this reply helps your post…then check "This is correct answer"

Hi,

Please check this,

 the Error occurs when the execution time beyond Timeout Property.
 When you are trying to connect or access to a Database table which
 is having large volume of data, query execution time will be more.
 There are two main Timeout property in ADO.NET.
1. Connection Timeout for Connection. It could be solved by setting ConnectionTimeout property
of Connection object in Connection String.
2. Timeout for Data access ( Command Object ). You can set CommandTimeout property to Command object

myConnection.ConnectionString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer;Connect Timeout=30";

http://social.msdn.microsoft.com/Forums/en/vblanguage/thread/57dc992f-fcc4-4b17-8187-a9002c4bc28c

Hope this will help you.

Thanks.