select * from purchase_entry where pur_date>='" + Convert.ToDateTime(TextBox1.Text).ToString("MM/dd/yyyy") + "' and pur_date<='" + Convert.ToDateTime(TextBox2.Text).ToString("MM/dd/yyyy") + "' order by pur_no
select * from purchase_entry where pur_to='" + cbobranch.Text + "' and pur_date>='" + DateTime.Parse(TextBox1.Text).ToString("MM/dd/yyyy") + "' and pur_date<='" + DateTime.Parse(TextBox2.Text).ToString("MM/dd/yyyy") + "' order by pur_no
WHERE pur_date BETWEEN date1 AND date2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)