How do I debug this Datagrid?

  • Thread starter Thread starter Aaron Ackerman
  • Start date Start date
A

Aaron Ackerman

I am having almost constant problems with these bound Datagrids in my VB.NET
Web Forms app.
I got one working just fine but this last one is just a killer. Right when I
pass back my dataset and call the update method (from doing an update on the
grid), it bombs with that rediculously generic SQL error (BIG HELP MS!!).

How do I debug this thing? I took all of the contraints off the table. I
made sure that I am sending back the exact same parameters (in the same
ordinal position) as to update as are in my select (same datatypes). I check
each item in the immediate window no nulls or odd data. I am putting the
name of the Dataset table in the update method: Dataset.Update(MyDataSet,
"MyTableName"), What gives???

You know if MS wants us to use these bound controls they are going to have
to make things a little more straight forward.
 
your msg is a little generic.
But the best way to debug anything is step through it
before it bombs.

How you do this?
Put a break-point at the call prior to the update sub or
function.

Using F11 step through.

Just to be on the safe side assign a string to your
update call. Then call that string in your immediate
window and paste in your query analyzer window(if it runs
in query analyzer then it will run in vb).

if you still have a problem with your update use
something like the DAAB this is good life saver.

daab=data access application block.


hope this helps
 
if you're getting a sql error then the error occured on
the SQL side and not in the grid or dataset.

use sql profiler to capture the sql statement.
paste it into query analyzer and debug the sql.
once you know what the problem is, finding where it's being
caused may be easier.
 
Hi Aaron,

I agree with mannyGonzales's reply. Have you every tried his suggestions?
If yes, can you provide us with more information?

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| Content-Class: urn:content-classes:message
| From: "mannyGonzales" <[email protected]>
| Sender: "mannyGonzales" <[email protected]>
| References: <[email protected]>
| Subject: How do I debug this Datagrid?
| Date: Tue, 14 Oct 2003 21:29:30 -0700
| Lines: 23
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOS1Ozi+I6US6jcSiqhYeKTM5imrw==
| Newsgroups: microsoft.public.dotnet.languages.vb
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:146773
| NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
|
| your msg is a little generic.
| But the best way to debug anything is step through it
| before it bombs.
|
| How you do this?
| Put a break-point at the call prior to the update sub or
| function.
|
| Using F11 step through.
|
| Just to be on the safe side assign a string to your
| update call. Then call that string in your immediate
| window and paste in your query analyzer window(if it runs
| in query analyzer then it will run in vb).
|
| if you still have a problem with your update use
| something like the DAAB this is good life saver.
|
| daab=data access application block.
|
|
| hope this helps
|
|
 
Hi Aaron,

I'd like to know if this issue has been resolved. Is there anything that I
can help? I'm still monitoring on it.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

--------------------
| X-Tomcat-ID: 337662892
| References: <[email protected]>
<[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: (e-mail address removed) (Kevin Yu [MSFT])
| Organization: Microsoft
| Date: Thu, 16 Oct 2003 13:42:08 GMT
| Subject: RE: How do I debug this Datagrid?
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
| Message-ID: <TabMQt#[email protected]>
| Newsgroups: microsoft.public.dotnet.languages.vb
| Lines: 46
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:147283
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Hi Aaron,
|
| I agree with mannyGonzales's reply. Have you every tried his suggestions?
| If yes, can you provide us with more information?
|
| Kevin Yu
| =======
| "This posting is provided "AS IS" with no warranties, and confers no
| rights."
|
| --------------------
| | Content-Class: urn:content-classes:message
| | From: "mannyGonzales" <[email protected]>
| | Sender: "mannyGonzales" <[email protected]>
| | References: <[email protected]>
| | Subject: How do I debug this Datagrid?
| | Date: Tue, 14 Oct 2003 21:29:30 -0700
| | Lines: 23
| | Message-ID: <[email protected]>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="iso-8859-1"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| | Thread-Index: AcOS1Ozi+I6US6jcSiqhYeKTM5imrw==
| | Newsgroups: microsoft.public.dotnet.languages.vb
| | Path: cpmsftngxa06.phx.gbl
| | Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.languages.vb:146773
| | NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| | X-Tomcat-NG: microsoft.public.dotnet.languages.vb
| |
| | your msg is a little generic.
| | But the best way to debug anything is step through it
| | before it bombs.
| |
| | How you do this?
| | Put a break-point at the call prior to the update sub or
| | function.
| |
| | Using F11 step through.
| |
| | Just to be on the safe side assign a string to your
| | update call. Then call that string in your immediate
| | window and paste in your query analyzer window(if it runs
| | in query analyzer then it will run in vb).
| |
| | if you still have a problem with your update use
| | something like the DAAB this is good life saver.
| |
| | daab=data access application block.
| |
| |
| | hope this helps
| |
| |
|
|
 
Back
Top