Re: Timeout on populating a datagrid

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

Date: Wed, 5 May 2004 13:30:51 -0400

The sproc is reading not updating any database, depending upon the selection
criteria the sproc can take upto 30 seconds to complete, but asp.net doesn't
seem to want to wait that long.

Thanks

"Scott Allen" <bitmask@[nospam].fred.net> wrote in message
news:478i9056sj61ep5on995ocu0ttjntv4g4o@4ax.com...
> 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(Command
B
> >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.RaiseP
o
> >stBackEvent(String eventArgument)
> > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> >sourceControl, String eventArgument)
> > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> > System.Web.UI.Page.ProcessRequestMain()
> >
>

Loading