private void editContact_Click(object sender, EventArgs e) { if (listView2.SelectedItems.Count == 1) { ContactItem contact = listView2.SelectedItems[0].Tag as ContactItem; Form3 thirdForm = new Form3(contact); if (thirdForm.ShowDialog(this) == DialogResult.OK) { int id = contact.id; string name = contact.name; string surname = contact.surname; string phone = contact.phoneNumber; string address = contact.address; refreshContact(); using (SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Roba\Documents\Visual Studio 2013\Projects\Todo+duomb\WindowsFormsApplication6\Database.mdf;Integrated Security=True")) { conn.Open(); using (var command = new SqlCommand("UPDATE [contact] SET [Name]=@name, [Surname]=@surname, [PhoneNumber]=@phone, [Address]=@address WHERE Id =" + id, conn)) { command.Parameters.AddWithValue("@name", name); command.Parameters.AddWithValue("@surname", surname); command.Parameters.AddWithValue("@phone", phone); command.Parameters.AddWithValue("@address", address); command.ExecuteNonQuery(); conn.Close(); } } } } else { MessageBox.Show("Select only one"); } }
private void addContact_Click(object sender, EventArgs e) { ContactItem contact = new ContactItem(0,"","","",""); Form3 thirdForm = new Form3(contact); if (thirdForm.ShowDialog(this) == DialogResult.OK) { var item = new ListViewItem(); item.Tag = contact; item.SubItems.Add(contact.name); item.SubItems.Add(contact.surname); item.SubItems.Add(contact.phoneNumber); item.SubItems.Add(contact.address); listView2.Items.Add(item); list2.AddLast(contact); } writeContactsToDatabase(); }
private void editContact_Click(object sender, EventArgs e) { if (listView2.SelectedItems.Count == 1) { ContactItem contact = listView2.SelectedItems[0].Tag as ContactItem; Form3 thirdForm = new Form3(contact); if (thirdForm.ShowDialog(this) == DialogResult.OK) { refreshContactsView(); writeToFileContacts(); } } else { MessageBox.Show("Select one contact"); } }
private void 统计信息ToolStripMenuItem_Click(object sender, EventArgs e) { Form3 form = new Form3(); form.ShowDialog(); }