以下是我自己做得电话本的源代码，里面还有点缺陷，请大家指出并且能够改正谢谢了 using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data;
namespace AddressList { /// <summary> /// Form1 的摘要说明。 /// </summary> public class AddressList : System.Windows.Forms.Form { private System.Windows.Forms.GroupBox AddInfo; private System.Windows.Forms.Label lblName; private System.Windows.Forms.Label lblHomePhone; private System.Windows.Forms.Label lblOfficePhone; private System.Windows.Forms.Label lblHandSet; private System.Windows.Forms.Label lblTouchAddress; private System.Windows.Forms.Label lblPostalcode; private System.Windows.Forms.Label lblEmail; private System.Windows.Forms.TextBox txtName; private System.Windows.Forms.TextBox txtHomePhone; private System.Windows.Forms.TextBox txtOfficePhone; private System.Windows.Forms.TextBox txtHandSet; private System.Windows.Forms.TextBox txtTouchAddress; private System.Windows.Forms.TextBox txtPostalCode; private System.Windows.Forms.TextBox txtEmail; private System.Windows.Forms.Button btnAdd; private System.Windows.Forms.GroupBox ExtendOperation; private System.Windows.Forms.PictureBox pictureBox1; private System.Windows.Forms.Button btnModify; private System.Windows.Forms.Button btnDelete; private System.Windows.Forms.Button btnSelect; private System.Windows.Forms.Label lblNote; private System.Windows.Forms.DataGrid dataGrid1; /// <summary> /// 必需的设计器变量。 /// </summary> private System.ComponentModel.Container components = null;
public AddressList() { // // Windows 窗体设计器支持所必需的 // InitializeComponent();
// // TOD 在 InitializeComponent 调用后添加任何构造函数代码 // }
/// <summary> /// 清理所有正在使用的资源。 /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); }
/// <summary> /// 应用程序的主入口点。 /// </summary> [STAThread] static void Main() { Application.Run(new AddressList()); }
private void btnAdd_Click(object sender, System.EventArgs e) { AddInfo add=new AddInfo(); int ret=add.Add(this.txtName.Text,this.txtHomePhone.Text,this.txtOfficePhone.Text,this.txtHandSet.Text,this.txtTouchAddress.Text,this.txtPostalCode.Text,this.txtEmail.Text); if(ret>0) { MessageBox.Show("恭喜你,添加成功!"); bind(); } else { MessageBox.Show("添加失败!原因可能是你输入了重复的名称!"); } this.txtName.Text=""; this.txtHomePhone.Text=""; this.txtOfficePhone.Text=""; this.txtHandSet.Text=""; this.txtTouchAddress.Text=""; this.txtPostalCode.Text=""; this.txtEmail.Text="";
}
private void AddressList_Load(object sender, System.EventArgs e) { bind(); DataGridTableStyle ts1= new DataGridTableStyle(); ts1.MappingName="BasicInfo";
DataGridColumnStyle cs = new DataGridTextBoxColumn(); cs.Alignment=HorizontalAlignment.Center; cs.MappingName="SName"; cs.HeaderText="姓名"; cs.Width=80; ts1.GridColumnStyles.Add(cs);
DataGridColumnStyle cs1 =new DataGridTextBoxColumn(); cs1.Alignment=HorizontalAlignment.Center; ; cs1.MappingName="HomePhone"; cs1.HeaderText="住宅电话"; cs1.Width=80; ts1.GridColumnStyles.Add(cs1);
DataGridColumnStyle cs2 =new DataGridTextBoxColumn(); cs2.Alignment=HorizontalAlignment.Center; ; cs2.MappingName="OfficePhone"; cs2.HeaderText="办公电话"; cs2.Width=80; ts1.GridColumnStyles.Add(cs2); DataGridColumnStyle cs3 = new DataGridTextBoxColumn(); cs3.Alignment=HorizontalAlignment.Center; cs3.MappingName="HandSet"; cs3.HeaderText="手机号码"; cs3.Width=80; ts1.GridColumnStyles.Add(cs3); DataGridColumnStyle cs4 = new DataGridTextBoxColumn(); cs4.Alignment=HorizontalAlignment.Center; cs4.MappingName="TouchAddress"; cs4.HeaderText="通信地址"; cs4.Width=200; ts1.GridColumnStyles.Add(cs4); DataGridColumnStyle cs5 = new DataGridTextBoxColumn(); cs5.Alignment=HorizontalAlignment.Center; cs5.MappingName="PostalCode"; cs5.HeaderText="邮政编码"; cs5.Width=60; ts1.GridColumnStyles.Add(cs5);
DataGridColumnStyle cs6 = new DataGridTextBoxColumn(); cs6.Alignment=HorizontalAlignment.Center; cs6.MappingName="Email"; cs6.HeaderText="电子邮件"; cs6.Width=150; ts1.GridColumnStyles.Add(cs6); this.dataGrid1.TableStyles.Add(ts1); } public void bind() { SearchInfo result = new SearchInfo(); DataSet view = result.GetAddInfo(); this.dataGrid1.DataSource=view; this.dataGrid1.DataMember="BasicInfo"; }
private void btnModify_Click(object sender, System.EventArgs e) { UpdateBasicInfo update=new UpdateBasicInfo(); int ret=update.Update(this.txtName.Text,this.txtHomePhone.Text,this.txtOfficePhone.Text,this.txtHandSet.Text,this.txtTouchAddress.Text,this.txtPostalCode.Text,this.txtEmail.Text); if(ret>0) { bind(); MessageBox.Show("修改成功,请核对!"); } else { MessageBox.Show("修改失败！"); } } private void dataGrid1_Click(object sender, System.EventArgs e) { this.btnModify.Enabled=true; this.btnDelete.Enabled=true; int row=this.dataGrid1.CurrentCell.RowNumber; this.txtName.Text=this.dataGrid1[row,0].ToString(); this.txtHomePhone.Text=this.dataGrid1[row,1].ToString(); this.txtOfficePhone.Text=this.dataGrid1[row,2].ToString(); this.txtHandSet.Text=this.dataGrid1[row,3].ToString(); this.txtTouchAddress.Text=this.dataGrid1[row,4].ToString(); this.txtPostalCode.Text=this.dataGrid1[row,5].ToString(); this.txtEmail.Text=this.dataGrid1[row,6].ToString(); }
private void btnDelete_Click(object sender, System.EventArgs e) { DeleteBasicInfo del= new DeleteBasicInfo(); int ret = del.deleteInfo(this.txtName.Text); if (ret==0) { MessageBox.Show("删除失败！"); } else { bind(); MessageBox.Show("删除成功！"); } }
private void btnSelect_Click(object sender, System.EventArgs e) { SearchInfo search=new SearchInfo(); DataSet result=search.searchInfo(this.txtName.Text); this.dataGrid1.DataSource=result; this.dataGrid1.DataMember="BasicInfo"; }
} }
