dataview sort is not working.

[irsh_is]

I want to sort the dataview based on the column AVG_VALUE which is of type double, i have written the following code, but it is not sorting. DataView dv = ds.Tables[0].DefaultView; dv.Sort = "AVG_VALUE DESC"; table structure AVG_VALUE VARIABLE_NAME 11.1 Var1 12.2 Var2 1.1 Var5 40.2 Var6 Output Required AVG_VALUE VARIABLE_NAME 40.2 Var6 12.2 Var2 11.1 Var1 1.1 Var5

[Nidhi s]

If you have Spaces in your field names or Reserved words then you have to put field name in [] to get it to work.I think it should work like this: DataView dv = ds.Tables[0].DefaultView; dv.Sort = "[AVG_VALUE]DESC";