Can't save new row to table
I'm trying to save a new row using the following code: It's a schema adapted
almost exactly from one given me by Kevin Yu some time ago.  One difference
is the inclusion of the ID field.  If I don't include it I get an error

I have a dataset that is based on an xml file, which contains the same
structure as a sql server table and is exported from a dataset.
When I do: sqlDataAdapter.Update(dataset, strTableName) I get the
error:

I have some lookup tables that provide various information, and I give my
users the ability to do all the "crud" operations. However, while I haven't
run into this yet, I'm mulling what happens when my users delete, for
example, a "reason code", but I do not want to cascade the ...

Okay so I've been going thru the Microsoft Data Access Application block.
It says that the following are best practices bla bla .. but here are the
obvious problems atleast I see from my viewpoint.
a) Using SqlCommandBuilder to derive stored proc parameters. I thought

Sorry, but I asked the previous question poorly.
I have two SQL Server databases (on the same server) and I want to reference
tables from both DBs
in the SQL.  I know that manually written SQL can reference tables in

Does anyone have any suggestions on working with large datasets (10GB -
100GB)?
Best initialization?
Transfer from dataset to database?

Hi, there
I have create a MS Access Stored procedure using the code below and no error
occured.
'---------------------------------------------------------------------------

I have currently using a dataset to access my data from sql server
2000. The dataset contains 3 tables that is related to each other.
parent/child/grandchild relationship. My problem is it's very slow to
retrieve records from sql server.

I have two SQL Server databases and I want to reference tables from both DBs
in the SQL.  How can I have a connection object that points to both DBs?
Thanks,
T

I'm writing a routine which queries a table in a mySQL database and then
adds records from it into a SQL Server 2000 database - pretty easy stuff.
Problem is, that the mySQL table may have additional columns every time I
query it.

I'm getting the following message trying to update a SQL Server table:
"General network error.  Check your network documentation."
I'm using stored procedures via a SQL data connection from within a .Net
windows application. The application producing the error, reads a table from

I'm getting the following message trying to update a SQL Server table:
"General network error.  Check your network documentation."
I'm using stored procedures via a SQL data connection from within a .Net
windows application. The application producing the error, reads a table from

Undoubtedly this answer is in front of my nose, but I can't figure it out or
find it anywhere.
Using VB.NET, Access database.
I have successfully built a series of nested queries that return results

I've been researching on the diferent newsgroups to find out how to do this,
but no luck so far.
I'm developing a client/server windows application with VB.NET, MSDE is my
backend database.

i create a dataset with table a, b and c in it.
Is it possible for me to generate extra table (e.g. d) into this dataset
based on table a and table b (which already exist in this dataset) ?
note that creation of table d, include a LEFT JOIN between table a and b.