Hi Guys ,

There is one another method to update several rows with a single transaction.

use SQlbulkCopy class for that...........Follow this link for code and explanation..........

http://davidhayden.com/blog/dave/archive/2006/03/08/2877.aspx

Thanks,

Avinish Awasthi