C#窗體通訊錄系統(tǒng)的示例代碼

第C#窗體通訊錄系統(tǒng)的示例代碼目錄1.首先創(chuàng)建DBhelp類用來連接數(shù)據(jù)庫2.創(chuàng)建主頁面：3.添加聯(lián)系人頁面4.修改頁面5.查詢頁面本文主要介紹了C#窗體通訊錄系統(tǒng)的示例代碼，分享給大家，具體如下：

1.首先創(chuàng)建DBhelp類用來連接數(shù)據(jù)庫

代碼如下：

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)

//驗(yàn)證用戶名與密碼非空

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

//操作數(shù)據(jù)庫，實(shí)現(xiàn)登錄功能

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("數(shù)據(jù)庫打開成功","提示信息",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);

catch(Exceptionex)

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

finally

con.Close();

//MessageBox.Show("數(shù)據(jù)庫成功關(guān)閉","提示信息",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);

}

雙擊取消，里面代碼：

privatevoidbtnCacel_Click(objectsender,EventArgse)

Application.Exit();

}

輸入用戶表里面的信息，進(jìn)行登錄：

2.創(chuàng)建主頁面：

添加菜單欄、工具欄、狀態(tài)欄

菜單欄控件：MenuStrip以mus開頭命名

項(xiàng)目名稱以tsm開頭項(xiàng)目里的項(xiàng)目以tsmi開頭命名

工具欄控件：ToolStrip項(xiàng)顯示圖片和文本更改屬性DisplayStyle，工具欄：以tst開頭

狀態(tài)欄控件：StatusStrip，狀態(tài)欄：以tss命名開頭

當(dāng)頁面加載那個用戶登錄，狀態(tài)用Label控件就顯示誰的名字，代碼：

privatevoidFrmMain_Load(objectsender,EventArgse)

//接受登錄名

toolStripStatusLabel2.Text+=Users.UserName;

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

LoadGroup();

}

主頁面里面的詳細(xì)功能代碼，如下：

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

//統(tǒng)計登錄聯(lián)系人的個數(shù)

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;

//統(tǒng)計登錄聯(lián)系人分組的個數(shù)

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("聯(lián)系電話",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增加聯(lián)系人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.添加聯(lián)系人頁面

Tablcontrol控件：分頁選項(xiàng):用來分頁：基本信息和其他信息

雙擊確定，里面代碼：

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