title: Conversion failed when converting date and/or time from character string SQL in c#
body: <p>I get this error when I compare to dates. </p>
  
  <p>sql query command : 
  <code>Select * from processTBL WHERE is=2016144 and date between '10/06/2016' and '15/06/2016'</code> 
  that command work but when Fill Data to <code>DateTabe</code> I get converting error.</p>
  
  <p>That's my c# method;</p>
  
  <pre><code>public DataGridView hesapOzeti(string command)
      {
          DataGridView gdview = new DataGridView();
  
          if (connection.State == ConnectionState.Closed)
              connection.Open();
          SqlCommand komut = new SqlCommand(command, connection);
          SqlDataAdapter da = new SqlDataAdapter(komut);
          DataTable dt = new DataTable();
          da.Fill(dt);
          connection.Close();
          gdview.DataSource = dt;
          return gdview;
      }
  </code></pre>
  
  <p><strong>The Error:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/23Qiu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/23Qiu.png" alt="enter image description here"></a></p>