I have a dataset with data populated with the adapter's select command from
SQL Server.  I have changes some of the keys and would like to save the
dataset as new rows and not update the existing ones (i.e. Save As).  Any
easy way to do that?  Must I manually move one dataset to ...

If I delete a parent row in and ADO.NET DataSet, will relational child rows
also be deleted?

Follow up to my last week' postings on connection pooling issue we
experience. Thanks all for your replies but since I still don't have a
solution – I've decided to start a new thread. Here is a link to the
original thread: http://tinyurl.com/yu68q

Two types of constraint classes are defined in System.Data namespace, namely
ForeignKeyConstraint and UniqueConstraint.
They are both based on the abstract class Constraint (also in System.Data).
It occurs to me that it should be possible (and convenient) to derive user

I need help as I am new to VB.NET, could someone please show me a code
example that will do the following or what is wrong with mine:
I have 1 Comand Button (btnsearch) and 1 text box (txtsearch).
I have an access database (Documents) that I want to search for records. I

I need to be able to call a web service method, receive the dataset that web
method returns and store it in an access table. My problem is that I don't
know how to "receive" a complex type like a dataset and how to link it to
the access table that it is supposed to go in. Could ...

I'm attempting to import data from an external source into a database. My
question is how can I compare the value of a specified column that is not a
primary key before adding the row to my dataset (and then into the db)?
My process is this:

I have an application with a typed dataset. The application works fine if I fill the dataset from a SQL Server connection. However, recently, I've been trying to change the application so that it reads from an XML file. This was supposed to be easy, but its turning out not to be.

I have a stored procedure that when I execute it in Query analyzer executes
in 1.2 seconds. When the same sp executes from .NET C# the duration is 6.8
seconds. I'm using profiler to measure the duration of the sp.
Have anyone experienced anything like this?

Can't create two databound listbox relationship
I have a table named Concepts
Four columns - Active(Boolean), ID(integer), ParentID(integer) Concept(string)
Top level as a ParentID = 0

Is it possible to use a DataAdapter table to perform an insert.
The DataAdapter table would be filled with data from an excel sheet and I would want to insert this data into a Sql Server table.
Example --
cmdInsert = New SqlCommand("Insert into authors select * from ...

I have a datagrid bound to a dataset.  I'm detecting when a single column
value has changed in the datagrid using the DataColumnChangeEventHandler.
Can anyone tell me how I could obtain the value BEFORE it was changed?  The
DataColumnChangeEventArgs doesn't seem to hold this ...

I'm building an application with ADO.NET and VB.NET.
This is the issue that I have right now;
I'm using this code with a data reader to populate a form from a database
(sqlServer, MSDE)

I am new to .Net and would use a recordset.edit, and recordset.update in VB6 to edit a field in a row, but I am writing a program in which I want to perform a calculation, and write the result to a field in a database.  How do I open a row for editing, and close the row when Im ...

I am new to .Net and would use a recordset.edit, and recordset.update in VB6 to edit a field in a row, but I am writing a program in which I want to perform a calculation, and write the result to a field in a database.  How do I open a row for editing, and close the row when Im ...