I have a database field called Rate it contains decimal values eg 0.1020, 0.1000. When I like this to my datagrid and load the datagrid the column containing the Rate has 0.0000, 0.0000 and not the values in the database.

How can i get these values in my datagrid.
Note: All other data from the database - table are correct and exact in my datagrid except the decimal values i have mentioned above.

You may want to use the FormatNumber method in this manner:
FormatNumber(X,1)
where 1, contributes to the number of digits after the comma.

You can use round function in sql query.

like round(rate,2)

try this
let's know is it working or not.


With thanks
rajesh,
India