batch updates to the database thru dataset
Posted on 2006-04-06
My requirement is I am fetching around 4000 records from the database table into dataset in a ASP.net application( lang:vb.net), I want to iterate thru each record do some validations checks (manipulate the data) and update the data back(using stored proc) to the same table. Please suggest me a better way of doing this .
Can this be done using dataset batch update method, if so how ?
Otherwise what is the better approah.