using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Linq;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;

namespace?通訊錄
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?radioButton4_CheckedChanged（object?sender?EventArgs?e）
????????{
????????????string?constr?=?“server=.;?Integrated?Security=true;?Initial?Catalog=tongxunlu“;
????????????SqlConnection?con?=?new?SqlConnection（constr）;
????????????SqlCommand?cmd?=?new?SqlCommand（“select?*?from?list“?con）;
????????????SqlDataReader?myreader;
????????????con.Open（）;
????????????myreader?=?cmd.ExecuteReader（）;
????????????while?（myreader.Read（））
????????????{
????????????????if?（!comboBox2.Items.Contains（myreader[“name“]））
????????????????{
????????????????????comboBox2.Items.Add（myreader[“name“].ToString（））;
????????????????????fname.Items.Add（myreader[“name“].ToString（））;
????????????????}

????????????}
????????????con.Close（）;
????????????con.Dispose（）;
????????????textBox1.Text?=?“說明：本軟件是個人愛好，屬于自己學習的娛樂大家可以在學習時進行交流不得用于商業用途，QQ:979170768河軟CSDN樂知學院??net?3班“;

????????????formwidth（814?“修改“）;
????????????comboBox2.Visible?=?true;
????????}

????????private?void?Form1_Load（object?sender?EventArgs?e）
????????{
????????????formwidth（621?“寫入“）;
????????????comboBox2.Visible?=?false;
????????????fname.Enabled?=?false;
????????}

????????private?void?formwidth（int?widthform?string?btnname）
????????{
????????????this.Width?=?widthform;
????????????ok.Text?=?btnname;

????????}

????????private?void?radioButton3_CheckedChanged（object?sender?EventArgs?e）
????????{
????????????comboBox2.Visible?=?false;
????????????formwidth（621?“寫入“）;
????????????comboBox2.Text?=?““;
????????????birthdaytxt.Text?=?““;
????????????mailtxt.Text?=?““;
????????????celltxt.Text?=?““;
????????????QQtxt.Text?=?““;
????????????msntxt.Text?=?““;
????????????adresstxt.Text?=?““;
????????????grapetxt.Text?=?““;
????????????hearttxt.Text?=?““;
????????????memotxt.Text?=?““;

????????}

????????string?sql?=?““;
????????char?b?=?‘0‘;
????????private?void?button2_Click（object?sender?EventArgs?e）
????????{
????????????//tabControl1.SelectedTab.Text?==?“信息錄入“
????????????//判斷哪一個按鍵被選中，如果3被中，那就執行插入，如果是4那就是修改
????????????if?（radioButton3.Checked）
????????????{
????????????????sql?=?“insert?into?list（namesex出生日期愛好[E-mail]電話號QQMSN家庭住址畢業學校說說心里話備注）?values（@name@sex@出生日期@愛好@E@電話號@QQ@MSN@家庭住址@畢業學校@說說心里話@備注）“;
????????????????b?=?‘0‘;
????????????}
????????????else
????????????{
????????????????b?=?‘1‘;
????????????????sql?=?“update?list?set?name=@namesex=@sex出生日期=@出生日期愛好=@愛好[E-mail]=@E電話號=@電話號QQ=@QQMSN=@MSN家庭住址=@家庭住址畢業學校=@畢業學校說說心里話=@說說心里話備注=@備注?where?name=@findname“;

????????????}
????????????//MessageBox.Show（str）;
??

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-09-10?11:29??通訊錄\
?????目錄???????????0??2011-09-10?11:29??通訊錄\data\
?????文件?????3145728??2011-09-10?11:28??通訊錄\data\tongxunlu.mdf
?????文件?????1048576??2011-09-10?11:28??通訊錄\data\tongxunlu_log.ldf
?????目錄???????????0??2011-09-10?11:15??通訊錄\通訊錄\
?????文件?????????869??2011-09-09?08:06??通訊錄\通訊錄.sln
?????文件???????18944??2011-09-10?11:27??通訊錄\通訊錄.suo
?????目錄???????????0??2011-09-09?08:06??通訊錄\通訊錄\bin\
?????目錄???????????0??2011-09-10?10:31??通訊錄\通訊錄\bin\Debug\
?????文件???????33280??2011-09-10?11:27??通訊錄\通訊錄\bin\Debug\通訊錄.exe
?????文件???????40448??2011-09-10?11:27??通訊錄\通訊錄\bin\Debug\通訊錄.pdb
?????文件???????11600??2011-09-10?11:27??通訊錄\通訊錄\bin\Debug\通訊錄.vshost.exe
?????文件?????????490??2010-03-17?22:39??通訊錄\通訊錄\bin\Debug\通訊錄.vshost.exe.manifest
?????文件???????16144??2011-09-10?11:27??通訊錄\通訊錄\Form1.cs
?????文件???????43177??2011-09-10?11:27??通訊錄\通訊錄\Form1.Designer.cs
?????文件????????6408??2011-09-10?11:27??通訊錄\通訊錄\Form1.resx
?????目錄???????????0??2011-09-09?08:06??通訊錄\通訊錄\obj\
?????目錄???????????0??2011-09-09?08:06??通訊錄\通訊錄\obj\x86\
?????目錄???????????0??2011-09-10?11:27??通訊錄\通訊錄\obj\x86\Debug\
?????文件????????4440??2011-09-10?11:19??通訊錄\通訊錄\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件????????6265??2011-09-10?11:27??通訊錄\通訊錄\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件?????????580??2011-09-10?11:27??通訊錄\通訊錄\obj\x86\Debug\GenerateResource.read.1.tlog
?????文件?????????402??2011-09-10?11:27??通訊錄\通訊錄\obj\x86\Debug\GenerateResource.write.1.tlog
?????文件????????7897??2011-09-10?11:21??通訊錄\通訊錄\obj\x86\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2011-09-10?11:15??通訊錄\通訊錄\obj\x86\Debug\TempPE\
?????文件????????4608??2011-09-10?11:15??通訊錄\通訊錄\obj\x86\Debug\TempPE\Properties.Resources.Designer.cs.dll
?????文件?????????655??2011-09-10?11:27??通訊錄\通訊錄\obj\x86\Debug\通訊錄.csproj.FileListAbsolute.txt
?????文件???????33280??2011-09-10?11:27??通訊錄\通訊錄\obj\x86\Debug\通訊錄.exe
?????文件?????????729??2011-09-10?11:27??通訊錄\通訊錄\obj\x86\Debug\通訊錄.Form1.resources
?????文件???????40448??2011-09-10?11:27??通訊錄\通訊錄\obj\x86\Debug\通訊錄.pdb
?????文件????????3521??2011-09-10?11:18??通訊錄\通訊錄\obj\x86\Debug\通訊錄.Properties.Resources.resources
............此處省略10個文件信息