Re: Timeout on populating a datagrid

From: Scott Allen (bitmask_at_[nospam)
Date: 05/05/04 

Date: Wed, 05 May 2004 13:17:31 -0400

Hi Paul:

It doens't look like the problem is DataGrid related, but in the
stored procedure you use to update a record in the database.

I'd review the stored procedure SQL in a query tool and see how long
the query is taking. Perhaps the stored procedure is trying to update
a record in a large table and does not have an index available to find
the record quickly.

HTH, 

--
Scott
http://www.OdeToCode.com
On Wed, 5 May 2004 11:30:50 -0400, "Paul" <pe@nospam.com> wrote:
>I sometimes get a timeout error when populating my datagrid,
>
>the code is
>WizardConnection.Open()
>
>UpdateCommand.CommandText = "EXECUTE sp_assign_user '" &
>PhysOffice.SelectedValue & "', '" & Context.User.Identity.Name & "'"
>
>UpdateCommand.ExecuteNonQuery()
>
>WizardConnection.Close()
>
>
>Any suggestions?
>Thanks
>Paul
>
>The error is :
>
>
>Server Error in '/EmpLinkage' Application.
>
>
>Timeout expired
>Description: An unhandled exception occurred during the execution of the
>current web request. Please review the stack trace for more information
>about the error and where it originated in the code.
>
>Exception Details: System.Data.OleDb.OleDbException: Timeout expired
>
>Source Error:
>
>An unhandled exception was generated during the execution of the current web
>request. Information regarding the origin and location of the exception can
>be identified using the exception stack trace below.
>
>Stack Trace:
>
>[OleDbException (0x80040e31): Timeout expired]
>   System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
>   System.Data.OleDb.OleDbDataReader.NextResult()
>   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
>behavior, String method)
>   System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
>
>System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandB
>ehavior behavior)
>   System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
>startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
>CommandBehavior behavior)
>   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
>Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
>behavior)
>   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
>   EmpLinkage.WebForm1.datagrid() in
>\\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:183
>   EmpLinkage.WebForm1.GOButton_Click(Object sender, EventArgs e) in
>\\sta2wd08\wwwroot$\EmpLinkage\WebForm1.aspx.vb:261
>   System.Web.UI.WebControls.Button.OnClick(EventArgs e)
>
>System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
>stBackEvent(String eventArgument)
>   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
>sourceControl, String eventArgument)
>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
>   System.Web.UI.Page.ProcessRequestMain()
>