C#通讯录管理系统课程设计

C录管理系统课程设计-CAL-FENGHAI-(2020YEAR-YICAI)_JINGBIAN课程设计报告 名称：C#.NET程序设计设计题目：通讯录管理系统生班级：与计算机系录1。名称 。开发人员 。指导教师 。2。概述 。构思 。意。3模块分析及。系统功能结构图 。系统数据流图 。4数据库。数据库需求分析 。E-R图 。数据表。登用户信息表： 。通讯信息表 。5进度表 。6任务分配表 。7达到的效果 。序思想 。序最终实现结果： 。8重要的源序 。10。12越靠计帮助住这些情极其这就有一用用户可过自己电脑时自己用户、用户、、、这些可实现你应用求。构思 求析：用户实现同用户跟显示全部实现用户存在数据库中数据显示用户解数据存储况。找实现用户在软件数据库中找自己数据、性别、生日、电话、邮箱、地址。修改对数据库中已存在进行修改然后保存已经修改过数据。删除对数据库中已经存在进行行删除操作。研究意义通讯管理系统是个专门针对储存联系方式以及些简单个人信息管理系统它方便了对众多客、朋友、同事等个人信息储存和快速查阅功能大大减少了查找过程时间。第3 章模块分析及设计系统功能结构图通讯通讯管理系统注册登录注册用户显示全部查找修改删除退出系统主界面显示显示添查修全加找改部删 出除 系统4E-R图名密码性别操作称共2个1（Users）2联信息表：通讯信息表5~~~~~67C#、函以及函以、、、、更多方便合、操方便、稳、备具有较高价值、添加、查找、修改、删除、退出系统，点将数据库成员：中：查找按姓名查找方式输入想查找名字点查找按钮清空文本框：修改以姓名为主健进行修改相关清空输入框：。8源程序连接usingSystem;using;using;usingtong_xun_lu_guan_li{publicstaticclassDBClass{publicstaticStringstrConn"Datasource=SKQ3HEOVTLD8XZY\\SQLEXPRESS;Database通讯录管理;integratedsecuritySSPI";publicstaticSqlConnectionconn=newSqlConnection(strConn);}}登录界面：namespacetong_xun_lu_guan_li{publicpartialclassForm1:Form{publicForm1(){InitializeComponent();}privatevoidForm1_Load(objectsender,EventArgse){}privatevoidbutton1_Click(objectsender,EventArgse){Registerreg=newRegister();();();}privatevoidbutton2_Click(objectsender,EventArgse){if==""||==""){("不能为空");}else{DataSetdsMydataBase=newDataSet();SqlCommandcmd=newSqlCommand();=;="select[UsersName]from[Users]where[UsersName]='"++"'";();if(cmd.ExecuteScalar()==null){("不存在！");();();return;}else{="select[Userspwd]from[Users]where[UsersName]='"++"'";();if!=().ToString()){("错误();();}elseif==().ToString()){("登录成功！");Homeho=newHome();();();}else{();}}}}privatevoidtextBox2_TextChanged(objectsender,EventArgse){='*';}privatevoidbutton3_Click(objectsender,EventArgse){();}}}namespacetong_xun_lu_guan_li{publicpartialclassRegister:Form{publicRegister(){InitializeComponent();}privatevoidRegister_Load(objectsender,EventArgse){}privatevoidbutton1_Click(objectsender,EventArgse){try{if==""||==""){("不能为空");}else{SqlCommandcmd=newSqlCommand();=;="InsertintoUsers(UsersName,Userspwd)Values('"++"','"++"')";();成功！");DataSetdsMyDataBase=newDataSet();SqlDataAdapterdaBaseInform=newSqlDataAdapter("Select[UsersName]FromUsers",;(dsMyDataBase,"BaseInform");=();();}}catch(Exceptionex){+);}}privatevoidbutton2_Click(objectsender,EventArgse){Form1L=newForm1();();();}}}主界面：namespacetong_xun_lu_guan_li{publicpartialclassHome:Form{publicHome(){InitializeComponent();}protectedoverridevoidOnClosing(CancelEventArgse){();}privatevoidHome_Load(objectsender,EventArgse){}privatevoidbutton1_Click(objectsender,EventArgse){try{DataSetdsMyDataBase=newDataSet();SqlDataAdapterdaBaseInform=newSqlDataAdapter("Select*fromContact",;(dsMyDataBase,"BaseInform");=["BaseInform"];}catch(Exceptionex){);}}privatevoidbutton2_Click(objectsender,EventArgse){Form1L=newForm1();();();}privatevoidbutton3_Click(objectsender,EventArgse){if==""){();();();();();}elseif!=""){SqlCommandcmd=newSqlCommand();=;"InsertintoContact(,,,,,Values('"++++++++++++"')";();添加成功);DataSetdsMyDataBase=newDataSet();SqlDataAdapterdaBaseInform=newSqlDataAdapter("Select*FromContact",;(dsMyDataBase,"BaseInform");=["BaseInform"];}}privatevoidbutton4_Click(objectsender,EventArgse){();}privatevoidbutton7_Click(objectsender,EventArgse){if==""){();}elseif!=""){DataSetdsMydataBase=newDataSet();SqlCommandcmd=newSqlCommand();=;"selectfrom[Contactwhere++"'";();if()==null){("不存在！");();return;}else{"deletefromContactwhere"'";();("删除成功");DataSetdsMyDataBase=newDataSet();SqlDataAdapterdaBaseInform=newSqlDataAdapter("Select*FromContact",;(dsMyDataBase,"BaseInform");=["BaseInform"];();}}}privatevoidbutton8_Click(objectsender,EventArgse){();}privatevoidbutton9_Click(objectsender,EventArgse){if==""){("请输入要修改的！");();();();();}elseif!=""){DataSetdsMydataBase=newDataSet();SqlCommandcmd=newSqlCommand();=;"selectfrom[Contactwhere[++"'";();if()==null){("不存在！");();();();();return;}else{"updateContactset姓"性别"生日"电话"邮箱"地址++"'where姓++"'";();("修改成功！");DataSetdsMyDataBase=newDataSet();SqlDataAdapterdaBaseInform=newSqlDataAdapter("Select*FromContact",;(dsMyDataBase,"BaseInform");=();();();();}}}privatevoidbutton5_Click(objectsender,EventArgse){try{if==""){("查找的姓不能为空！");}elseif!=""){DataSetdsMydataBase=newDataSet();SqlCommandcmd=newSqlCommand();=;"select姓from[Contactwhere姓"'";();if()==null){"不存在！");();}

return;else{stringsearchString"select*fromContactwhere名"'";SqlDataAdapterdataSelect=newSqlDataAdapter(searchString,;DataTabledt=newDataTable();(dt);=;=true;();}}}catch(Exceptionex){+"打开数据库失败！");}}privatevoidbutton6_Click(objectsender,EventArgse){();}privatevoidbutton10_Click(objectsender,EventArgse){();}privatevoidbutton11_Click_1(objectsender,EventArgse){();}privatevoidbutton13_Click(objectsender,EventArgse){try{DataSetdsMyDataBase=newDataSet();SqlDataAdapterdaBaseInform=newSqlDataAdapter("Select*fromContact",;(dsMyDataBase,"BaseInform");=["BaseInform"];}catch(Exceptionex){+"打开数据库失败！");}}privatevoidbutton12_Click(objectsender,EventArgse){try{DataSetdsMyDataBase=newDataSet();SqlDataAdapterdaBaseInform=newSqlDataAdapter("Select*fromContact",;(dsMyDataBase,"BaseInform");=["BaseInform"];}catch(Exceptionex){+"失败！");}}privatevoidbutton14_Click(objectsender,EventArgse){{

Dat