// save to dataBase private void btnAddReminder_Click(object sender, RoutedEventArgs e) { NewReminderWindow newReminder = new NewReminderWindow(); if (newReminder.ShowDialog() == true) { // insert new reminder into table Reminder r = newReminder.newReminder; string command = @"insert into Reminders(Name,LongDescription,DueDate) Values(" + @"'" + r.ShortDes + @"','" + r.LongDes + @"','" + r.DueDate + @"')"; try { using (SqlConnection con = new SqlConnection(connectionDB)) { SqlCommand cmd = new SqlCommand(command, con); SqlDataAdapter sda = new SqlDataAdapter(cmd); con.Open(); cmd.ExecuteNonQuery(); con.Close(); listShortDescription.Items.Clear(); PopulateListView(); listShortDescription.Items.Refresh(); } }catch (Exception ex) { MessageBox.Show(ex.Message); } } }
//private void btnUpdate_Click(object sender, RoutedEventArgs e) //{ // PopupNotifier notifiy = new PopupNotifier(); // notifiy.TitleText = listShortDescription.SelectedItem.ToString(); // notifiy.Popup(); //} private void btnUpdate_Click_1(object sender, RoutedEventArgs e) { string getLong = listShortDescription.SelectedItem.ToString(); string command = @"select * from Reminders where Name = '" + getLong + "' "; DataSet sd = new DataSet(); using (SqlConnection con = new SqlConnection(connectionDB)) { SqlCommand cmd = new SqlCommand(command, con); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(sd, "short"); Reminder r = new Reminder(); foreach (DataRow data in sd.Tables["short"].Rows) { r.ShortDes = data["Name"].ToString(); r.LongDes = data["LongDescription"].ToString(); r.DueDate = DateTime.Parse(data["DueDate"].ToString()); } NewReminderWindow ModifiedReminder = new NewReminderWindow(r); ModifiedReminder.ShowDialog(); //if (ModifiedReminder.ShowDialog().Value) //{ //} } }