Convert from String to Int through datatable.select()

[NBartomeli]

I am trying to convert a value in a datatable, which is a string and has to remain that way, to an integer or double value so I can perform a SUM operation on it.

I have tried the following:

objRow.Item("Total") = objDataReport.Tables("ColL2").Select("Sum(Convert(ColValue,'System.Int32'))")

ColValue is System.String

Any suggestions would be helpfull.

 

[ThatRickGuy]

I'm going to say that it will depend heavily on what type of database you are using.

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.

 

[NBartomeli]

SQL Server is the backend that the all of the tables in the dataset are filled from.

I created the table myself, and the type of that column is System.String

 

[ThatRickGuy]

I bet the guys on the SQL Server programming forum would be able to tell ya straight away.

http://www.tek-tips.com/threadminder.cfm?pid=183

-Rick

----------------------

http://www.ringdev.com

I believe in killer coding ninja monkeys.