显示数据计算机工程学院计算机信息管理专业

1、编写代码显示更新数据1界面设计3 个Label，3 个按钮 Button，3 个文本框 TextBox，一个列表框 ListBox1更改窗体的标题（Label）的 Text 属性更改23更改 TextBox 的 Name 属性更改文本框 TextBox1 的 ReadOnly 属性为 True4更改 TextBox 的 Name 属性更改 TextBox 的 Name 属性5更改按钮的 Name 属性更改按钮的 Text 属性6更改按钮的 Name 属性更改按钮的 Text 属性7更改按钮的 Name 属性更改按钮的 Text 属性8更改 ListBox 的 Name 属性92编写相关代码双击

2、窗体空白处10增加对相关名称空间的编写一个用于显示学生信息的方法11编写窗体的 Load 事件处理代码双击列表框12编写该列表框的 SelectedIndexChanged 事件的处理代码双击刷新按钮13编写该按钮单击事件的处理代码双击“更改(方法 1)”按钮14编写该按钮单击事件的处理代码双击“更改(方法 2)”按钮15编写该按钮单击事件的处理代码双击文本框16编写该文本框 TextChanged 事件的处理代码双击文本框17编写该文本框 TextChanged 事件的处理代码代码如下（粗体字才是需要输入的代码）18using System;using System.Collections.

3、Generic; usingponentM; using System.Data;using System.Drawing; using System.Text;using System.Windows.Forms; using System.Data.SqlCnt;namespace WindowsApplication2public partial class Form1 : Formpublic Form1()ponent();public void ShowStudentInfo()19this.lsbInfo.Items.Clear();stringStr = Data Source

4、=.SQL2005EXPRESS;InitialCatalog=StudentDB;egrated Security=True;SqlConnection myConnection = new SqlConnection(Str);/string Str = Data Source=.SQL2005EXPRESS;Initial Catalog=StudentDB;Persist Security Info=True;User ID=ssword=sa;/SqlConnection myConnection = new SqlConnection(Str); myConnection.Open

5、();mandmand = myComand(); mandText = SELECT * FROM student;SqlDataReader myReader =mand.ExecuteReader(); while (myReader.Read()this.lsbInfo.Items.Add(myReadername + ( + myReaderage+);myReader.Close(); myConnection.Close(); this.txbID.Text = ; this.txbName.Text = ; this.txbAge.Text = ;private void Fo

6、rm1_Load(objecder, EventArgs e)this.ShowStudentInfo();this.btnUpdate1.Enabled = false;this.btnUpdate2.Enabled = false;private void lsbInfo_SelectedIndexChanged(objecder, EventArgs e)string Str = Data Source=.SQL2005EXPRESS;Initial Catalog=StudentDB;egrated Security=True;SqlConnection myConnection =

7、new SqlConnection(Str);/string Str = Data Source=.SQL2005EXPRESS;Initial Catalog=StudentDB;Persist Security Info=True;User ID=ssword=sa;/SqlConnection myConnection = new SqlConnection(Str);myConnection.Open();SqlDataAdapter myAdapter = new SqlDataAdapter(SELECT * FROM student, myConnection);DataSet

8、myDataSet = new DataSet();myAdapter.Fill(myDataSet, myStudentTable);this.txbID.Text = myDataSet.TablesmyStudentTable.Rowsthis.lsbInfo.SelectedIndexid.ToString();this.txbName.Text = myDataSet.TablesmyStudentTable.Rowsthis.lsbInfo.SelectedIndexname.ToString();this.txbAge.Text =myDataSet.TablesmyStuden

9、tTable.Rowsthis.lsbInfo.SelectedIndexage.ToString();myConnection.Close();this.btnUpdate1.Enabled = false;this.btnUpdate2.Enabled = false;private void btnRefresh_Click(objecder, EventArgse)this.ShowStudentInfo();this.btnUpdate1.Enabled = false;this.btnUpdate2.Enabled = false;private void btnUpdate1_C

10、lick(objecder, EventArgse)Catalog=StudentDB;egrated Security=True;SqlConnection myConnection = new SqlConnection(Str);/string Str = Data Source=.SQL2005EXPRESS;Initial Catalog=StudentDB;Persist Security Info=True;User ID=ssword=sa;/SqlConnection myConnection = new SqlConnection(Str);myConnection.Ope

11、n();SqlDataAdapter myAdapter = new SqlDataAdapter(SELECT * FROM student, myConnection);mandBuilder myBuilder = dBuilder(myAdapter);DataSet myDataSet = new DataSet();myAdapter.Fill(myDataSet, myStudentTable);myDataSet.TablesmyStudentTable.Rowsthis.lsbInfo.SelectedIndexname = this.txbName.Text;myDataS

12、et.TablesmyStudentTable.Rowsthis.lsbInfo.SelectedIndexage = Convert.To32(this.txbAge.Text);private voidbtnUpdate2_Click(objecder, EventArgs e)string Str = Data Source=.SQL2005EXPRESS;Initial Catalog=StudentDB;egrated Security=True;SqlConnection myConnection = new SqlConnection(Str);/string Str = Dat

13、a Source=.SQL2005EXPRESS;Initial Catalog=StudentDB;Persist Security Info=True;User ID=ssword=sa;20myAdapter.Update(myDataSet, myStudentTable);myConnection.Close();this.btnUpdate1.Enabled = false;this.btnUpdate2.Enabled = false;stringStr = Data Source=.SQL2005EXPRESS;Initial/SqlConnection myConnectio

14、n =new SqlConnection(Str);/myConnection.Open();SqlDataAdapter myAdapter = new myConnection);SqlDataAdapter(SELECT * FROM student,mandBuilder myBuilder = dBuilder(myAdapter);DataSet myDataSet = new DataSet();myAdapter.Fill(myDataSet, myStudentTable);Dolumn mykeys = new Dolumn1;findRowage = Convert.To

15、32(this.txbAge.Text);myAdapter.Update(myDataSet, myStudentTable);myConnection.Close(); this.btnUpdate1.Enabled = false; this.btnUpdate2.Enabled = false;private void txbName_TextChanged(objecthis.btnUpdate1.Enabled = true;this.btnUpdate2.Enabled = true;private void txbAge_TextChanged(objecthis.btnUpdate1.Enabled = true;this.btnUpdate2.Enabled = true;der, EventArgs e)der, EventArgs e)21DataRow findRow = myDataSet.TablesmyStudentTable.Rows.Find(this.txbID.Text);if (findRow != null)= this