1 using System;
  2 using System.Collections.Generic;
  3 using System.ComponentModel;
  4 using System.Data;
  5 using System.Drawing;
  6 using System.Text;
  7 using System.Windows.Forms;
  8 using System.Data.SqlClient;//
  9 
 10 namespace DataBaseOperation
 11 {
 12     public partial class frmUpdate : Form
 13     {
 14         public frmUpdate()
 15         {
 16             InitializeComponent();
 17         }
 18 
 19         private void btnSearchStudentInfo_Click(object sender, EventArgs e)
 20         {
 21             //根据学号查询学员信息
 22             string id = this.txtNum.Text.Trim();
 23             if (id != "")
 24             {
 25                 string sql = string.Format("select sname,ssex,saddress,semail from students where sid={0}", id);
 26                 try
 27                 {
 28                     SqlCommand command = new SqlCommand(sql, DBHelper.connection);
 29                     DBHelper.connection.Open();
 30                     SqlDataReader sdr = command.ExecuteReader();
 31                     if (sdr.Read())
 32                     {
 33                         this.txtName.Text = sdr["sname"].ToString();
 34                         // MessageBox.Show("性别字段的值："+sdr["ssex"].ToString());
 35                         if (sdr["ssex"].ToString().ToLower() == "true")
 36                         {
 37                             this.radMan.Checked = true;
 38                         }
 39                         else
 40                         {
 41                             this.radWoman.Checked = true;
 42                         }
 43                         this.txtAddress.Text = sdr["saddress"].ToString();
 44                         this.txtEmail.Text = sdr["semail"].ToString();
 45 
 46                         //激活或屏蔽窗体中部分控件
 47                         this.txtNum.Enabled = false;
 48                         this.txtName.Enabled = true;
 49                         this.txtAddress.Enabled = true;
 50                         this.txtEmail.Enabled = true;
 51                         this.radMan.Enabled = true;
 52                         this.radWoman.Enabled = true;
 53                     }
 54                     else
 55                     {
 56                         MessageBox.Show("查无此人！");
 57                         this.txtNum.Text = "";
 58                         this.txtNum.Focus();
 59                         this.txtName.Text = "";
 60                         this.radMan.Checked = true;
 61                         this.txtAddress.Text = "";
 62                         this.txtEmail.Text = "";
 63                     }
 64 
 65                     sdr.Close();
 66 
 67 
 68                 }
 69                 catch (Exception ex)
 70                 {
 71 
 72                     MessageBox.Show(ex.Message);
 73                 }
 74                 finally
 75                 {
 76                     DBHelper.connection.Close();
 77                 }
 78             }
 79             else
 80             {
 81                 MessageBox.Show("请输入学号！");
 82             }
 83         }
 84 
 85         private void btnUpdate_Click(object sender, EventArgs e)
 86         {
 87             //1.
 88             string id = this.txtNum.Text.Trim();
 89             string name = this.txtName.Text.Trim();
 90             string sex;
 91             if (this.radMan.Checked)
 92             {
 93                 sex = "1";
 94             }
 95             else
 96             {
 97                 sex = "0";
 98             }
 99             string address = this.txtAddress.Text.Trim();
100             string email = this.txtEmail.Text.Trim();
101 
102             //2.
103             string sql = string.Format("update students set sname='{0}',ssex={1},saddress='{2}',semail='{3}' where sid={4}", name, sex, address, email, id);
104 
105             //3.
106             try
107             {
108                 SqlCommand command = new SqlCommand(sql, DBHelper.connection);
109                 DBHelper.connection.Open();
110                 int result = command.ExecuteNonQuery();
111                 if (result > 0)
112                 {
113                     MessageBox.Show("更新完毕！");
114                     //激活或屏蔽窗体中部分控件
115                     this.txtNum.Enabled = true;
116                     this.txtName.Enabled = false;
117                     this.txtAddress.Enabled = false;
118                     this.txtEmail.Enabled = false;
119                     this.radMan.Enabled = false;
120                     this.radWoman.Enabled = false;
121 
122                 }
123                 else
124                 {
125                     MessageBox.Show("更新操作失败！");
126                 }
127             }
128             catch (Exception ex)
129             {
130 
131                 MessageBox.Show(ex.Message);
132             }
133             finally
134             {
135                 DBHelper.connection.Close();
136             }
137         }
138     }
139 }