I am calling an Oracle stored procedure which has no input or output parameters, and only does an insert to a table on a remote Oracle server, like this
PROCEDURE Joe_test I
  BEGI
          insert into leslie@acc_db2 values ('insert')

I get how to populate a dataset by querying a database server... but once
I've populated my dataset, say with several related tables, how can I then
select records from the dataset copy of data using SQL statements instead of
the database server itself?

I am getting this error on as asp.net page from within a dll.
I am fairly new to .net so if someone can help me I would appreciate it.
The error is occurring when I try to read from an Access Database within a
function.  Here is the code:

I'm using VS.NET 2003 (VB) and I have been getting this message when I
attempt to use OracleClient to make a connection to Oracle.
Oracle - Unable to load DLL (oci.dll)
Description: An unhandled exception occurred during the execution of the

Hai friends
I have a problem in writing query for composite primary key.                      
Problem -
                       1) clientid and dpid is composite primary ke

I'd like to create a hierarchical dataset for the different subdirectories
etc(however deep the structure may be) while iterating through the directory
structure starting at a particulardirectory on the server machine
"C:\inetpub\wwwroot\myapplication\startingpoint.

Does dot net support the resizing of animated GIFs?  I've heard that it
doesn't.  Why is that, if it's true?

I have a datatable (created in a vb Windows forms app) and I want to export
it to Excel.  I've looked at...
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q295646
...where it suggests using something like....

I'm writing a data acquisition program that will be acquiring data and storing it within multiple tables of a DataSet.  I'd like to export this data set directly to a new excel file if possible.  I'd like each table of the data set to be a new worksheet within excel.  My customer ...

is there a way to tell when the database connection is retrieveing data? i
saw the connectionstate.fetching enumerated value, but of course it's not
implemented yet... is there another way to do this? thanks!

In my asp.net projects I like to seperate the database connection and
lookups/executes from the code-behind pages using shared functions.
I find myself often using a function that returns a datatable given a
sql query and it works great.  The function is contained in my

I need a bit of guidance if someone has a second.
If I have a dataset with a lot of records, and I have a form that
allows users to edit and/or add a lot of records at once, what do my
insert and update statements need to look like?

I'm trying to bing ComboBox and getting error:
"An unhandled exception of type 'System.ArgumentException' occurred in
system.dll
Additional information: Could not bind to the new value member."

I use ADO.NET to import records from a comma delimited text file into an Access data table. The table has 1 int field (prim key), 5 text fields and 4 date fields. The text file has 50000 records. There are no records in the table to start with
I parse the text file and for each ...

I am updating a SQL Table with a Top 10 Select.  The update command was generated by DataAdapter.  All the rows of the table are updated with the values of of the tenth row.  I have printed out the VB data rows and they have the differenct values one would expect.  What am I ...