private void AddButton_Click(object sender, EventArgs e) { //MessageBox.Show(CategoryMenu.Text); if (checkInput()) { // create a new BudgetItem BudgetItem newItem = new BudgetItem (Convert.ToDateTime(dateTimePicker1.Text), CategoryMenu.Text, DescriptionTextBox.Text, float.Parse(AmountTextBox.Text)); // add item to DB int ukey = Properties.Settings.Default.userkey; string command = "insert into nts_budget_items(`userkey`, `date`, `name`, `amount`, `catkey`) values(" + ukey + ", " + dateTimePicker1.Value.ToString("yyyyMMdd") + ",\"" + DescriptionTextBox.Text + "\"," + AmountTextBox.Text + ", " + CategoryMenu.SelectedValue + ");"; sqlConn.Open(); SQLiteDataReader reader; sqlDoReport.CommandText = command; reader = sqlDoReport.ExecuteReader(); sqlConn.Close(); // alert user that item was successfully added to DB - this needs an if statement! if (reader.RecordsAffected > 0) { SuccessTextBox.Text = "Item successfully added to your budget!"; } else { SuccessTextBox.Text = "There has been an error in adding your item."; } // reset window dateTimePicker1.ResetText(); CategoryMenu.ResetText(); DescriptionTextBox.ResetText(); AmountTextBox.ResetText(); CategoryMenu.ClearSelected(); } }