private void button2_Click(object sender, EventArgs e)
{
try
{
System.DateTime sdate = default(System.DateTime);
sdate = dateTimePicker1.Value;
System.DateTime rdate = default(System.DateTime);
rdate = dateTimePicker2.Value;
var AllRecordQuery = string.Format("Select * from dbo.TAKEORDER inner join dbo.ORDEREDPRODUCTS on dbo.ORDEREDPRODUCTS.ORDERID= dbo.TAKEORDER.ORDERID where ORDERDATE >= ('{0}') and ORDERDATE <=('{1}')", sdate, rdate);
dataGridView2.DataSource = EventMangementSystemClass.ReturnTable(AllRecordQuery);
dataGridView2.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}