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........

Sam Hobbs · Answer

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

Suthish Nair · Answer

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

Felipe Ramos · Answer

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

Soumya Surendran · Answer

thats not possible in my case

Vulpes · Answer

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