C#窗体通讯录系统的示例代码

第C#窗体通讯录系统的示例代码目录1.首先创建DBhelp类用来连接数据库2.创建主页面：3.添加联系人页面4.修改页面5.查询页面本文主要介绍了C#窗体通讯录系统的示例代码，分享给大家，具体如下：

1.首先创建DBhelp类用来连接数据库

代码如下：

usingSystem;

usingSystem.Collections.Generic;

usingSystem.Linq;

usingSystem.Text;

usingSystem.Data.SqlClient;

usingSystem.Data;

namespaceTongxunLu

publicstaticclassDBHelp

staticstringsqlcon="DataSource=.;InitialCatalog=TXL;IntegratedSecurity=True";

publicstaticSqlConnectioncon=newSystem.Data.SqlClient.SqlConnection(sqlcon);

publicstaticSqlCommandcmd=newSqlCommand();

}

登录页面：

双加登录里面代码：

privatevoidbtnOK_Click(objectsender,EventArgse)

//验证用户名与密码非空

if(txtUserName.Text=="")

MessageBox.Show("用户名不能为空，请输入！");

txtUserName.Focus();

return;

if(txtUserPwd.Text=="")

MessageBox.Show("密码不能为空，请输入！");

txtUserPwd.Focus();

return;

//定义链接字符串和链接对象

stringsqlcon="DataSource=.;InitialCatalog=TXL;IntegratedSecurity=True";

SqlConnectioncon=newSystem.Data.SqlClient.SqlConnection(sqlcon);

//操作数据库，实现登录功能

con.Open();

stringsqlcomm="selectdistinctCOUNT(*)fromUserswhereUserName='"+txtUserName.Text+"'andPassword='"+txtUserPwd.Text+"'";

SqlCommandcmd=newSystem.Data.SqlClient.SqlCommand(sqlcomm,con);

//cmd.Connection=con;

//cmd.CommandText=sqlcomm;

if((int)cmd.ExecuteScalar()==1)

//MessageBox.Show("登录成功");

Users.UserName=txtUserName.Text;

FrmMainfmain=newFrmMain();

fmain.Show();

else

MessageBox.Show("登录失败");

//MessageBox.Show("数据库打开成功","提示信息",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);

catch(Exceptionex)

MessageBox.Show(ex.Message,"提示信息",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);

finally

con.Close();

//MessageBox.Show("数据库成功关闭","提示信息",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);

}

双击取消，里面代码：

privatevoidbtnCacel_Click(objectsender,EventArgse)

Application.Exit();

}

输入用户表里面的信息，进行登录：

2.创建主页面：

添加菜单栏、工具栏、状态栏

菜单栏控件：MenuStrip以mus开头命名

项目名称以tsm开头项目里的项目以tsmi开头命名

工具栏控件：ToolStrip项显示图片和文本更改属性DisplayStyle，工具栏：以tst开头

状态栏控件：StatusStrip，状态栏：以tss命名开头

当页面加载那个用户登录，状态用Label控件就显示谁的名字，代码：

privatevoidFrmMain_Load(objectsender,EventArgse)

//接受登录名

toolStripStatusLabel2.Text+=Users.UserName;

toolStripStatusLabel3.Text+=GetNum(Users.UserName).ToString();

LoadGroup();

}

主页面里面的详细功能代码，如下：

usingSystem;

usingSystem.Collections.Generic;

usingSystem.ComponentModel;

usingSystem.Data;

usingSystem.Drawing;

usingSystem.Linq;

usingSystem.Text;

usingSystem.Windows.Forms;

usingSystem.Data.SqlClient;

namespaceTongxunLu

publicpartialclassFrmMain:Form

publicFrmMain()

InitializeComponent();

//显示添加窗体

publicvoidadd()

frmAddfadd=newfrmAdd();

fadd.Show();

//显示修改窗体

publicvoidedit()

frmEditfedit=newfrmEdit();

fedit.Show();

//显示查询窗体

publicvoidseacher()

frmSeachfseacher=newfrmSeach();

fseacher.Show();

//统计登录联系人的个数

publicintGetNum(stringstr1)

intnum=0;

DBHelp.con.Open();

stringsqlcomm=string.Format("selectcount(*)fromBUsicInfowhereUserName='{0}'",str1);

DBHelp.cmd.Connection=DBHelp.con;

DBHelp.cmd.CommandText=sqlcomm;

num=(int)DBHelp.cmd.ExecuteScalar();

catch(Exceptionex)

MessageBox.Show(ex.Message);

finally

DBHelp.con.Close();

returnnum;

//统计登录联系人分组的个数

publicintGetGroupsNum()

intnum=0;

DBHelp.con.Open();

stringsqlcomm=string.Format("selectcount(*)fromBUsicInfowhereUserName='{0}'andgroups='{1}'",Users.UserName,treeView1.SelectedNode.Text);

