public ModifyContacts(Contacts con) { InitializeComponent(); this.con = con; DataTable dt = new DataTable(); dt = SqlClass.Fill("select * from groups"); for (int i = 0; i < dt.Rows.Count; ++i) { comboBox1.Items.Add(dt.Rows[i]["gname"].ToString()); ls.Add(new KeyValuePair <string, string>(dt.Rows[i]["gid"].ToString(), dt.Rows[i]["gname"].ToString())); } comboBox1.Text = con.gname; dt = SqlClass.Fill("select * from contacts where id=" + con.id); textBox1.Text = dt.Rows[0]["name"].ToString(); textBox2.Text = dt.Rows[0]["num"].ToString(); }
public void FreshContacts() { DataTable dt = new DataTable(); dt = SqlClass.Fill("select * from groups"); treeView1.Nodes.Clear(); for (int i = 0; i < dt.Rows.Count; ++i) { treeView1.Nodes.Add(dt.Rows[i]["gid"].ToString(), dt.Rows[i]["gname"].ToString()); } foreach (TreeNode tn in treeView1.Nodes) { dt = SqlClass.Fill("select * from contacts where gid='" + tn.Name + "'"); for (int i = 0; i < dt.Rows.Count; ++i) { tn.Nodes.Add(dt.Rows[i]["id"].ToString(), dt.Rows[i]["name"].ToString()); } } treeView1.ExpandAll(); }