Saving table

  • Thread starter Thread starter simonZ
  • Start date Start date
S

simonZ

I have a dataTable in my memory(session).

Can I save this table into sql dataTable in one step?

Now, I'm iterating through the records and saving record by record with
command object.

But it's slow process. Any idea?

Regards,Simon
 
Hi,

I already find it and it works perfect.
I used SQLBulkCopy.

regards,Simon

Eliyahu Goldin said:
I don't think you can do much more than tuning your database performance.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]


simonZ said:
I have a dataTable in my memory(session).

Can I save this table into sql dataTable in one step?

Now, I'm iterating through the records and saving record by record with
command object.

But it's slow process. Any idea?

Regards,Simon
Click to expand...
Click to expand...
 
Back
Top