HighTechTalks DotNet Forums  

databinding

ASP.net Data Grid Control microsoft.public.dotnet.framework.aspnet.datagridcontrol


Discuss databinding in the ASP.net Data Grid Control forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Doug Durrett
 
Posts: n/a

Default databinding - 08-03-2006 , 03:26 PM






I'm having an issue and wanted to pass by everyone to see what you think.
Here is my code.



searchs = new
Maritz.Learning.HP.Callcenter.BusinessServices.Sea rchs(base.ConnectionString);



searchs.Search(this.FirstNameTextbox.Text, this.LastNameTextbox.Text,

this.EmailTextbox.Text, this.CityTextBox.Text, this.StateTextBox.Text,
this.ZipTextBox.Text, this.IssueTextBox.Text, this.CompanyNameTextBox.Text,
Convert.ToInt32(this.SiteDropDownList.SelectedValu e.ToString()),
Convert.ToInt32(this.StatusDropDownList.SelectedVa lue.ToString()));



this.ResultsDataGrid.DataSource = searchs;



this.ResultsDataGrid.DataBind();





This is on a click event from a web page. When the button is clicked the
searchs object is created and populated from a sproc. Then simply set the
datasource and bind it. This works perfectly, however, if I click the
button a 2nd, 3rd, or 4th time (usually on the 4th click) everything works
until I get to the DataBind(). The system will hang on that line and
produce this error.

Server Error in '/' Application.

--------------------------------------------------------------------------------

Failed to open a data connection
Server=FENSQLLIBD01;database=HPCustomerSupport;use r
id=HPCustomerSupport;password=*2rT44Y* - please check the connection string
and security settings!
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.Exception: Failed to open a data connection
Server=FENSQLLIBD01;database=HPCustomerSupport;use r
id=HPCustomerSupport;password=*2rT44Y* - please check the connection string
and security settings!

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:

[Exception: Failed to open a data connection
Server=FENSQLLIBD01;database=HPCustomerSupport;use r
id=HPCustomerSupport;password=*2rT44Y* - please check the connection string
and security settings!]
Maritz.Learning.HP.Web.CallCenter.Tracking.searcht ask.SearchButton_Click(Object
sender, EventArgs e) in c:\inetpub\wwwroot\hplogging\search.aspx.cs:90
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String
eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl,
String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277




--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573



Have you ever seen anything like this? Thanks in advance.




Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.