How can I get the ID (in a autonumber field) for the last added record in
access?
TIA!

Hi to everyone,
I created a Access Database (*.mdb) file.
I configured the connection string on the Server Exploer.
My problem is that this conncetion string has a path pointing to mdb file.

Is there a way to compare the contents of two datasets based on a common
field and list what does not match?
Thanks

I'm new to ado.net/asp.net -
After a user fills in a webform I'm trying to add a row to the table with
its values.....
but after running this code (no errors) and i check my table - nothing is

How do I implement old ADO recordset.UpdateBatch method when using DotNet
XML?
The old XML seems to contain enough information to allow the UpdateBatch to
work when XML was sent to a middle tier.

IS there a better way to join 2 datasets into one, than
adding rows from datset1 to dataset2 through a loop?
thanks in advance.
I need this to show the common result in a datagrid.

I have a application that connects to an access database.  I need to insert
an item into one of the tables and immeditely retrieve the value from the
autonumber field so that I can use that value into a record in another
table.

I have created a strongly typed dataset in C# using "Generate DataSet"
from the schema viewer/designer in Visual Studio .Net 2003.  And I'm
using this in a Windows Forms application.
The database is an Access file.

I'm using a listbox to hold objects. The objects are a class I made.
Allis well except when I do a listbox.items.clear, it clears the
listbox, but judging by the mem usage climb each time I re-populate
the listbox, it does not look like the previsous objects are being

I am using the v2.0 FillDataset method with a pre-existing typed dataset. 1
or 2 tables seems to work fine, but 3 or more do not fill the pre-existing
tables, but add new tables Table2, Table 3 instead.
I thought this was stange so went back to the supplied sample VB project,

I have a DataGrid bound to a DataTable.  I issue a SqlDataAdapter.Update
command to apply the user’s changes to the database.  Everything works just
fine.  However, in the database (SQL Server) I have a trigger which updates
one of the columns.  I want the updated column to ...

Hi I am trying to open or to fill in to dataset sample excel file. Got it
working couple days ago, but it is giving me error now. It is same error on
2 different machines. Please help.
Code......

what is the symbol equivalent to FULL OUTER JOIN?
I tryed *=* but SQLServer doesn't support it.
thanks,
Pascal

I'm not sure if this is an asp.net or ado.net question.
I have been using parameters with my Sql commands and have been getting
errors that say there is a problem with my input string, but there is no way
to look at what it is trying to do.

I have an SQL table with a 3 column key, PK = (a,b,c).  I read that into a DataTable:
SELECT * from MYTABLE where a=1 AND b=2
I edit this in a grid, hiding columns 'a' and 'b'.  During editing, column c values may
change, plus new records may be added.  After editing, I fill in ...