以前写的一个手机通讯录管理小程序回忆一下（C#版大牛绕过）致曾经写过的小程序

一  简介

带界面，基于桌面数据库，代码不多，难度也不大，功能也很简单，

就是无意在电脑上发现，怀念一下，呵呵。

2 准备

安装office 2003 access桌面数据库。开发工具vs2010

Friends.mdb放在当前程序执行同一目录。

3 代码

直接展示代码，包括注释和运行界面

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using System.Data.Sql;using System.Data.OleDb;namespace Contact{    public partial class MainForm : Form    {         string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Friends.mdb";        private bool isAdd;        private int Fid;        public MainForm()        {            InitializeComponent();        }        /// <summary>        /// 添加源信息        /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        private void MainForm_Load(object sender, EventArgs e)        {            this.GetFriendInfo();        }        /// <summary>        /// 从数据库加载所有好友信息        /// </summary>        private void GetFriendInfo()        {            string sql="select Fid,Fname,Fphone,Faddress,extra from friend";              OleDbConnection OC = new OleDbConnection(connStr);                     OC.Open();                OleDbCommand cmd = new OleDbCommand(sql,OC);           try           {                this.listView.Items.Clear();               OleDbDataReader reader;               reader = cmd.ExecuteReader();               while (reader.Read())               {                   string[] subItems = new string[]                    {                        reader.GetInt32(0).ToString(),                        reader.GetString(1),                        reader.GetString(2),                        reader.GetString(3),                        reader.GetString(4)                    };                  // ListViewItem it = new ListViewItem();                   //it.SubItems.AddRange(subItems);                listView.Items.Add(new ListViewItem(subItems));               }               reader.Close();           }           catch (SqlException SQLEX)           {               MessageBox.Show(SQLEX.ToString());   //MessageBox::Show(listView);           }        }        /// <summary>        /// 取得选中联系人的ID        /// </summary>        /// <returns></returns>        private int getSelectID()        {            int result;            if (this.listView.SelectedItems.Count == 0)            {                result = 0;            }            else            {                ListViewItem temp = this.listView.SelectedItems[this.listView.SelectedItems.Count - 1];                result = Convert.ToInt32(temp.SubItems[0].Text);            }            return result;        }        /// <summary>        /// 使相关控件启用        /// </summary>        private void enableInfo()        {            this.clearInfo();            this.txtAddress.Enabled = true;            this.txtName.Enabled = true;            this.txtPhone.Enabled = true;            this.btnOK.Enabled = true;            this.btnRE.Enabled = true;            this.txtName.Focus();        }        /// <summary>        /// 修改相关控件状态        /// </summary>        private void disableInfo()        {            this.clearInfo();            this.txtAddress.Enabled = false;            this.txtName.Enabled = false;            this.txtPhone.Enabled = false;            this.btnOK.Enabled = false;            this.btnRE.Enabled = false;            this.btnAdd.Enabled = true;            this.btnDel.Enabled = true;            this.btnEdit.Enabled = true;        }        private void clearInfo()        {            this.txtName.Text = "";            this.txtPhone.Text = "";            this.txtAddress.Text = "";            this.txtExtra.Text = "";        }        /// <summary>        /// 添加新联系人        /// </summary>        /// <param name="_name">姓名</param>        /// <param name="_phone">电话</param>        /// <param name="_address">地址</param>        public void addInfo(string _name, string _phone, string _address,string _extra)        {            //可以使用Command Parameter来构造sql语句以获得更好的效率和更高的安全性            string sql = "insert into friend (Fname,Fphone,Faddress,extra) values ('";            sql += _name + "','" + _phone + "','" + _address + "','" + _extra + "')";            OleDbConnection OC = new OleDbConnection(connStr);            OleDbCommand cmd = new OleDbCommand(sql,OC);            //SqlConnection conn = new SqlConnection(connStr);            //SqlCommand cmd = new SqlCommand(sql, conn);             OC.Open();            cmd.ExecuteNonQuery();            OC.Close();        }        /// <summary>        /// 修改联系人信息        /// </summary>        /// <param name="_id">需要修改的联系人的id</param>        /// <param name="_name"></param>        /// <param name="_phone"></param>        /// <param name="_address"></param>        public void changeInfo(int _id, string _name, string _phone, string _address,string str_extra)        {            string sql = "update friend set Fname = '" + _name + "',Fphone = '" + _phone + "', Faddress = '" + _address + "',extra = '" + str_extra + "'";            sql += " where Fid = " + _id;            ////SqlConnection conn = new SqlConnection(connStr);            ////SqlCommand cmd = new SqlCommand(sql, conn);            OleDbConnection OC = new OleDbConnection(connStr);            OleDbCommand cmd = new OleDbCommand(sql, OC);                       OC.Open();            cmd.ExecuteNonQuery();            OC.Close();        }        /// <summary>        /// 添加联系人        /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        private void btnAdd_Click(object sender, EventArgs e)        {            this.enableInfo();            this.btnEdit.Enabled = false;            this.btnDel.Enabled = false;            this.isAdd = true;        }        /// <summary>        ///修改联系人信息        /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        private void btnEdit_Click(object sender, EventArgs e)        {            if (this.listView.SelectedItems.Count == 0)            {                MessageBox.Show("请点击选择需要修改的联系人！");                return;            }            this.enableInfo();            ListViewItem lvi = this.listView.SelectedItems[this.listView.SelectedItems.Count - 1];            this.txtName.Text = lvi.SubItems[1].Text;            this.txtPhone.Text = lvi.SubItems[2].Text;            this.txtAddress.Text = lvi.SubItems[3].Text;            this.txtExtra.Text = lvi.SubItems[4].Text;            Fid = Convert.ToInt32(lvi.SubItems[0].Text);            this.isAdd = false;            this.btnDel.Enabled = false;            this.btnAdd.Enabled = false;        }        /// <summary>        /// 删除联系人信息        /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        private void btnDel_Click(object sender, EventArgs e)        {            int infoID = this.getSelectID();            if (infoID == 0)            {                MessageBox.Show("请选中你要删除的那些内容信息！");                return;            }            try            {                string sql = "delete friend where Fid = " + infoID;                //SqlConnection conn = new SqlConnection(connStr);                //conn.Open();                //SqlCommand cmd = new SqlCommand(sql, conn);                //cmd.ExecuteNonQuery();                //conn.Close();                OleDbConnection OC = new OleDbConnection(connStr);                OleDbCommand cmd = new OleDbCommand(sql, OC);                OC.Open();                cmd.ExecuteNonQuery();                OC.Close();                this.GetFriendInfo();            }            catch (Exception ex)            {                MessageBox.Show(ex.Message);            }        }        /// <summary>        /// 本软件版本信息        /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        private void btnAbout_Click(object sender, EventArgs e)        {            MessageBox.Show("个人手机通讯录，仅用于演示。\n\n    CopyRight CODE", "演示程序",                 MessageBoxButtons.OK, MessageBoxIcon.Information);        }        /// <summary>        /// 取消按钮        /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        private void btnRE_Click(object sender, EventArgs e)        {            this.disableInfo();        }        /// <summary>        /// 确定按钮        /// </summary>        /// <param name="sender"></param>        /// <param name="e"></param>        private void btnOK_Click(object sender, EventArgs e)        {            //在执行下面的操作之前你可以对用户提交的信息进行合法验证            //不合法的数据应该拒绝操作            if (this.isAdd)            {                try                {                    addInfo(this.txtName.Text, this.txtPhone.Text, this.txtAddress.Text,this.txtExtra.Text);                    MessageBox.Show("成功添加联系人。");                    this.GetFriendInfo();                    this.disableInfo();                }                catch (Exception ex)                {                    MessageBox.Show(ex.Message);                }            }            else            {                try                {                    changeInfo(Fid, this.txtName.Text, this.txtPhone.Text, this.txtAddress.Text,this.txtExtra.Text);                    MessageBox.Show("成功修改联系人信息。");                    this.GetFriendInfo();                    this.disableInfo();                }                catch (Exception ex)                {                    MessageBox.Show(ex.Message);                }            }        }                  }}

运行界面（不怎么友好)