At several times in my code I am opening and reading data from data reader.
Would using the DataSet instead improve the performance? As few times in my
code ,  to get items one by one while the connection is still open, sound
like a resource hog to me...

I'm trying to bind a datarelation to a datagrid so that I'll show all the
columns from the first and second datatables that relate (parent/child).
The code below only shows the data from the master table? How do I include
the children?   I'm having trouble find docs on this.

I have the following query written for MS Access:
PARAMETERS [Enter a keyword to search] Text ( 255 );
SELECT TOP 10 ISBN, Title
FROM Books

I've managed to populate a dataset with two different datatables from
different webservices.  They each contain a different number of columns but
both have the Ticker symbol as a common key.
Is there a way to "join" or combine these the two tables based on the ticker

I was working on creating a data library to use throughout my applications,
when I came across an odd behavior.  I encounter “Cannot Open Any More
Tables.” After using the OleDBCommand.ExecuteNonQuery method.  I have
included code that recreates the exception.   I cannot recreate ...

On page 786 of the ADO.NET Core Reference (chapter 11 - Advanced Updating
Scenarios),  David Sceppa gives the basic steps for submitting hierarchical
changes (paraphrased):
1. Submit new master rows

Is it possible to be able to merge multiple DataTables in a DataSet?
What is the intructions/code for doing so?
Thank You
Prasun

I use The RowFilter property to select number of row from my dataview.
How can i get the number of rows found ?
I experience that the number of rows remains the same  as before the filter
was applyied if there i no match for the filter.

I was developing an ASP.NET application using c#, and I was thinking
for adding some instance variables for my xyz.aspx like this :-
public class SetCustomers : System.Web.UI.Page
    {

What is the best way to create a datasource for a single flat grid that
pulls from multiple updateable datatables?
I'd like to pull back multiple tables, create relationships between
them, then have a grid bind to a 'view' of these tables so that when I

I was using the following classes to get data from. Now I would like to know
which class shall I use from  Windows Forms VC++ 2005.
CDaoDatabase m_Dao;
            // Variables in  String Table

I'm having a typed dataset, where a datatable has some columns which are
expressions.
After doing a Merge, i was expected that my expression columns were
calculated, but they were not.

I've set the Caption property for a table in DataSet, so when hte DataSet is
binded to a Datagrid, the caption is displeyd instead of the column name.
But it doesn't work. I get the column name instead of caption.
What may be the cause?

I've just discovered that the Jet OLEDB Provider does not support
OleDbCommandBuilder.DeriveParameters, to discover the number and type of
parameters expected by a Microsoft Access query.
I'm a little surprised, as it was always possible to use the ADO Refresh

Hi guys...
I have a web app that works pretty good . It was developed with the access
database in the virtual directory....now thats its about done, i would like
to reference the database from a shared network directory. I thought all I