开发工具:
文件大小: 21kb
下载次数: 0
上传时间: 2010-09-30
详细说明： using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; namespace AddressList { /// /// Form1 的摘要说明。 /// 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.Windo ws.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; /// /// 必需的设计器变量。 /// private System.ComponentModel.Container components = null; public AddressList() { // // Windows 窗体设计器支持所必需的 // InitializeComponent(); // // TOD 在 InitializeComponent 调用后添加任何构造函数代码 // } /// /// 清理所有正在使用的资源。 /// protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } /// /// 应用程序的主入口点。 /// [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"; } } } ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
