数据库实验四 张东站

1、数据库实验四 一 实验内容1. 利用DataGridView显示数据1） 显示数据库中对应表的所有数据2） 根据条件查询2. 利用新建的WinForm界面新增、编辑数据实现删除当前选中的某一行。二 实验代码 <?xml version="1.0" encoding="utf-8" ?><configuration> <appSettings> <add key="ConnectionString" value="Integrated Security=sspi;server=loca

2、lhost;database=db_stu;uid=sa;pwd=123"/> </appSettings></configuration>StudenntEditForm.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace Stude

3、ntManage public partial class StudentEditForm : Form public StudentEditForm() InitializeComponent(); public string StudentID; public string Optype; private void buttonSubmit_Click(object sender, EventArgs e) string sql = string.Empty; try if (Optype.Equals("ADD") sql = "INSERT INTO St

4、udent(no,sid,name,grade,email,qq,telephone) VALUES(" sql += "'" + Guid.NewGuid() + "'," if (string.IsNullOrEmpty(this.textBoxSno.Text.ToString() MessageBox.Show("学号不能为空"); return; else sql += "'" + this.textBoxSno.Text.ToString() + "'

5、," if (string.IsNullOrEmpty(this.textBoxName.Text.ToString() MessageBox.Show("姓名不能为空"); return; else sql += "'" + this.textBoxName.Text.ToString() + "'," sql += "'" + boBoxGrade.SelectedItem.ToString() + "'," if (!string.IsNullOr

6、Empty(this.textBoxEmail.Text.ToString() sql += "'" + this.textBoxEmail.Text.ToString() + "'," else sql += "''," if (!string.IsNullOrEmpty(this.textBoxQQ.Text.ToString() sql += "'" + this.textBoxQQ.Text.ToString() + "'," else s

7、ql += "''," if (!string.IsNullOrEmpty(this.textBoxTelephone.Text.ToString() sql += "'" + this.textBoxTelephone.Text.ToString() + "'," else sql += "''," sql = sql.Substring(0, sql.Length - 1); sql += ")" DBUtility.DbHelperSQL.E

8、xecuteSql(sql); else sql = "UPDATE Student SET " sql += "sid='" + this.textBoxSno.Text.ToString() + "'," sql += "name='" + this.textBoxName.Text.ToString() + "'," sql += "grade='" + boBoxGrade.SelectedItem.ToString() + &

9、quot;'," sql += "email='" + this.textBoxEmail.Text.ToString() + "'," sql += "qq='" + this.textBoxQQ.Text.ToString() + "'," sql += "telephone='" + this.textBoxTelephone.Text.ToString() + "'" sql += " WHE

10、RE ID='" + StudentID + "'" DBUtility.DbHelperSQL.ExecuteSql(sql); catch (Exception ex) MessageBox.Show(ex.Message); return; this.Close(); private void StudentEditForm_Load(object sender, EventArgs e) boBoxGrade.SelectedItem = "2010级?"/默认当前下拉框选项 if (Optype.Equals(&quo

11、t;EDIT") GetStudentInfo(StudentID); private void GetStudentInfo(string StudentID) string sql = "SELECT ID,sid,name,grade,email,qq,telephone FROM Student " + " WHERE ID='" + StudentID + "'" DataSet dataSet = DBUtility.DbHelperSQL.Query(sql); if (dataSet != n

12、ull && dataSet.Tables0.Rows.Count > 0) this.textBoxSno.Text = dataSet.Tables0.Rows0"SNO".ToString(); this.textBoxName.Text = dataSet.Tables0.Rows0"Name".ToString(); boBoxGrade.SelectedItem = dataSet.Tables0.Rows0"Grade" this.textBoxEmail.Text = dataSet.Tables

13、0.Rows0"Email".ToString(); this.textBoxQQ.Text = dataSet.Tables0.Rows0"QQ".ToString(); this.textBoxTelephone.Text = dataSet.Tables0.Rows0"Telephone".ToString(); StudentForm.Designer.csnamespace StudentManage partial class StudentForm / <summary> / Required designe

14、r variable. / </summary> private System.ComponentModel.IContainer components = null; / <summary> / Clean up any resources being used. / </summary> / <param name="disposing">true if managed resources should be disposed; otherwise, false.</param> protected overr

15、ide void Dispose(bool disposing) if (disposing && (components != null) components.Dispose(); base.Dispose(disposing); #region Windows Form Designer generated code / <summary> / Required method for Designer support - do not modify / the contents of this method with the code editor. / &l

16、t;/summary> private void InitializeComponent() this.lblSeach = new System.Windows.Forms.Label(); this.panel1 = new System.Windows.Forms.Panel(); this.btnSearch = new System.Windows.Forms.Button(); this.txtName = new System.Windows.Forms.TextBox(); this.txtNo = new System.Windows.Forms.TextBox();

17、this.lblName = new System.Windows.Forms.Label(); this.lblNo = new System.Windows.Forms.Label(); this.panel2 = new System.Windows.Forms.Panel(); this.gridStudent = new System.Windows.Forms.DataGridView(); this.ID = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.SNO = new System.Windows.Fo

18、rms.DataGridViewTextBoxColumn(); this.SName = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.Grade = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.EMail = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.QQ = new System.Windows.Forms.DataGridViewTextBoxColumn(); th

19、is.Telephone = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.label1 = new System.Windows.Forms.Label(); this.btnAdd = new System.Windows.Forms.Button(); this.btnDelete = new System.Windows.Forms.Button(); this.btnEdit = new System.Windows.Forms.Button(); this.panel1.SuspendLayout(); thi

20、s.panel2.SuspendLayout(); (System.ComponentModel.ISupportInitialize)(this.gridStudent).BeginInit(); this.SuspendLayout(); / / lblSeach / this.lblSeach.AutoSize = true; this.lblSeach.Location = new System.Drawing.Point(18, 38); this.lblSeach.Name = "lblSeach" this.lblSeach.Size = new System

21、.Drawing.Size(29, 12); this.lblSeach.TabIndex = 0; this.lblSeach.Text = "检索" / / panel1 / this.panel1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.panel1.Controls.Add(this.btnSearch); this.panel1.Controls.Add(this.txtName); this.panel1.Controls.Add(this.txtNo); this.pan

22、el1.Controls.Add(this.lblName); this.panel1.Controls.Add(this.lblNo); this.panel1.Location = new System.Drawing.Point(14, 45); this.panel1.Name = "panel1" this.panel1.Size = new System.Drawing.Size(655, 40); this.panel1.TabIndex = 1; / / btnSearch / this.btnSearch.Location = new System.Dra

23、wing.Point(490, 6); this.btnSearch.Name = "btnSearch" this.btnSearch.Size = new System.Drawing.Size(75, 23); this.btnSearch.TabIndex = 3; this.btnSearch.Text = "查询" this.btnSearch.UseVisualStyleBackColor = true; this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click

24、); / / txtName / this.txtName.Location = new System.Drawing.Point(327, 9); this.txtName.Name = "txtName" this.txtName.Size = new System.Drawing.Size(124, 21); this.txtName.TabIndex = 2; / / txtNo / this.txtNo.Location = new System.Drawing.Point(133, 9); this.txtNo.Name = "txtNo"

25、this.txtNo.Size = new System.Drawing.Size(124, 21); this.txtNo.TabIndex = 1; this.txtNo.TextChanged += new System.EventHandler(this.txtNo_TextChanged); / / lblName / this.lblName.AutoSize = true; this.lblName.Location = new System.Drawing.Point(280, 16); this.lblName.Name = "lblName" this.

26、lblName.Size = new System.Drawing.Size(41, 12); this.lblName.TabIndex = 0; this.lblName.Text = "姓名" / / lblNo / this.lblNo.AutoSize = true; this.lblNo.Location = new System.Drawing.Point(86, 16); this.lblNo.Name = "lblNo" this.lblNo.Size = new System.Drawing.Size(41, 12); this.lb

27、lNo.TabIndex = 0; this.lblNo.Text = "学号" / / panel2 / this.panel2.BackColor = System.Drawing.SystemColors.Control; this.panel2.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle; this.panel2.Controls.Add(this.gridStudent); this.panel2.Location = new System.Drawing.Point(14, 101); t

28、his.panel2.Name = "panel2" this.panel2.Size = new System.Drawing.Size(655, 302); this.panel2.TabIndex = 2; / / gridStudent / this.gridStudent.AllowUserToAddRows = false; this.gridStudent.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; th

29、is.gridStudent.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn this.ID, this.SNO, this.SName, this.Grade, this.EMail, this.QQ, this.Telephone); this.gridStudent.Location = new System.Drawing.Point(3, 7); this.gridStudent.Name = "gridStudent" this.gridStudent.ReadOnly = true; t

30、his.gridStudent.RowTemplate.Height = 23; this.gridStudent.Size = new System.Drawing.Size(646, 290); this.gridStudent.TabIndex = 0; this.gridStudent.CellClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.gridStudent_CellClick); / / ID / this.ID.DataPropertyName = "ID" this.

31、ID.HeaderText = "ID" this.ID.Name = "ID" this.ID.ReadOnly = true; this.ID.Visible = false; / / SNO / this.SNO.DataPropertyName = "sid" this.SNO.HeaderText = "学号" this.SNO.Name = "sid" this.SNO.ReadOnly = true; / / SName / this.SName.DataPropertyName

32、= "name" this.SName.HeaderText = "姓名" this.SName.Name = "name" this.SName.ReadOnly = true; / / Grade / this.Grade.DataPropertyName = "grade" this.Grade.HeaderText = "年级" this.Grade.Name = "grade" this.Grade.ReadOnly = true; / / EMail / this

33、.EMail.DataPropertyName = "email" this.EMail.HeaderText = "E-mail" this.EMail.Name = "eMail" this.EMail.ReadOnly = true; / / QQ / this.QQ.DataPropertyName = "qq" this.QQ.HeaderText = "QQ" this.QQ.Name = "qq" this.QQ.ReadOnly = true; / / Tel

34、ephone / this.Telephone.DataPropertyName = "telephone" this.Telephone.HeaderText = "电话" this.Telephone.Name = "telephone" this.Telephone.ReadOnly = true; / / label1 / this.label1.AutoSize = true; this.label1.Location = new System.Drawing.Point(18, 94); this.label1.Name

35、= "label1" this.label1.Size = new System.Drawing.Size(29, 12); this.label1.TabIndex = 0; this.label1.Text = "列表" / / btnAdd / this.btnAdd.Location = new System.Drawing.Point(183, 425); this.btnAdd.Name = "btnAdd" this.btnAdd.Size = new System.Drawing.Size(75, 23); this.

36、btnAdd.TabIndex = 3; this.btnAdd.Text = "新增" this.btnAdd.UseVisualStyleBackColor = true; this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click); / / btnDelete / this.btnDelete.Location = new System.Drawing.Point(422, 425); this.btnDelete.Name = "btnDelete" this.btnDelete

37、.Size = new System.Drawing.Size(75, 23); this.btnDelete.TabIndex = 3; this.btnDelete.Text = "删除" this.btnDelete.UseVisualStyleBackColor = true; this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click); / / btnEdit / this.btnEdit.Location = new System.Drawing.Point(297, 425); t

38、his.btnEdit.Name = "btnEdit" this.btnEdit.Size = new System.Drawing.Size(75, 23); this.btnEdit.TabIndex = 3; this.btnEdit.Text = "编辑" this.btnEdit.UseVisualStyleBackColor = true; this.btnEdit.Click += new System.EventHandler(this.btnEdit_Click); / / StudentForm / this.AutoScaleDi

39、mensions = new System.Drawing.SizeF(6F, 12F); this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font; this.ClientSize = new System.Drawing.Size(681, 469); this.Controls.Add(this.btnDelete); this.Controls.Add(this.btnEdit); this.Controls.Add(this.btnAdd); this.Controls.Add(this.label1); this.Co

40、ntrols.Add(this.lblSeach); this.Controls.Add(this.panel2); this.Controls.Add(this.panel1); this.Name = "StudentForm" this.Text = "数据库实验" this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.panel2.ResumeLayout(false); (System.ComponentModel.ISupportInitialize)(this.

41、gridStudent).EndInit(); this.ResumeLayout(false); this.PerformLayout(); #endregion private System.Windows.Forms.Label lblSeach; private System.Windows.Forms.Panel panel1; private System.Windows.Forms.Label lblNo; private System.Windows.Forms.Button btnSearch; private System.Windows.Forms.TextBox txt

42、Name; private System.Windows.Forms.TextBox txtNo; private System.Windows.Forms.Label lblName; private System.Windows.Forms.Panel panel2; private System.Windows.Forms.DataGridView gridStudent; private System.Windows.Forms.Label label1; private System.Windows.Forms.Button btnAdd; private System.Window

43、s.Forms.Button btnDelete; private System.Windows.Forms.Button btnEdit; private System.Windows.Forms.DataGridViewTextBoxColumn ID; private System.Windows.Forms.DataGridViewTextBoxColumn SNO; private System.Windows.Forms.DataGridViewTextBoxColumn SName; private System.Windows.Forms.DataGridViewTextBox

44、Column Grade; private System.Windows.Forms.DataGridViewTextBoxColumn EMail; private System.Windows.Forms.DataGridViewTextBoxColumn QQ; private System.Windows.Forms.DataGridViewTextBoxColumn Telephone; studentForm.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using DBUtility;namespace StudentManage public partial class StudentForm