private void button1_Click(object sender, EventArgs e)
{
//businesslayer bl = new businesslayer();
//dataGridView1 = bl.profit(firstDate.Value.ToString("dd-MM-yyyy"), endDate.Value.ToString("dd-MM-yyyy"));
businesslayer bl = new businesslayer();
MySqlDataReader dr = bl.revenue(firstDate.Value.ToString("yyyy-MM-dd"), endDate.Value.ToString("yyyy-MM-dd"));
DataTable table = new DataTable();
if (dr != null)
{
table.Load(dr);
if (table != null)
{
dataGridView1.DataSource = table;
}
}
// dr.Close();
}