I use VB.NET/ADO.NET to access an Access database and I need a very quick way of inserting loads of rows into one table in the database.
There seems to be so many different combinations/solutions but I need the quickest one!
My VB.NET book seems to give many code examples on how to retreive data, but what is the best way to insert data?
Really appreciate some ideas or code samples.

Anne

Hi aslyon,
   Your Data should be store in a DataSet(ds) and DataTable(dt), just Set your data adapter. your data adapter should contain the parameter and query.

da.insertcommand.connection = con
ds.update(dt)



~ Human Knowledge Belongs to the World !

I have tried to do the update to a data adapter and have even followed the Microsoft book and it just doesn't work.

I keep getting an error that no value is given for one or more parameters....

But when I add a row to the data set with new data it asks me for an Insert command!

This is one of the most frustrating things going. VB6 was so much easier.


Guy

You have to tell the data adapter how to insert your data! You give it a Select statement when you create it, but it is not clever enough to figure out the Update/Insert/Delete statements. Either you have to code it manually (myDA.InsertCommand = ...) or you can use a CommandBuilder:
Dim myCB as New oledb.oleDBCommandBuilder(myDA)
which automatically creates Update & Insert statements based on your Select statement.

Anne

Thanks Anne, that clears things up a bit.

I did try the technique that you mentioned but to no avail....I guess it is a problem between the chair and the screen right now...grrr

Oh well back to the grind stone

Guy

Guy