I'm trying to update my access database through an oledb data adapter that
calls an access update stored procedure on my dataset.  I realized that only
the first row modified gets updated in the database.  All other rows remain
unchanged.  Does anyone know why this is so and how I ...

If I have a datareader that receives two resultsets from a stored procedure,
is it possible to read the second one first, and return to the first
resultset to read it? To be more clear, I need to read the resultsets in
reverse order. Should I change my stored procedure to return the ...

This code should work, but does not:
' create data relationship
Dim parentCol() As DataColumn
Dim childCol() As DataColumn

Not sure if this post belongs here but here goes.
We call DataAdapter.Update where the CommandText is an sproc name.  Inside
the sproc, we have numerous IF statements.  I was recently told these IF
statements would cause the sproc to recompile each time it is called.  is

I am using a datarow in my application and I am looking for the best way to
test if a field is null or not.  Can someone give me any suggestions?
Thanks

I have written numerous crystal reports and connected them to sql tables and
stored procedures.  But evidently you can bind a report to a
dataset/datatable as the datasource.  Can anyone show me some simple code
that does this?  Also, when I open cr 9, where would I go to assign a

Is there a way to add multiple relations to two DataTable in a DataSet?
Here is the problem....
Table 1 contains aggregated data grouped a time_period and a network_key.
Table 2 contains the individual details from the source table in Table 1.

We use uniqueidentifier as the primary key for our records. We are storing
them in UniqueIdentifier columns in SQL Server and in RAW(16) columns in
Oracle. We use the HEXTORAW function to insert the value in the Oracle
database.

I have C#, web application, SQL Server appliacation. There is a webservice, which runs stored procedure, which deletes some row and add one new row in the same table. Although the changes are finished, another webservice cant see the changes immediately. The table is nearly empty ...

How do you retrieve an image in ADO.NET stored in a SQL Server 2000 table column? In ADO I used a Stream object to retrieve the image and then there was a method in the Stream Object to save the image to a file. I used the following code in ADO for this
imgStream = New ADODB.Strea

I would like to create a table in Access using ADO.NET. Is
there any way to do this? I know I can use ADOX over COM.
However, it would be more convenient for me using ADO.NET.
Thanks for any help you might give me.

I am wondering if there is a way to save a single DataRow in a DataSet.  I
already have a reference to the DataRow I wish to save but I cannot see how
to update anything other than the entire DataSet.
Here is the reason I need to do this.  I have designed some business objects

I am trying to use a parameter to retrieve some entry from my Oracle table
I used Microsfot OleDB Provider for Oracle
Here are the codes
cmd.CommandText="select * from users where user_name= ?")

I have populated a combobox from the database. How can I set my combobox such that as the user types the begining or first few letters of the name it autoatically narrows down to the right one?

Is it not possible to just create a new table in an existing database with
CREATE TABLE and without copying an existing table?
I have an empty database and when my program detects the tables aren't
there, I want it to create the table.