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();
}
