Insert into Oracle/SQL/Access from a dataset using OleDB gang...

nimraj

New member
Joined
Dec 7, 2004
Messages
1
Programming Experience
3-5
How do you insert into Oracle/SQL/Access from a dataset using ADO.net ?

Hi,
It will be great if someone can point me to an article or give a sample for:
{using OleDB}

:confused: 1) Storing the dataset into Access

:rolleyes: 2) Copying data from Oracle into Access or SQL Server

:eek: 3) Insert/Append dataset into SQL Server (or any other database) which has the same colums.

Any help will be welcome, samples/parallels/hints/suggestions...
 
Last edited:

Paszt

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
Check this forum for examples. ADO.NET has been designed so that all dataBase types are used in almost the same way. An SQL dataBase would use the System.Data.SqlClient namespace, Access uses the System.Data.OleDb. I'm not sure about Oracle, but the answer should be easy to find.
 
Top Bottom