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.IO;

namespace?通訊錄
{
????public?partial?class?AddNewContactForm?:?ContactForm
????{
????????public?AddNewContactForm（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?btnSaveContact_Click（object?sender?EventArgs?e）
????????{
????????????string?selectCommandText=“select?*?from?Contact“;
???????????//?string?updateCommandText?=?“update?Contact?set?contactImage=@Image?where?contactQqNumber=‘“?+?this.tempQqNumber?+?“‘“;
????????????SqlConnection?con?=?Database.CreateConnection（）;
????????????con.Open（）;
????????????SqlDataAdapter?dtAdapter?=?new?SqlDataAdapter（selectCommandText?con）;
????????????SqlCommandBuilder?cmdBuilder?=?new?SqlCommandBuilder（dtAdapter）;
????????????DataSet?dtSet=new?DataSet（）;????????
????????????dtAdapter.Fill（dtSet?“Contact“）;
????????????DataRow?dtRow?=?dtSet.Tables[“Contact“].NewRow（）;
????????????if?（strPicturePath?!=?null）
????????????{
????????????????FileStream?stream?=?new?FileStream（strPicturePath?FileMode.Open?FileAccess.Read）;
????????????????long?picLength?=?stream.Length;
????????????????byte[]?buffer?=?new?byte[（int）picLength];
????????????????stream.Read（buffer?0?（int）picLength）;
????????????????dtRow[“contactImage“]?=?buffer;
????????????????//dtAdapter.UpdateCommand?=?new?SqlCommand（updateCommandText?con）;
????????????????//dtAdapter.UpdateCommand.Parameters.Add（“@Image“?SqlDbType.Image）;
????????????????//dtAdapter.UpdateCommand.Parameters[“@Image“].Value?=?buffer;
????????????????//dtAdapter.UpdateCommand.ExecuteNonQuery（）;???????????????
????????????}?????
????????????dtRow[“contactAcademyName“]?=?this.txtAcademyName.Text;
????????????dtRow[“contactClass“]?=?this.txtClass.Text;
????????????dtRow[“contactName“]?=?this.txtContactName.Text;
????????????dtRow[“contactEmail“]?=?this.txtEmail.Text;
????????????dtRow[“contactGrade“]?=?this.txtGrade.Text;
????????????dtRow[“contactAddress“]?=?this.txtHomeAddress.Text;
????????????dtRow[“contactMobileNumber“]?=?this.txtMobilePhoneNumber.Text;
????????????dtRow[“contactQqNumber“]?=?this.txtQqNumber.Text;
????????????dtRow[“contactSchoolName“]?=?this.txtSchoolName.Text;
????????????dtRow[“contactTelephoneNumber“]?=?this.txtTelephoneNumber.Text;
????????????dtRow[“contactBlessingWords“]?=?this.richTxtBlessingWords.Text;
????????????dtRow[“contactID“]?=?dtSet.Tables[“Contact“].Rows.Count;
????????????dtSet.Tables[“Contact“].Rows.Add（dtRow）;
????????????dtAdapter.Update（dtSet?“Contact“）;
????????????con.Close（）;
????????????MessageBox.Show（“保存成功!“?“提示“?MessageBoxButtons.OK）;
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1345??2009-07-03?03:57??通訊錄_SQLServer版\ContactsInfo.sql

?????文件?????569501??2009-12-25?13:26??通訊錄_SQLServer版\Readme.docx

?????文件???????2841??2009-07-04?03:15??通訊錄_SQLServer版\通訊錄\AddNewContactForm.cs

?????文件???????4442??2009-07-04?02:00??通訊錄_SQLServer版\通訊錄\AddNewContactForm.Designer.cs

?????文件???????5814??2009-07-04?02:00??通訊錄_SQLServer版\通訊錄\AddNewContactForm.resx

?????文件???????5632??2005-11-11?22:25??通訊錄_SQLServer版\通訊錄\bin\Debug\通訊錄.vshost.exe

?????文件???????2610??2009-07-04?02:24??通訊錄_SQLServer版\通訊錄\ContactForm.cs

?????文件??????21540??2009-07-03?06:04??通訊錄_SQLServer版\通訊錄\ContactForm.Designer.cs

?????文件?????178997??2009-06-29?17:09??通訊錄_SQLServer版\通訊錄\ContactForm.resx

?????文件???????1753??2009-07-02?00:42??通訊錄_SQLServer版\通訊錄\Database.cs

?????文件???????4771??2009-07-04?03:18??通訊錄_SQLServer版\通訊錄\EditContactForm.cs

?????文件???????4436??2009-07-04?02:00??通訊錄_SQLServer版\通訊錄\EditContactForm.Designer.cs

?????文件???????5814??2009-07-04?02:00??通訊錄_SQLServer版\通訊錄\EditContactForm.resx

?????文件????????335??2009-07-04?03:48??通訊錄_SQLServer版\通訊錄\Help.cs

?????文件???????2474??2009-07-04?03:48??通訊錄_SQLServer版\通訊錄\Help.Designer.cs

?????文件???????6591??2009-07-04?03:48??通訊錄_SQLServer版\通訊錄\Help.resx

?????文件???????3587??2009-07-01?20:57??通訊錄_SQLServer版\通訊錄\ListViewColumnSorter.cs

?????文件????????889??2009-06-29?17:07??通訊錄_SQLServer版\通訊錄\LoginForm.cs

?????文件???????6986??2009-06-29?17:07??通訊錄_SQLServer版\通訊錄\LoginForm.Designer.cs

?????文件???????5987??2009-06-29?17:07??通訊錄_SQLServer版\通訊錄\LoginForm.resx

?????文件???????2284??2009-07-04?04:49??通訊錄_SQLServer版\通訊錄\MainForm.cs

?????文件???????8876??2009-07-04?04:49??通訊錄_SQLServer版\通訊錄\MainForm.Designer.cs

?????文件???????6192??2009-07-04?04:49??通訊錄_SQLServer版\通訊錄\MainForm.resx

?????文件??????40960??2005-03-14?15:54??通訊錄_SQLServer版\通訊錄\MyListView.dll

?????文件??????23267??2009-07-04?04:18??通訊錄_SQLServer版\通訊錄\PrintListView.cs

?????文件???????1166??2009-06-27?16:44??通訊錄_SQLServer版\通訊錄\Properties\AssemblyInfo.cs

?????文件???????4112??2009-07-01?19:39??通訊錄_SQLServer版\通訊錄\Properties\Resources.Designer.cs

?????文件???????7181??2009-06-29?16:57??通訊錄_SQLServer版\通訊錄\Properties\Resources.resx

?????文件???????1105??2009-07-01?19:39??通訊錄_SQLServer版\通訊錄\Properties\Settings.Designer.cs

?????文件????????249??2009-06-27?16:44??通訊錄_SQLServer版\通訊錄\Properties\Settings.settings

............此處省略38個(gè)文件信息