重庆三峡学院
DataSet dsco = sco.select(\ dataGridView4.DataSource = dsco;
dataGridView4.DataMember = \ }
private void button_sql_Click(object sender, EventArgs e) {
string sql = textBox6.Text;
string strCon = \Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =\+ System.Windows.Forms.Application.StartupPath + @\ OleDbConnection conn = new OleDbConnection(strCon); OleDbCommand cmd = new OleDbCommand(); try {
cmd.CommandText = sql; cmd.Connection = conn; OleDbDataAdapter dr = new OleDbDataAdapter(cmd.CommandText, conn.ConnectionString);
DataSet ds = new DataSet(); dr.Fill(ds, \
dataGridView5.DataSource = ds;
dataGridView5.DataMember = \ conn.Close(); } catch {
conn.Close();
MessageBox.Show(\查询失败！\ } } } }
2.内部类代码实现 2.1学生类
namespace StudentManagerSys {
class Student {
public String strCon;
共 42 页 第 25 页
重庆三峡学院
public OleDbConnection conn; public OleDbCommand cmd;
public Student() {
strCon = \Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =\+ System.Windows.Forms.Application.StartupPath + @\ conn = new OleDbConnection(strCon); cmd = new OleDbCommand(); }
public void insert(string studentno, string studentname, string studentsex, string studentbirth, string studentnative, string studentaddress) {
cmd.CommandText = \\ cmd.Connection = conn; try {
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\添加成功\ } catch {
MessageBox.Show(\添加失败！\ } }
public void delete(string studentno) {
cmd.CommandText = \ cmd.Connection = conn; try {
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\删除成功！\ conn.Close(); } catch {
conn.Close();
MessageBox.Show(\删除失败！\
共 42 页 第 26 页
重庆三峡学院
} }
public DataSet select(string selectype,string item) {
try {
cmd.CommandText = \ cmd.Connection = conn; OleDbDataAdapter dr = new conn.ConnectionString);
DataSet ds = new DataSet(); dr.Fill(ds, \ conn.Close(); return ds; } catch {
conn.Close();
MessageBox.Show(\查询失败！\ }
return null; }
public DataSet selectAll() {
try {
cmd.CommandText = \ cmd.Connection = conn; OleDbDataAdapter dr = new conn.ConnectionString);
DataSet ds = new DataSet(); dr.Fill(ds, \ conn.Close(); return ds; } catch {
conn.Close();
MessageBox.Show(\查询失败！\ }
return null; }
共 42 页 第 27 页
OleDbDataAdapter(cmd.CommandText, OleDbDataAdapter(cmd.CommandText, 重庆三峡学院
public void update(string studentno, string studentname, string studentsex, string studentbirth, string studentnative, string studentaddress) {
int student_sex = 0; if (studentsex == \ student_sex = 0; else
student_sex = 1;
cmd.CommandText = %update student set \+ \+ studentname + \studentsex=\+ student_sex + \studentbirth='\+ studentbirth + \studentnative='\+ studentnative + \studentaddress='\ cmd.Connection = conn; try {
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\修改成功！\ conn.Close(); } catch {
conn.Close();
MessageBox.Show(\修改失败！\ } } } }
2.2班级类
namespace StudentManagerSys {
class Classinfo {
public String strCon;
public OleDbConnection conn; public OleDbCommand cmd;
public Classinfo() {
strCon = \Provider = Microsoft.Jet.OLEDB.4.0 System.Windows.Forms.Application.StartupPath + @\
共 42 页 第 28 页
; Data Source =\+
重庆三峡学院
conn = new OleDbConnection(strCon); cmd = new OleDbCommand(); }
public void insert(string classno, string classdepart, string special, string studyyears, string entertime) {
cmd.CommandText = \+ special + \ cmd.Connection = conn; try {
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\添加成功\ } catch {
MessageBox.Show(\添加失败！\ } }
public void delete(string classno) {
cmd.CommandText = \ cmd.Connection = conn; try {
conn.Open();
cmd.ExecuteNonQuery();
MessageBox.Show(\删除成功！\ conn.Close(); } catch {
conn.Close();
MessageBox.Show(\删除失败！\ } }
public DataSet select(string selectype,string item) {
try {
共 42 页 第 29 页
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库学生成绩管理系统设计说明书(6)在线全文阅读。
相关推荐：