Hi I am trying to fill a datagrid using the following snippet:
GetSQL = "Select QID, Q, A, B, C, D, CorrectAnswer, Expired " & _
                "From Questions " & _
                "INNER JOIN " & _

My question is quite straightforward:
How do I get the parent row of a deleted (child) row. If I use the method
"GetParentRow" of the child then it returns "nothing". I have tried using the
version parameter of the method but without any result.

Hi all,
I have populated my grid from a dataSet.
1) I want to enter certain values and in Caps in my second col. Like I want
to enter only 'PAT' or 'SAT'. is this possible.

I have just installed Visual Studio.net 2003 Enterprise Architect.
I have been using Visual Interdev so far, and I am used to be able to select
from a desktop, drag bunch of .asp files, and drop them into a Project
Explorer window and have it show there as a tree of files. Is there ...

We are having a problem with OleDbDataAdapters. We have found that if you
call the .Fill method twice the second time it returns no rows. You can also
reproducs this by persisting the recordset to XML first. If you persist it to
binary format it works fine.

Hi - I am developing a database class which accesses an Access database to
simply retrieve decimal values. When I call the code below it fails with an
'
Unspecified error' - The database it calls have the 2 columns (BEGINDEC &

2 Part Question:
I've a VB.net application where I read information from 7 Tables in a MS
Access Db.  There is a performance hit when this happens (about a 1-2 second
hit per table).  So I'm going to combine the relavent parts of each table into

Can't create DataAdapter in code that's available throughout form
In form_load I write the following code:
           Dim daC As New OleDbDataAdapter("SELECT * FROM Concepts",
cnConcepts)

Can't create a new dataset from the toolbox.
In the past, on the advice of MVPs, I've created datasets by dragging the
dataset component from the datatab of the toolbox onto the form.  The first
time it created dataset1, a dataset that did not exist before.

In my DataSet, I'm trying to keep track of row deletions, so later I can check HasChanges to see if I need to update the datasource.  I'm trying to delete a specific row in the dataset that I search out from a primary key.  I've found the DataRow I want to delete and have a ...

   I suppose this question reaches a little further than just DataSets, but
I was wondering if I should/need to call the Dispose() method on a DataSet
I'm about to reassign.  For instance:
DataSet m_DataSet = new DataSet("My DataSet");

== Description ==
VB.Net will unfaithfully represent primary keys when they are
identified as an IDENTITY field for SQL Server tables. I will make
these mistakes when producing Insert Stored Procedures and when

I have a form that the user enters values on it. One of the fields I need to
validate what is being entered against records in a SQL table.
Something like doing a findfirst in Access and then doing a nomatch.
How do I go about doing this?

Hi experts,
I am not sure if I should use Merge on this case, but I want to add a
Vendor Name column in the datagrid1 where the Vendor Name has to get
from another server (not linked and can't be linked).

I think there must be a trick (in SQLserver or ADONET) to do it:
I have created a view with 4 fields. The last field is a calculated field
myView (From a relationship between Table1(T1) and Table2(T2))
T1.Agent     T1.Sales     T2.Charge       Total (Sales-Charge)