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

[nimraj]

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}

1) Storing the dataset into Access

2) Copying data from Oracle into Access or SQL Server

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...

 

[Paszt]

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.