Posted on: 9/18/2015 12:16:31 PM | Views : 887

how to convert dt.rows[0] to decimal c# ?
 decimal ValueMine;
   ValueMine= Convert.ToDecimal(dt.Rows[0]["Multir"]);

It is an Object I am filling it this way :
  SqlDataAdapter da = new SqlDataAdapter(" Select Multiplier From table where UnitId=" + e.Value, sqlConn);                         DataTable dt = new DataTable();                         da.Fill(dt);
  ValueMine= Convert.ToDecimal(dt.Rows[0]["Multir"]);

but I am getting ValueMine= 10 it should be 10.0000

Go to the complete details ...