title: Database Data Types and their equivelants in Windows Forms
body: <p>I've read in forums about people having issues with certain data types when accessing a database from their website <em>and</em> windows forms application. Mostly the <code>decimal</code>, <code>float</code> and <code>datetime</code> data types.</p>
  
  <p>My DB Table, for example, the Orders table consists of the following Columns. Below each column is the datatype I have chosen to use:</p>
  
  <pre><code>UserId     OrderId     OrderDate     InvoiceTotal      PaymentStatus     DeliveryStatus
  int        int         datetime      money             bit               bit
  </code></pre>
  
  <p>My questions are:</p>
  
  <ol>
  <li><p>Is (in Windows Forms) <code>DateTime.Now()</code> equivelant to <code>datetime</code> (in WebMatrix DB)? If not, why not? And which method would be best to work with the <code>datetime</code> datatype used in WebMatrix DB?</p></li>
  <li><p><code>money</code> Data Type: As far as I know, there is no "money" data type in Windows Forms. You can only use <code>Decimal</code> (which makes sense), but I've heard of people also using <code>Float</code>? So, which data type should I use in WinForms so that it just works properly with the <code>money</code> datatype in the DB, and how?</p></li>
  </ol>
  
  <p>I'm asking these questions because in the past I've always had precision problems. Sometimes even inaccuracy problems. I've read the docs. Tutorials. Articles, etc. But I feel like I'm missing something...</p>