ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 All rights reserved.Windows Form Error: Invalid Cloumn Name Date in C#<blockquote><cite>Kirron says:</cite> <div class="line number12 index11 alt1"><code class="csharp keyword">string</code> <code class="csharp plain">query = </code><code class="csharp string">" Select Bill_No , Name, Address, MobileNo,Sl_No,ItemName,Size,Quantity,Rate,Amount,Total_Amount,Payment,Balance,Date"</code> <code class="csharp plain">+ </code></div> <div class="line number13 index12 alt2"><code class="csharp spaces">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><code class="csharp string">"from SALES"</code> <code class="csharp plain">+ $</code><code class="csharp string">" where Date between '{dtFromDate.Value}'&nbsp; and '{ dtToDate.Value}'"</code><code class="csharp plain">;</code></div> </blockquote> <p>Try by below code also check the query string object value by debugging also be sure your table name SALES have date as a column in table. </p> <pre class="brush: csharp">string query = &#34; Select Bill_No , Name, Address, MobileNo,Sl_No,ItemName,Size,Quantity,Rate,Amount,Total_Amount,Payment,Balance,Date&#34; + &#34;from SALES&#34; + &#34; where Date between &#39;&#34;+dtFromDate.Value+ &#34;&#39; and &#39;&#34;+ dtToDate.Value+&#34;&#39;&#34;; </pre> <p>&nbsp;</p>, 27 Apr 2018 06:43:38 GMTWindows Form Error: Invalid Cloumn Name Date in C#<p>Dear Kalpesh Thank you for your time.</p> <p>&nbsp;</p> <p>I have fixed this error by simpling changing datetime picker property to short.</p>, 28 Apr 2018 01:11:48 GMT