How to increase timeout period in window application .

Question

How to increase timeout period in window application . Please reply.. Thanks and Regards Niranjan Poddar

Sujeet Suman · Answer

Niranjan you can increase timeout period by setting SQL Command Timeout property explicitly. Example : - using (SqlConnection con = new SqlConnection(Data Source=SERVERNAME; Integrated Security=true; Initial Catalog=DBNAME)) { con.Open(); SqlCommand cmd = new SqlCommand(WRITE SOME QUERY con); SqlDataReader dr = cmd.ExecuteReader(); cmd.CommandTimeout = 60; // Default Value is 30 Sec con.Close(); } If this is helpful for you then please accept my Answer .

Raja T · Answer

Hi Are you getting any error in query execution time? Please checkout below urls for your reference https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx https://msdn.microsoft.com/en-us/library/system.data.sqlclient.slconnection.connectiontimeout(v=vs.71).aspx http://blogs.msdn.com/b/angelsb/archive/2004/08/25/220333.aspx