Advertise with us

Restrict number of decimals to be displayed from DB

Posted by  Jeet Verma
 1210  View(s)
Rate this:

I am fetching some values from my DB.

The columns are of float type and are being displaced in DataList in the following manner.

    <td style="width:200px;text-align:left"> Item1: <%#Eval("Item1")%>  |  Item2: <%#Eval("Item2") %></td>

I have to restrict the number of decimal values being displayed int he data list to 3.

How can I do that here?

In the code-behind, the data is being fetched into the DataTable as follows.

SqlDataAdapter adp = new SqlDataAdapter("Retrieve",ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
             DataSet ds = new DataSet();
             adp.SelectCommand.CommandType= CommandType.StoredProcedure;
             adp.SelectCommand.Parameters.Add("@s1", SqlDbType.NVarChar,255).Value = strategies;
             adp.SelectCommand.Parameters.Add("@s2", SqlDbType.NVarChar,255).Value = DropDownList1.SelectedItem.ToString();
             DataList1.DataSource = ds;
  1. Re: Restrict number of decimals to be displayed from DB

    HI jeet, 

    try this:

    Eval("Item1", {0:#0.000})