I am using the windows.forms datagrid and binding 2 datagrids to 2 different DataTables from a single typed dataset. The DataTables have a parent-child 1 to many relationship. When saving the data to an XML file (using dataset.WriteXML()), it gets written incorrectly sometimes.

I am working on a framework for my internal office affairs, but I've run into a problem that I just cannot figure out.
I am writing a new record to the database and expecting to get the @@IDENTITY of the record for my object.
Here's the code that is giving me problems:
           ...

Let's say I have three tables:
Customer
Order
OrderLine

I have a DataTable which is part of dataset, and has relation with other DatyaTables in the DataSet.
I have to make select on the DS tables, which its meaning is same as "IN", when I query on sql
E.G. Select T1.field1 from T1 where T1.Field2 in (select T2.field2 from T2 where ....)

Can anybody help me with the following, hopefully simple, question?
I have a table which I've connected to a dataset. I wish to add a new column
to the beginning of the table
and to fill it with incremental values e.g. if the tables looks

I'm trying to filter a table using the select method like this:
Note: dsSessionMngr is a strongly typed dataset
        CustRef is a string column in the dataset's table named CartDetails
Dim tb As dsSessionMngr.CartDetailsDataTable = Me.dsSM.Tables("CartDetails")

Just getting into ado.net and already hit a snag.  No problems when using a
datgrid however now that I've moved on to textboxes I cant insert.
My form has 5 textboxes, an adaptor/connection/dataset.  I simply want to
fill these out and create a new record from them.  I've simplified ...

Hi I have following code
public void Functon1()
{
   SqlTransaction trans=CreateTransaction();

using the following code, I've been unable to write an updated xml document.I can see the xml
file get refreshed but even at that, it writes in the original contents. these procs come from a
databaseengine class i created, theDataStore is a dataset that gets loaded from a xml data ...

I have an untyped Dataset I'm reading in from Excel and writing to a
.NewDataRow.
My problem is that some of the cells in Excel are empty and writing those
cells to the datarow cause a DBNull error. Here's my code:

   I have a web method that return a huge dataset (2Mb). I am interested to
know if there is a method to maximize the transfer speed of this dateset
over the internet.

I'm trying to load two tables in one dataset and connecting them with a
relation. Unfortunately, the result isn't as expected. Instead to load both
tables correctly, the field "KdNr" in the child table stays empty. In the
end, the function "GetChildRows" cannot find anything.

I have a store procedure that take a cursor as param that return a result
set like this:
procedure listprojects(io_cursor in out t_cursor)
where t_cursor is defined as

We are having issues with some of our applications that utilize connection pooling via the OracleConnection Class
Of the System.Data.OracleClient Namespace. At this time we are unable to determine of the problem lies within our code that connects to our DB and then executes the ...