public void loadTopSeller()
{
try
{
dataTopSelling.Rows.Clear();
int i = 0;
using (MySqlDataReader reader = pos.loadTopSales(dateTimePicker1.Value.ToString("yyyy-MM-dd"), dateTimePicker2.Value.ToString("yyyy-MM-dd"), topSalesSorting.Text))
{
while (reader.Read())
{
i++;
dataTopSelling.Rows.Add(i, reader["transaction_id"].ToString(),
reader["products_id"].ToString(),
reader["description"].ToString(),
reader["quantity"].ToString(),
reader["total"].ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
