Ejemplo n.º 1
0
        private void Cb_Date_SelectedIndexChanged(object sender, EventArgs e)
        {
            string AllHistory = "All History";

            AllHistory = cb_Date.ToString();

            if (cb_Date.SelectedItem.ToString() == "All History")
            {
                HistoryLogs hl = new HistoryLogs();
                this.Close();
                hl.Show();
            }
            else
            {
                string     hisdate = "SELECT Entryno,UserID,Task,Time FROM tbl_History WHERE Date = '" + cb_Date.SelectedItem.ToString() + "' ORDER BY Entryno";
                SqlCommand hdtcmd  = new SqlCommand(hisdate, con);
                hdtcmd.ExecuteNonQuery();

                DataTable      dtdate = new DataTable();
                SqlDataAdapter sdate  = new SqlDataAdapter(hdtcmd);
                sdate.Fill(dtdate);

                foreach (DataRow dr in dtdate.Rows)
                {
                    dg_HLogs.DataSource = dtdate;
                }
            }
        }
Ejemplo n.º 2
0
        private void Button_History_Click(object sender, EventArgs e)
        {
            HistoryLogs hl = new HistoryLogs();

            hl.Show();
        }