Пример #1
0
        private void guna2Button1_Click(object sender, EventArgs e)
        {
            string date1 = dateOne.ToString();
            string date2 = dateTwo.ToString();

            try
            {
                DBconnection connection5 = new DBconnection();

                DataTable      dt = new DataTable();
                SqlDataAdapter da = new SqlDataAdapter(connection5.displayReportBetweentwodays(date1, date2));
                da.Fill(dt);
                dataGrid.DataSource = dt;
                connection5.getConnection().Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Error in Displaying Reports:\n" + ex, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
                Console.WriteLine("Error: \n" + ex);
            }
        }