数据库实验四 张东站.doc

数据库实验四 实验内容 利用DataGridView显示数据 显示数据库中对应表的所有数据 根据条件查询 利用新建的WinForm界面新增、编辑数据 实现删除当前选中的某一行。 实验代码 ?xml version=1.0 encoding=utf-8 ? configuration appSettings add key=ConnectionString value=Integrated Security=sspi;server=localhost;database=db_stu;uid=sa;pwd=123/ /appSettings /configuration StudenntEditForm.cs using 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 StudentManage { 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 [Student]([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() + ,; } if (string.IsNullOrEmpty(this.textBoxName.Text.ToString())) { MessageBox.Show(姓名不能为空); return; } else { sql += + this.textBoxName.Text.ToString() + ,; } sql += + boBoxGrade.SelectedItem.ToString() + ,; if (!string.IsNullOrEmpty(this.textBoxEmail.Text.ToString()))