DBHelp.cmd.Connection=DBHelp.con;

DBHelp.cmd.CommandText=sqlcomm;

num=(int)DBHelp.cmd.ExecuteScalar();

catch(Exceptionex)

MessageBox.Show(ex.Message);

finally

DBHelp.con.Close();

returnnum;

//加载treeview控件

publicvoidLoadGroup()

DBHelp.con.Open();

stringsqlcomm=string.Format("selectgroupsfrombusicInfowhereuserName='{0}'",Users.UserName);

DBHelp.cmd.Connection=DBHelp.con;

DBHelp.cmd.CommandText=sqlcomm;

SqlDataReaderdr=DBHelp.cmd.ExecuteReader();

while(dr.Read())

treeView1.Nodes.Add(dr[0].ToString());

dr.Close();

catch(Exceptionex)

MessageBox.Show(ex.Message);

finally

DBHelp.con.Close();

//加载ListView控件

publicvoidloadList()

if(treeView1.Nodes.Count==0)

MessageBox.Show("请重新加载");

listView1.Items.Clear();

return;

if(treeView1.SelectedNode.Index=0)

listView1.Clear();

listView1.Columns.Add("姓名",100);

listView1.Columns.Add("工作单位",100);

listView1.Columns.Add("联系电话",100);

listView1.Columns.Add("电子邮箱",100);

listView1.Columns.Add("QQ",100);

DBHelp.con.Open();

stringsqlcomm=string.Format("select*frombusicInfowhereuserName='{0}'andGroups='{1}'",Users.UserName,treeView1.SelectedNode.Text);

DBHelp.cmd.CommandText=sqlcomm;

DBHelp.cmd.Connection=DBHelp.con;

SqlDataReaderdr=DBHelp.cmd.ExecuteReader();

while(dr.Read())

ListViewItemlvi=newListViewItem();

lvi.Tag=dr[0];

lvi.Text=dr[3].ToString();

lvi.SubItems.Add(dr[4].ToString());

lvi.SubItems.Add(dr[5].ToString());

lvi.SubItems.Add(dr[6].ToString());

lvi.SubItems.Add(dr[7].ToString());

listView1.Items.Add(lvi);

dr.Close();

catch(Exceptionex)

MessageBox.Show(ex.Message);

finally

DBHelp.con.Close();

privatevoid增加联系人ToolStripMenuItem_Click(objectsender,EventArgse)

add();

privatevoidtoolStripButton1_Click(objectsender,EventArgse)

add();

privatevoidtoolStripButton4_Click(objectsender,EventArgse)

seacher();

privatevoidFrmMain_Load(objectsender,EventArgse)

//接受登录名

toolStripStatusLabel2.Text+=Users.UserName;

toolStripStatusLabel3.Text+=GetNum(Users.UserName).ToString();

LoadGroup();

privatevoidmenuStrip1_ItemClicked(objectsender,ToolStripItemClickedEventArgse)

privatevoidtreeView1_AfterSelect(objectsender,TreeViewEventArgse)

loadList();

toolStripStatusLabel3.Text=GetGroupsNum().ToString();

}

3.添加联系人页面

Tablcontrol控件：分页选项:用来分页：基本信息和其他信息

双击确定，里面代码：

privatevoidbtnAdd_Click(objectsender,EventArgse)

DBHelp.con.Open();

DBHelp.cmd.CommandText=string.Format("insertintoBusicInfo(userName,Groups,Name,workUnit,Phone,Email,QQ)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')",Users.UserName,cmbGroup.SelectedValue,txtName.Text,txtWorkUnit.Text,txtPhone.Text,txtEmail.Text,txtQQ.Text);

DBHelp.cmd.Connection=DBHelp.con;

if((int)DBHelp.cmd.ExecuteNonQuery()==1)

MessageBox.Show("添加成功");

else

MessageBox.Show("失败");

catch(Exceptionex)

MessageBox.Show(ex.Message);

finally

DBHelp.con.Close();

}

加载页面，双击压面，里面代码

publicvoidLoadGroup()

DBHelp.con.Open();

stringsqlcomm=string.Format("selectgroupsfrombusicInfowhereuserName='{0}'",Users.UserName);

DBHelp.cmd.Connection=DBHelp.con;

DBHelp.cmd.CommandText=sqlcomm;

SqlDataReaderdr=DBHelp.cmd.ExecuteReader();

while(dr.Read())

cmbGroup.Items.Add(dr[0].ToString());

dr.Close();

catch(Exceptionex)

MessageBox.Show(ex.Message);

finally

DBHelp.con.Close();

privatevoidfrmAdd_Load(objectsender,EventArgse)

LoadGroup();

}

4.修改页面

5.查询页面

双击查询按钮，里面代码：

privatevoidbtnSeach_Click(objectsender,Event