Hi friends,

I am working on a windows application that resides on Production application server. The purpose is to update the "Production Database"
with the data that is available in the datatable.

I have the following structure of the datatable :-

COLUMN-A COLUMN-B COLUMN-C COLUMN-D COLUMN-E
1 4345 10 20 30
2 4231 39 43 27
3 54 443 55
4 4333 32 23 12

(--> The forums is not representing the columns in a nice way, excuse me
for this but its like col A,B,C,D,E and Column C,D,E values will be updated
on production database. All these 3 column belongs to same data field
in the database table.)

I have to update the Column-C,D and E values in the Production
database( single database table) against the values of COLUMN-A AND B.

Column-C,D and E represents the same column in the database table.

So this is sure I will be sending as in param for a stored procedure
as an array params.

But this can be possible for one record at a time.

I dont want to hit the database again and again in a loop for
updating all the rows.

What could be the better approach to achieve the result in one go.

Please reply.

Thanks.