title: How can I use 2 decimals using money in ASP.NET web forms?
body: <p>I know, there are a few answers here, but neither of them works. </p>
  
  <p>So here is the scenario:</p>
  
  <p>Got a GridView and in one of these columns, a price is declared. In the SQL Database, I use <code>money</code> to declare the price. The GridView will import the data from the database programmatically
   Code here:</p>
  
  <pre><code>        var con = new SqlConnection();
          var cmd = new SqlCommand();
          var dt = new DataTable();
          con.ConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\hugow\Documents\Visual Studio 2015\Projects\OSGS_v2\dataBase.mdf;Integrated Security=True;Connect Timeout=30";
          cmd.Connection = con;
          string cmdText = null;
          string usrName = Request.Cookies["usrData"]["usrName"];
          cmdText = "SELECT orderID, Products, orderPrice, date FROM orderData WHERE orderUser=@usr";
          cmd.Parameters.Add("@usr", SqlDbType.VarChar).Value = usrName;
          con.Open();
          cmd.CommandText = cmdText;
          var da = new SqlDataAdapter(cmd);
          da.Fill(dt);
          stdT.DataSource = dt;
          stdT.DataBind();
          con.Close();
          con.Dispose();
  </code></pre>
  
  <p>And I want to show the price as a two decimal price (0,00). The problem is: It shows 4 decimals (0,0000). </p>
  
  <p>2 Questions: </p>
  
  <ol>
  <li>How to show 2 decimals instead of 4?</li>
  <li>Why does <code>money</code> have 4 decimals instead of 2?</li>
  </ol>
  
  <p>I use Web Forms, not MVC.</p>
  
  <p>Thanks in advance!</p>