c# .net Exception of type System.StackOverflowException was thrown.


	ASP Shopping Cart, Forum & BBS - all for $20 from CodeToad Plus!

Home || ASP | ASP.Net | C++/C# | DHTML | HTML | Java | Javascript | Perl | VB | XML || CodeToad Plus! || Forums || RAM

Search Site:

CodeToad Forums » C++ » c# .net Exception of type System.StackOverflowException was thrown.	Search Forums:
This 17 message thread spans 2 pages: [1] 2 > >

c# .net Exception of type System.StackOverflowException was thrown.

dominikm86 at 16:29 on Wednesday, May 30, 2007

hi. i am making a c# web app and the program is to take a crystal report, update the information from the database and display it on the screen. for some reason i get this error when i run the code. i googled around and could not find any help. thanks if you can help me!

Exception of type System.StackOverflowException was thrown.
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.StackOverflowException: Exception of type System.StackOverflowException was thrown.

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:

[StackOverflowException: Exception of type System.StackOverflowException was thrown.]

private void Page_Load(object sender, System.EventArgs e)
{
ReportDocument report = new ReportDocument();
string strReportName = "NewClaimsReport";
report.Load(Server.MapPath(strReportName + ".rpt"));

string connectionString = "Data Source=webserver;initial Catalog=StrWebFlow;user id=stronereport;password=ma$terpwd;Integrated Security=SSPI;";
SqlConnection sqlConnection = new SqlConnection(connectionString);

string strSql =
"SELECT Claims.FileNo, Claims.JobName, Claims.InsReceivedDate, "+
"ClaimValues.JobType, InsCompanies.InsName, wfUsers.FirstName, wfUsers.LastName "+
"FROM Claims, ClaimValues, InsCompanies, wfUsers, Adjusters "+
"WHERE Claims.ClaimId = ClaimValues.ClaimId "+
"AND InsCompanies.InsAccId = Claims.InsAccId "+
"AND ClaimValues.InsAdjusterId = Adjusters.AdjusterId "+
"AND wfUsers.UserId = Adjusters.UserId;";

SqlDataReader objDataReader;
SqlCommand objCommand = new SqlCommand(strSql, sqlConnection);

sqlConnection.Open();
objDataReader = objCommand.ExecuteReader();

string strInsert = "";
bool boolCheck = false;
while (objDataReader.Read())
{
if(boolCheck)
{
strInsert += " and ";
}
boolCheck = true;

strInsert +=
" {Claims.FileNo} = '"+ objDataReader.GetValue(0) +"' and " +
" {Claims.JobName} = '"+ objDataReader.GetValue(1) +"' and " +
" {Claims.InsReceivedDate} = Date('"+objDataReader.GetValue(2)+"') and " +
" {ClaimValues.JobType} = '"+ objDataReader.GetValue(3) +"' and " +
" {InsCompanies.InsName} = '"+ objDataReader.GetValue(4) +"' and " +
" {wfUsers.FirstName} = '"+ objDataReader.GetValue(5) +"' and " +
" {wfUsers.LastName} = '"+ objDataReader.GetValue(6) +"' ";
}
sqlConnection.Close();
report.RecordSelectionFormula = strInsert;

DiskFileDestinationOptions objDiskFile = new DiskFileDestinationOptions();
string strFileName = strReportName + "/forum/.pdf";
objDiskFile.DiskFileName = Server.MapPath(".") + strFileName;

report.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
report.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
report.ExportOptions.DestinationOptions = objDiskFile;
report.Export();

Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";

Response.WriteFile(strFileName);
Response.Flush();
Response.Close();
}