《学生信息维护.doc》由会员分享,可在线阅读,更多相关《学生信息维护.doc(6页珍藏版)》请在金锄头文库上搜索。
1、学生信息维护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;using System.Data.OleDb;namespace qimolianxi public partial class Form1 : Form public Form1() InitializeComponent(); p
2、rivate void Form1_Load(object sender, EventArgs e) OleDbConnection objConn = new OleDbConnection(); objConn.ConnectionString = Provider = Microsoft.Jet.OLEDB.4.0;Data Source = + (Student.mdb); clsMyCboClass obj1 = new clsMyCboClass(); clsMyCboClass obj2 = new clsMyCboClass(); clsMyCboClass obj3 = ne
3、w clsMyCboClass(); obj1.Value = 00; obj1.Text = 未知; obj2.Value = 01; obj2.Text = 男; obj3.Value = 02; obj3.Text = 女; List lstobjs = new List(); lstobjs.Add(obj1); lstobjs.Add(obj2); lstobjs.Add(obj3); cboSex.DataSource = lstobjs; cboSex.DisplayMember = Text; cboSex.ValueMember = Value; private void b
4、tnQuery_Click(object sender, EventArgs e) BindTableStudent(); private void BindTableStudent() lblMsg.Text = ; StringBuilder sbCondition = new StringBuilder(); sbCondition.Append(1=1); if (txtStuId.Text.Trim() != ) sbCondition.AppendFormat(and 学号 like 0%, txtStuId.Text.Trim(); if (txtName.Text.Trim()
5、 != ) sbCondition.AppendFormat(and 姓名 like 0%, txtName.Text.Trim(); if (cboSex.SelectedIndex 0) sbCondition.AppendFormat(and 性别 like 0, cboSex.Text.ToString(); OleDbConnection objConn = new OleDbConnection(); objConn.ConnectionString = Provider = Microsoft.Jet.OLEDB.4.0;Data Source= + (Student.mdb);
6、 OleDbCommand objSqlCmd; OleDbDataAdapter objSqlAdp; DataTable objDT; string strSQL; strSQL = string.Format(Select * from 学生信息 where 0, sbCondition.ToString(); try objConn.Open(); objSqlCmd = new OleDbCommand(); objSqlCmd.Connection = objConn; objSqlCmd.CommandType = CommandType.Text; objSqlCmd.Comm
7、andText = strSQL; objSqlAdp = new OleDbDataAdapter(); objSqlAdp.SelectCommand = objSqlCmd; objDT = new DataTable(); objSqlAdp.Fill(objDT); dataGridView1.DataSource = objDT; catch (Exception objException) lblMsg.Text = 打开DataTable不成功 + objException.Message; finally objConn.Close(); private void btnAd
8、d_Click(object sender, EventArgs e) frmInsertRecord frm = new frmInsertRecord(); frm.ShowDialog(); private void btnDelete_Click(object sender, EventArgs e) if (dataGridView1.SelectedRows.Count = 0) MessageBox.Show(selected recNum is 0!); return; string strStuId = dataGridView1.SelectedRows0.Cells0.V
9、alue.ToString(); OleDbConnection objConn = new OleDbConnection(); objConn.ConnectionString = Provider = Microsoft.Jet.OLEDB.4.0;Data Source= + (Student.mdb); OleDbCommand objSqlCmd; string strSQL; strSQL = delete from 学生信息 where 学号 = + strStuId + ; try objConn.Open(); objSqlCmd = new OleDbCommand();
10、 objSqlCmd.Connection = objConn; objSqlCmd.CommandType = CommandType.Text; objSqlCmd.CommandText = strSQL; objSqlCmd.ExecuteNonQuery(); lblMsg.Text = string.Format(删除记录0成功, txtStuId.Text); catch (Exception objException) lblMsg.Text = 打开DataTable不成功; throw new Exception(, objException); finally objConn.Close(); BindTableStudent(); private void btnUpdate_Click(object sender, EventArgs e) if (dataGridView1.SelectedRows.Count = 0) MessageBox.Show(selected recNum is 0!); return;