data between two dates in texbox:error in code
<p><strong>date textbox to textbox</strong>
when in write date in text box the corrs data between <strong><em>two dates come in data grid</em></strong>
*<em>my code is:</em>*</p>

<pre><code>    private void btnSubmit_Click(object sender, EventArgs e)
    {
        SqlConnection cs = new SqlConnection("Data Source=IRIS-CSG-174;Initial Catalog=library_system;Integrated Security=True");
        cs.Open();
        SqlCommand cmd = new SqlCommand("select * from dbo.lib_issue_details where book_issue_on between=" + textBox1.Text+""+"and"+ textBox2.Text +"", cs);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        DataSet ds = new DataSet();
        da.Fill(ds, "lib_issue_details");
        dataGridView1.DataBindings.Add(new Binding("text", ds, "lib_issue_details.book_issue_on"));
</code></pre>

<p>It shows error that Incorrect syntax near '='.
help me in this code...thanks in advance!!!</p>
