//Date selected method private void dateSelected(DateTime selectedDate) { BackgroundImage = null; bool containsBDay = false; lastSelectedDate = selectedDate; sqlCmd = new SqlCommand("select event_id, event_subject as 'Event Subject', event_begin as 'Event Begin',event_end as 'Event End', event_cat as 'Event Category' from event where event_begin>='" + selectedDate.ToString("M/dd/yyyy 00:00:00") + "' AND event_begin<='" + selectedDate.ToString("M/dd/yyyy 23:59:59") + "'", sc); sqlAdapter = new SqlDataAdapter(); sqlAdapter.SelectCommand = sqlCmd; DataTable dt = new DataTable(); sqlAdapter.Fill(dt); if (dt.Rows.Count > 0) { for (int lpCtr = 0; lpCtr < dt.Rows.Count; lpCtr++) { if (dt.Rows[0].ItemArray.GetValue(dt.Columns.IndexOf("Event Category")).Equals("Birthday")) { containsBDay = true; } } if (containsBDay) { if (hb.IsDisposed) { hb = new HappyBirthday(); } hb.Show(); containsBDay = false; } } bs = new BindingSource(); bs.DataSource = dt; eventGrid.DataSource = bs; eventGrid.Columns[0].Visible = false; sqlAdapter.Dispose(); }
public txtCalendarBox() { InitializeComponent(); // Initialize HappyBirthday screen hb = new HappyBirthday(); string dbPath = Application.StartupPath + "\\event_db.mdf"; sc = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=" + dbPath + ";Integrated Security=True;User Instance=True"); sc.Close(); sc.Open(); // Add event handlers for the DateSelected and DateChanged events monthCalendar.DateSelected += new DateRangeEventHandler(monthCalendar_DateSelected); monthCalendar.SetDate(System.DateTime.Now); boldEventDays(); dateSelected(System.DateTime.Now); timer1.Start(); }
//Date selected method private void dateSelected(DateTime selectedDate) { BackgroundImage = null; bool containsBDay = false; lastSelectedDate = selectedDate; sqlCmd = new SqlCommand("select event_id, event_subject as 'Event Subject', event_begin as 'Event Begin',event_end as 'Event End', event_cat as 'Event Category' from event where event_begin>='" + selectedDate.ToString("M/dd/yyyy 00:00:00") + "' AND event_begin<='" + selectedDate.ToString("M/dd/yyyy 23:59:59") + "'", sc); sqlAdapter = new SqlDataAdapter(); sqlAdapter.SelectCommand = sqlCmd; DataTable dt = new DataTable(); sqlAdapter.Fill(dt); if (dt.Rows.Count > 0) { for (int lpCtr = 0; lpCtr < dt.Rows.Count; lpCtr++) { if (dt.Rows[0].ItemArray.GetValue(dt.Columns.IndexOf("Event Category")).Equals("Birthday")) containsBDay = true; } if (containsBDay) { if (hb.IsDisposed) hb = new HappyBirthday(); hb.Show(); containsBDay = false; } } bs = new BindingSource(); bs.DataSource = dt; eventGrid.DataSource = bs; eventGrid.Columns[0].Visible = false; sqlAdapter.Dispose(); }