Saving table

[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

 

[simonZ]

Hi,

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

regards,Simon

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

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

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

 

[Eliyahu Goldin]

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