sqlDataAdapter

[Analizer1]

How Can i set SqlData Adapter to update like a Batch Update

for instance: I have 10,000 rows that have changed
when i call SqlDataAdapter.Update(table)
it seems like its updating 1 row at a time

Tks

 

[Alberto Poblacion]

How Can i set SqlData Adapter to update like a Batch Update

for instance: I have 10,000 rows that have changed
when i call SqlDataAdapter.Update(table)
it seems like its updating 1 row at a time

You set the property UpdateBatchSize of the SqlDataAdapter to the number
of rows you want to update at a time. Note that this property is new in
version 2.0 of the Framework. It can't be done in previous versions.

 

[Analizer1]

Thanks Alberto

You set the property UpdateBatchSize of the SqlDataAdapter to the number
of rows you want to update at a time. Note that this property is new in
version 2.0 of the Framework. It can't be done in previous versions.

 

[Peter Bromberg [C# MVP]]

I feel a Test App coming on using the Stopwatch class...
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
MetaFinder: http://www.blogmetafinder.com