usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;usingSystem.Configuration;namespacePhoneBook{publicpartialclassfrmMain:Form{publicfrmMain(){InitializeComponent();}privatestringstrConn=System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];privatevoidfrmMain_Load(objectsender,EventArgse){LoadGroup();if(trvGroup.Nodes.Count>0){trvGroup.SelectedNode=trvGroup.Nodes[0];LoadList();}else{lvContact.Clear();}}privatevoidLoadGroup(){try{trvGroup.Nodes.Clear();SqlConnectionconn=newSqlConnection(strConn);SqlCommandcmd=newSqlCommand();cmd.Connection=conn;cmd.CommandText="selectdistinct组别from联系人where用户名='"+tsslUserName.Text+"'";conn.Open();SqlDataReadersdr=cmd.ExecuteReader();while(sdr.Read()){trvGroup.Nodes.Add(sdr[0].ToString());}sdr.Close();conn.Close();}catch{}}privatevoidLoadList(){if(trvGroup.Nodes.Count==0){lvContact.Clear();return;}if(trvGroup.SelectedNode.Index>=0){stringstrGroup=trvGroup.SelectedNode.Text;try{lvContact.Clear();lvContact.Columns.Add("姓名",100);lvContact.Columns.Add("工作
2023/12/9 9:50:34
1.54MB
C#
管理系统
1