Hi,
I have a datatable which i need to order numerically.
However, even though the column contains numeric data, it is a string datatype.
Can i use a convert() in the order parameter? Ive tried the below code but it didnt work.
Any other ideas?
Thanks,
Rich
I have a datatable which i need to order numerically.
However, even though the column contains numeric data, it is a string datatype.
Can i use a convert() in the order parameter? Ive tried the below code but it didnt work.
Code:
drChildMenus = dtMenus.Select("Menu = 1", "convert(int,OrderCol)")
Any other ideas?
Thanks,
Rich