I am loading a DataSet from an access file (exported from another app that a
vendor provided) and want to appendthe data into an SQL Table that has the
same structure.
I can easily append rows to the SQL table, but that can't be a best

Hello, my main VB .NET 2003 + Access program wasn't working so I
created two small sample applications to test why I get the following
error:
ForeignKeyConstraint ProductOrder_Product requires the child key values

Hi peers
I want to know yours opinions about those ORM (Object-Relational Mapping)  
tools , my company is going to start using it.
What are the good and bad things about?

I have a function name GetLabData which call a store procedure .
For that function I need to create the Adapter.InsertCommand an DeleteCommand
My InsertCommand works fine and build as follow :
======================>

Right...I have an access Database with around 10 tables. I have
modelled only a few of these in the XML Schema (enough to get my
program working) and assigned the relevant DataRelations.
Anyway I'm having problems with a three table

Hi, as many before me, and probably after me, I recieved the following
error when I try to update my table using a typed dataset which
contains serveral tables.
The Delete/UpdateCommand affected 0 records

I believe I may be encountering a bug in the way
System.Data.OracleClient is issuing commands:
The following code you will see that the CommandText is different.
           OracleConnection con = new OracleConnection();

typed dataset and untyped dataset, which one is faster?
I think the answer is typed, but some one told me is untyped.
Who can tell me the answer and the reason?
thanks

I have three datatables, the last of which represents a many-to-many relationship.  Here's how it looks:
Table #1
attID (autoincrement)
Attribute

Hiya guys,
earlier on today I had a discussion (to avoid calling it an argument
^.^) with my friend. We were discussing about whether there's really
one good way to efficiently retrieve data from a database.

I need to retrieve a list of SQL servers that are running on a local machine.
I have tried using:
  SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
  System.Data.DataTable table = instance.GetDataSources();

My application needs to run at many different sites and I need to depend on
a DSN set up by another application, so I want to check for the DSN's
existance right up front before bothering to do anything else.
I found this link

I'm writing a very simple Windows App in C# with Visual Studio 2005.
I have a DataSet composed like this :
DataTable CLIENT
DataTable COMMANDE

im trying to access a microsoft access database from an asp.net
webform. but when i use the OdbcDataAdapter config wizard i get the
folowing errors:
*Generated UPDATE statement

I hope someone can help with this relatively simple problem.
I am building a timesheet application using ASP.NET C# with Visual
Studio 2003.As it is only a protoype application, my database has been
made in MSDE.