title: Change one column's value during a select - Linq to Sql
body: <p>I am new in Linq.
  I have following query:</p>
  
  <pre><code>var BeachDetail = (from Personal in dc.t_return_to_beaches
                     where Personal.emo_number == EmoNumber
                     select Personal).ToList();
  
   Grd_ReturnToBeach.ItemsSource = CurrentController.GetItemSource(BeachDetail)
  </code></pre>
  
  <p>Here i am using DevExpress Grid to bind.</p>
  
  <pre><code>&lt;dxg:GridControl x:Name="Grd_ReturnToBeach" MinHeight="70"&gt;
  &lt;/dxg:GridControl&gt;
  </code></pre>
  
  <p>which retrieves more than 16 columns.</p>
  
  <p>It works fine for me but there are two columns named</p>
  
  <pre><code>  weight (numeric(15, 4))
  </code></pre>
  
  <p>and</p>
  
  <pre><code>   value (numeric(15, 4))
  </code></pre>
  
  <p><strong>Problem :</strong></p>
  
  <p>if I enter 12 and 13.45 in these columns then i got 12.0000 and 13.4500.But i want to show in the grid exact value which i entered earlier like 12 and 13.45. </p>