Any great ways to return an Autonumber field that was set by an INSERT? I
really liked ADO's recordsets, getting the autonumber value was easy then...
Thanks!
Jim

I developed a program that updates the database using a DataSet. I am
testing it against an Access database. If I get the data from the database
using the SQL statement without a WHERE clause, I am able to change data in
the DataSet and use the Update command in my DataAdapter. ...

When using the DataTable.Select method, can I select values that are NULL?
Example:
myRows = myDataset.myTable.Select("anotherId=NULL")
I've tried the code above, no errors but it doesn't filter out the rows with

Is it possible to join two tables on two separate oracle databases?
I would like to have two connections to two databases and execute a
query joining two tables in each db.
Dim connString1 As String = "Data Source=ds1;etc.."

I use Access MDB to store lots data records, and lots records need to be
inserted or updated. Before that, I'd check if the record or its ID exists.
The speed is important because data come from network.
For few records, I could use SELECT to verify an record one by one. For this

I have had some troubles getting a secured Access database to talk w/my C#
application. I have created a username/password combo in Access and I have
received the familiar:
The workgroup information file is missing...

I'm using MSSQL and VB.
I want to pull an item from an "Inventory" table and assign it a
"TransactionID", then insert it into (or insert with a default value in the
TransactionID column) a "Transactions" table.

Hey all,
 I currently have a stored procedure that accepts 1 parameter, and passes
the rowcount out.  Using ASP.NET/SQL, how can I create a function/stored
procedure to do the following:

I presently have a SQL Server supplying data using ADO.Net and query strings through a designated SQL port (opened on my Cisco Pix firewall) to an IIS server running my ASP.Net applications and then exposing it all to the web.
I want to be able to expose PDF files with the SQL ...

I have a laptop that I am developing my ASP.NET app on while in the office
and I connect to our SQL database located on the network in the office.
However, when I take the machine home, I connect to a local copy of the
database that is on my machine. I have added a key in the web ...

I know that ODP.NET will let you do SavePoints using
OracleClient.Save("..."), is there an equivalent of that functionality in
System.Data.OracleClient?
Thanks,

Can anyone tell me what is wrong with the following code?  I get an error
message that states: An unhandled exception of type system.argumentexception
occurred in system.data.dll    these columns don't currently have unique
values

Hi again,
I'm still getting this error when I bind the datagrid with a Datatable:
Sorry for the second post on this matter.
A first chance exception of type 'System.IndexOutOfRangeException' occurred

I've got a strongly typed dataset that I'm trying to Fill in with an
adapter.  The dataset has 3 tables in it, PageData, RowData and SummaryData.
I'm trying to ::Fill into PageData with the following SQL:
SELECT distinct SRC_DBINDEX, SRC_TAG, src_descript FROM RPDCY_T

Environment C# 2003
I have a stored procedure consisting of two select statements. I succesfully dragged this onto a new dataset creating a 2 table dataset. I also verified that the relation between the tables is correct.
I use this code in an attempt to fill the tables:
DataSets ...