I want to take all the data in an existing typed dataset (with existing data
in the underlying database) and copy these data to a new typed dataset,
except all the rows should be new rows.
My guess is that Dataset.Copy() would not work here since it gives me an

Hello, friends,
There is a function in SQL Server 2000, which return a number. How can I
retrieve this value in my C#.net app using ADO.net? Any sample source code?
Thanks a lot.

I just heard that the SqlRecord class is going to be chopped off out of .NET
2.0 RTM. Is that true?
If so, what will happen to SqlDataReader.ExecuteRow? If ExecuteRow remains,
what will it return?

Can a ref cursor contain other ref cursors?
Thanks in advance.

I'm looking for a relational and embeddable "file system based"
(non-client/server) database engine for .NET applications. Microsoft
JET (Access) is not an option, as it looks like it is being quietly
phased out without a replacement. So far I have found these three that

Is it possible to generate the t-sql script for a database schema and the
data from .Net(C#) at all?
Cheers
Ollie Riches

If I have a DataTable with n columns in it and m rows, is there a built in
function that would allow be to do this:
double [] vals = MyDataTable.ColumnValues[3]; // Assumes that all the values
for this column are of type double

Is there a way to do an insert with datasets without first querying the data
source?  For efficiency reasons I'd like to avoid filling the dataset from
the data source because in this case it's not necessary.

I have the stored procedure which uses temporary tables
and does some calculations.
It executes in 3 sec when I use Query Analyzer.
When I execute it using ADO.NET client it takes 30 sec.

I have been trying for the last hour or so to figure out a way to
update a DBase IV table. I have done this in the past with no problem.
However, this time the table has no primary key and no index. It only
has ten rows. The problem here is...how do I access each row, since

How do you append an Excel spreadsheet? This code
   string qry;
   string mdbConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
       "F:\\Databases\\bellpeek.mdb;";

I'd like to submit the default value of a SQL column as the value to send in
my parameter.  I know you can use DBNull.Value to enter NULLs.  Is there a
way to enter the DEFAULT value?
i.e.  in sql it would look something like  UPDATE MyTable SET MyColumn =

how can i get a list of the tabes within a database with ado .net, the only
access to databases that i know are possible is thru a reader, or thru a
dataadpter, in none of which i found any way of getting a list of the
database tables.

I'm using Visual Basic.NET 2003 and SQL Server 2000.  I'm attempting to pass
parameters to a stored procedure which will insert a record in a table.
The connection to SQL Server seems fine, but when my VB.Net app reaches the
ExecuteNonQuery() line I get an error:-

Ok, been having a prob for a bit and was wondering if there were easier ways
of doing some things.
1.  If you create an sql statement using a ? in-situ for a parameter, is
there any way of using Command.Parameters.Add() when the value you need to