473,320 Members | 1,979 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How do I debug this Datagrid?

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.
-----Original Message-----
I am having almost constant problems with these bound Datagrids in my VB.NETWeb Forms app.
I got one working just fine but this last one is just a killer. Right when Ipass back my dataset and call the update method (from doing an update on thegrid), 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. Imade sure that I am sending back the exact same parameters (in the sameordinal position) as to update as are in my select (same datatypes). I checkeach item in the immediate window no nulls or odd data. I am putting thename 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 haveto make things a little more straight forward.
.

Nov 20 '05 #1
0 754

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Aaron Ackerman | last post by:
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...
5
by: Iain | last post by:
I've an application I've been working on for some time which has a Windows Forms User interface, a set of 'business object' classes and interacts with a SQL Server database and some Legacy COM...
3
by: SStory | last post by:
2 questions. I have two XPPro boxes. One has VS2003 Pro installed. The other box has IIS and MSDE installed. 1.) What do I do to make the IIS on this 2nd machine ready for .NET and...
0
by: JIM.H. | last post by:
Hello, After this two lines, how can I check which records available in the dataset in the debug mode? sqlDataAdapter1.Fill(dataSet11); dataView = dataSet11.Tables.DefaultView; I was using GUI...
8
by: ST | last post by:
Hello everyone, Can anyone help me with this error above when I debug my web app project in vstudio.net?? I can't figure it out! It was working fine for months, and now all of a sudden it's not!!...
9
by: Brett Romero | last post by:
When I create this table and add it to my DataGrid (framework v1.1), the TableStyle works fine: DataTable dt = new DataTable(); DataColumn dc = new DataColumn("AreaCode"); DataColumn dctwo =...
2
by: neocarl | last post by:
Hi, I am fairly new to VB.net and ADO.net. I am having a problem when Connecting the database to to website i am creating with vb.net. Basically The final step I did was create the datagrid, so...
1
by: traptiatoz | last post by:
I am using Asynchronous delegates and callbacks in a C# application. Using BeginInvoke() I am calling a function (finds valid item) that returns a list of items in the EndInvoke(). While executing...
8
by: Jothishankar | last post by:
Hi, I am new to c#. I am trying to build an application that does backup of files to an external hard disk. My application behaves strangely. When i run the application under debug mode (F5),...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.