title: How to search data between two dates in asp.net from database
body: <p>I have a problem: two days ago, was I face a problem in the history of the introduction of the history of the coordination I've dissolution. But now I want to look in the two periods of time I've attached by typing the code in the image please help when press button search get all data from database</p>
  
  <p><a href="https://i.stack.imgur.com/mh44o.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <pre><code>DataTable dt = PFUCommonCLass.Common.GetDataTableModify
                       (@"SELECT * FROM Tbl_Invoice
                          WHERE Fld_Date BETWEEN " + txtStartDate.Text + "And" + txtEndDate.Text + "");
                       )
  GridView1.DataBind();
  </code></pre>