With Access?
I don't think so.
At some point, you'll be running a 1 row by 1 row operation. Whether you do
it manually, or allow the dataadapter to do it for you.
You might write a Updateable Query, and call it, but it's still a "per row"
method.
If it were me, I wouldn't rely on the dataaadapter, ... at least right your
own code for the inserts.
.........
Switch to Sql Express 2005 and you'll have more options.
I have no idea what this is:
http://www.codeproject.com/dotnet/ELAB.asp
but maybe you can look into it.
<ir*******************@yahoo.comwrote in message
news:11**********************@o80g2000hse.googlegr oups.com...
hello i am using c# in visual studio 2005 and need to insert a large
number of records contained in a dataset into an access database. the
following is too slow. how can i update my DataAdapter with all the
rows(150000) at one time? thanks
foreach (DataRow row in ds.Tables[0].Rows)
{
DataRow dr = ds1.Tables["testtest"].NewRow();
dr = ds1.Tables["testtest"].NewRow();
dr["field1"] = row["field1"];
dr["field2"] = row["field2"];
ds.Tables[0].Rows.Add(dr);
ad.Update(ds1, "test");
}