Timeout on populating a datagrid

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Paul (pe_at_nospam.com)
Date: 05/05/04 

Date: Wed, 5 May 2004 11:30:50 -0400

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()

Quantcast