snailpace

one column value which is an integer. but the text value is string,

Just use Integer.Parse or Convert.ToInt32(……) to deal with the problem。

I still don't know what you really want，so please answer my questions below to make it clear：

1）What do you want to do？

2）What have you done？

3）What's the expected result？

4）What's the actual result？

Reguards！