how to muliply a column of a datatable with a value without looping..

Question

hai..expert....

I have a datatable with more than 5000 rows. I want to muliply first column's value with 100. for this i hav used foreach loop. But it taks long time. Do we have any other option to multiply ???

thanks in advance........

Answer 1

If it cannot be done in the select statement as Vulpes suggests then there is something you are not telling us.

Answer 2

If SELECT statement will not help you, might LINQ to DataTable will.

Answer 3

Createa view of the table were you have a column that is your (First*100) [CompountColumn].

Answer 4

thats not possible in my case

Answer 5

You could multiply that particular column by 100 in your SELECT command when you retrieve the rows from the database.