private void loadCotactFromDatabase() { using (SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\Users\Roba\Documents\Visual Studio 2013\Projects\Todo+duomb\WindowsFormsApplication6\Database.mdf;Integrated Security=True")) { con.Open(); using (SqlCommand command = new SqlCommand("SELECT * FROM contact", con)) { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { int id = reader.GetInt32(0); string name = reader.GetString(1); string surname = reader.GetString(2); string phone = reader.GetString(3); string address = reader.GetString(4); ContactItem contact = new ContactItem(id, name, surname, phone, address); list2.AddLast(contact); } } } refreshContact(); }
private void loadContactFile() { XmlDocument doc = new XmlDocument(); if (new FileInfo("contact.xml").Length < 10) { return; } doc.Load("contact.xml"); XmlNodeList elemList = doc.GetElementsByTagName("Contact"); list2.Clear(); foreach (XmlNode element in elemList) { string number = element["Number"].InnerText; string name = element["Name"].InnerText; string surname = element["Surname"].InnerText; string phone = element["Phone"].InnerText; string address = element["Address"].InnerText; int num = Convert.ToInt32(number); ContactItem contact = new ContactItem(num ,name, surname, phone, address); list2.AddLast(contact); } refreshContactsView(); doc.Save("contact.xml"); }
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(); }
public Form3(ContactItem item) { InitializeComponent(); this.item = item; Edit(); }