Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableAdapter.Fill() fails but no error message
Message
From
29/01/2013 07:51:48
 
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01564371
Message ID:
01564469
Views:
29
>>>>Hi,
>>>>
>>>>I've been working on a local report and created a stored procedure which accepts a parameter and pulls back the relevant records. I have configured my report viewer on a form and load the data up like this:
>>>>
>>>>
>>>>invoicesReportTableAdapter.Fill(dataset.InvoicesSelectByManifestNumber, this.manifestNumber);
>>>>
>>>>Prior to making some changes to the underlying stored procedure everything was working great. I then realized I had pulled out an incorrect field and missed two others that I needed for the report. I changed the SP and reconfigured the xsd by editing it and choosing to configure it again. But whenever that line of code runs, it takes a few seconds and then my application shuts down before it returns. No error message. Any idea what this could be or how to debug it?
>>>
>>>Stop the debugger just before this line.
>>>Run SQL Profiler and then step down in debugger, see what is sent to SQL Server.
>>>You can copy and run this code with SSMS.
>>
>>Hmmm, I can't find SQL Profiler. Is that not part of SQL Server Express 2008 R2?
>
>Nope,
>Profiler doesn't exists in Express editions :o(
>Don't you have another edition of SQL Server?
>Developer, Standard...?

:) I've run the profiler, but have no idea of what I'm looking at so I need to do some research into how to interpret it. Any pointers to a good description?
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform