01.private void btn_show_Click(object sender, EventArgs e)
02. {
03. dataGridView1.Rows.Clear();
04. connect.ConnectionString = Tool.getStringDB(set.dbname, set.versionaccess);
05. connect.Open();
06.
07.
08. cmd.Connection = connect;
09. cmd.CommandText = "SELECT * From InvoiceInformation WHERE Order_date between @startdate and @enddate";
10. cmd.Parameters.AddWithValue("startdate", startdate.Value.ToShortDateString());
11. cmd.Parameters.AddWithValue("enddate", enddate.Value.ToShortDateString());
12.
13. OleDbDataReader reader = cmd.ExecuteReader();
14.
15. while (reader.Read())
16. {
17. dataGridView1.Rows.Add();
18.
19. dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Invoice_no"].Value = reader[0].ToString();
20. dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Purchase_ProductID"].Value = reader[1].ToString();
21. dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Purchase_ProductName"].Value = reader[2].ToString();
22. dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Purchase_Amout"].Value = reader[3].ToString();
23. dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Purchase_TotalPay"].Value = reader[4].ToString();
24. dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Order_date"].Value = reader[5].ToString();
25. dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Customer_name"].Value = reader[6].ToString();
26. dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells["Address"].Value = reader[7].ToString();
27. }
28. connect.Close();
29. }
