The is a bad bug in this method where after updating the DataSet follows
this statement:
          dataSet.AcceptChanges()
It is not only unnecessary, it wipes out any pending updates for other

I am trying to run a query that will return a date. I wanted to pass the contents of an arraylist as a parameter to the query. The query will need to be run many times for each value in the arraylist so i have placed the code in a loop. What i am confused on is how i actullay use ...

I am trying to Add and Update data to Access database, the update part works
just fine, but when I try to add data I get the following error, what am I
doing wrong?
---------------------------

Here is my saga . .
I have a VB.Net project that works on my development system when hitting my own loca
SQL Server 2000, but has problems when I try to hit the production SQL Server (stil
running the code on my development system.

I can't find how to transfer a datatable in one time to an empty access
table...
Is this possible?
Thanks for your help!

Where's the best place to setup an application wide SQL connect string for a
C/S style application?   We want to read the value from the registry.  Also
I'm thinking about using the DataAccess block.
  -Bill

What namespace do I need to import to get the object OdbcConnection?  And
where would i find out such information?
Thanks!
--Steve

Using Excel 2000 under Win 2K Pro with MS ActiveX Data Objects 2.5 Library:
I would like to be able to determine if a database has been modified since
my last read. I create my database connection thus:
   Dim db as ADODB.Connection

I am using SQL Server 2000 as the backend for an application in C#.  Is
there a way to do a join on tables in different databases or do you have to
do some in memory slight of hand to accomplish it?
Any help is greatly appreciated.

My company is considering scaling up a database application that previously
used Microsoft Access. The database has about 25-30 tables in it. The amount
of daily transactions to the database is fairly small for that number of
tables, but is growing.

I am trying to dynamically change a DataTable by clearing the table, columns, rows, and PrimaryKey -- recreating the column collection, recreating the PrimaryKey, and finally adding the new rows
However, after invoking DataTable.Clear() along with clearing all the other ...

The problem is that when using SqlCommand.ExecuteReader
and the SQL statement raises an error of severity of 16
then ExecuteReader throws an exception, when you use
OdbcCommand.ExecuteReader the exception is not raised but

In the DataAccess block example, they create a database connection in
GetConnection method of the sample form (Form1) which is called at the
beginning of each of their examples.  But in their SQLHelper Class they also
create connections in many of the methods such as ExecuteDataset.

im not great at sql and need to nest these statements ( for speed) but
cant get it i would appreciate any help thanks"
SELECT qryExistingPersons.Person,
qryExistingPersons.SumOfInvoiceAmount, qryExistingPersons.CheckNum,

Who is the responsible for the installation of the classic ADO pia
(adodb.dll)? Is it installed by the .NET Framework package or by the MDAC
package?
Thank you.