How To Resolve TimeOut Error in Dataset.xsd

Question

Hi Friends I'm using Dataset.xsd with tableadapter and I'm doing a report using MS reporting service. but the error is occurring error: An error has occurred during report processing. * Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding How To Resolve TimeOut Error in Dataset.xsd Thanx

Fidel H · Answer

Hello Sunny I have this same problem but when I do your suggestion and build the application all those changes disappear. Do you know what I am doing wrong? Thank you in advance.

Sunny Sharma · Answer

HI Sagar Open Dataset.Designer.cs file and replace the following code: --------------------------------------------------------------- protected global::System.Data.SqlClient.SqlCommand[] CommandCollection { get { if ((this._commandCollection == null)) { this.InitCommandCollection(); } return this._commandCollection; } } ---------------------------------------------------------------- with this one: ---------------------------------------------------------------- protected global::System.Data.SqlClient.SqlCommand[] CommandCollection { get { if ((this._commandCollection == null)) { this.InitCommandCollection(); _commandCollection[0].CommandTimeout = 0; } _commandCollection[0].CommandTimeout = 0; return this._commandCollection; } } ---------------------------------------------------------------- Hope it helps :)