车站售票管理系统数据库课程设计报告

数据库课程设计报告设计名称：组员：专业：班级：院系：指导教师：2013年X月X日一、概述1、项目背景：随着市场经济的不断飞速发展，人们生活水平不断提高，交通道路环境的不断改善，人们的出行次数不断增多，人口流动频繁，数量不断加大。虽然人们出行可以有很多交通工具做选择，但是相对于其他交通工具，汽车还是很多市民所选择的。因此，汽车站信息量迅猛增长。为了更好地方便市民，车站售票管理系统在人们的日常生活中发挥着越来越重要的作用。本系统实现了线路信息，汽车信息，票务信息的查询和管理，满足人们的需求。2、编写目的：掌握数据库设计原理及相关软件的使用。实现方便、快速售票；是用户准确了解售票情况，提供多种查询和统计功能；实现系统的安全性设置，使系统本身具有一定的维护功能。3、软件定义：车站售票管理系统，主要用于车站日常的票务处理。4、开发环境：VisualStudio2008，SQLSERVER2000二、需求分析功能结构图：功能结构图各个模块功能简要说明：1.票务信息管理模块：此模块对所有用户开放，需购买车票的用户可以通过查询时间、线路或汽车信息来确定自己需要购买什么车票。2.线路信息管理模块：系统管理员在此模块中，对车站线路信息进行管理。添加新的线路信息，对已有的线路信息进行修改、删除、查询等操作。3.员工管理模块：员工分为系统管理员和售票员。系统管理员负责整个系统的管理，对汽车、线路、车票信息等进行修改、添加、删除、查询等操作，还可以进行对系统用户即员工的添加、删除，密码的修改等操作。整个系统对系统管理员是全开放的。管理员可以对员工信息、汽车信息、线路信息、车票信息进行查询操作以及购买车票等。4.汽车信息管理模块：系统管理员在此模块中，对汽车信息进行管理。有新的汽车信息时，添加汽车信息，对已有的汽车信息进行修改、删除、查询等操作。5.车票信息管理模块：系统管理员在此模块中，对线路的车票信息进行管理。根据相应的线路信息和汽车信息对车票信息进行添加、修改、删除、和查询操作。系统界面设计分析：程序分为登陆界面，主界面，线路信息管理界面，汽车信息管理界面，车票信息管理界面，票务信息管理界面，员工管理界面这几个主体界面。使用时应先知道管理员、员工或用户顾客账号和密码，登陆进入系统主菜单界面，里面包括线路信息，汽车信息，车票信息，票务信息，退出程序菜单选项。（1）数据流图第一层数据流图第二层数据流图第二层数据流图（2）数据字典1.数据项2.数据结构3.数据流4.数据存储5.处理过程（3）E-R图（四）关系模型：1）user员工表（员工编号uno,姓名username，密码passwd，身份useridentiey）2）coach汽车信息表（汽车编号cno，汽车型号ctype，车牌号cnumber，座位数量cnum，有无电视ctv，有无空调ccondition，负责人cholder）3）line线路信息表（线路编号lno，起始城市lstart，到达城市larrival，路程时间ltime）4）ticket车票信息表（车票编号tno，车牌号cnumber，起始城市lstart，到达城市larrival,车票价格price，已卖票数soldticket，剩余票数lastticket，出发日期tdate，出发时间ttime）5）city站点表（站点编号cityno，站点名称cityName）四、系统实现（一）数据库设计：1.city站点表：2.userinfo员工表：3.ticket车票信息表：4.coach汽车信息表：5.line线路表：（二）主要界面及代码1、登录界面：登录操作代码：privatevoidbutton1_Click(objectsender,EventArgse){stringconnstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";OleDbConnectionconn=newOleDbConnection(connstring);stringsql="select*fromuserinfo";OleDbCommandcmd=newOleDbCommand(sql,conn);conn.Open();OleDbDataReaderr=cmd.ExecuteReader();if(this.textBox1.Text==""||this.textBox2.Text==""||this.textBox3.Text==""){MessageBox.Show("性名、密码、身份不能为空!");}while(r.Read()){if(r["username"].ToString()==this.textBox1.Text&&r["userpasswd"].ToString()==this.textBox2.Text&&r["useridentity"].ToString()==this.textBox3.Text){Fr2.Show();return;}}MessageBox.Show("错误的姓名或密码或与身份不匹配，请重新输入！");r.Close();}2、系统主界面3、员工管理界面：公用代码：privatevoidShowuserinfo() { stringconnStr,selectCmd; connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb"; selectCmd="Select*Fromuserinfo"; OleDbConnectionconn; OleDbDataAdaptermyAdapter; DataSetmyDataSet=newDataSet(); conn=newOleDbConnection(connStr); myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"userinfo");dataGrid1.DataSource=myDataSet.Tables["userinfo"]; } privatestringGetSqlStr(stringstr) { returnstr.Replace("'","''"); }privateintCheckInt(stringstr){try{returnint.Parse(str);}catch{return0;}}搜索代码：privatevoidbutton1_Click(objectsender,EventArgse){stringconnstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";OleDbConnectionconn=newOleDbConnection(connstring);stringsql="select*fromuserinfowhereuserno="+textBox1.Text;conn.Open();OleDbCommandcmd=newOleDbCommand(sql,conn);OleDbDataReaderr=cmd.ExecuteReader();if(r.Read()){richTextBox1.Text="userno："+r["userno"]+"\t";richTextBox1.Text+="username："+r["username"]+"\t\t";richTextBox1.Text+="userpasswd："+r["userpasswd"]+"\t\t";richTextBox1.Text+="useridentity："+r["useridentity"];}else{richTextBox1.Text="找不到这个学生的成绩！";}r.Close();conn.Close();}添加代码：privatevoidbutton2_Click(objectsender,EventArgse){try{stringconnstring,insertCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";insertCmd="InsertIntouserinfo(userno,username,userpasswd,useridentity)Values('"+CheckInt(textBox2.Text)+"','"+GetSqlStr(textBox4.Text)+"','"+GetSqlStr(textBox5.Text)+"','"+GetSqlStr(textBox6.Text)+"')";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(insertCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showuserinfo();MessageBox.Show("添加成功！");}catch{MessageBox.Show("添加失败！");}}修改操作代码：privatevoidbutton3_Click_1(objectsender,EventArgse){try{stringconnstring,updateCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";updateCmd="updateuserinfoSetuserno='"+CheckInt(textBox3.Text)+"',username='"+GetSqlStr(textBox7.Text)+"',userpasswd='"+GetSqlStr(textBox8.Text)+"',useridentity='"+GetSqlStr(textBox9.Text)+"'Whereusername='"+GetSqlStr(textBox7.Text)+"'";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(updateCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showuserinfo();MessageBox.Show("修改成功！");}catch{MessageBox.Show("修改失败！");}}删除操作代码privatevoidbutton4_Click(objectsender,EventArgse){try{stringconnstring,delCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";delCmd="DeleteFromuserinfoWhereusername='"+GetSqlStr(textBox10.Text)+"'";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(delCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showuserinfo();MessageBox.Show("删除成功！");}catch{MessageBox.Show("删除失败！");}4、汽车信息管理界面：公共代码：privatevoidShowcoach(){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromcoach";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"coach");dataGrid1.DataSource=myDataSet.Tables["coach"];}privatestringGetSqlStr(stringstr){returnstr.Replace("'","''");}privateintCheckInt(stringstr){try{returnint.Parse(str);}catch{return0;}}搜索代码：1、privatevoidbutton1_Click(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromcoachwherecno="+CheckInt(textBox1.Text);OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"coach1");dataGrid1.DataSource=myDataSet.Tables["coach1"];}2、privatevoidbutton5_Click_1(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromcoachwherectype='"+GetSqlStr(textBox2.Text)+"'";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"coach2");dataGrid1.DataSource=myDataSet.Tables["coach2"];}3、privatevoidbutton6_Click(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromcoachwherecnumber='"+GetSqlStr(textBox3.Text)+"'";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"coach3");dataGrid1.DataSource=myDataSet.Tables["coach3"];}4、privatevoidbutton7_Click(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromcoachwherecholder='"+GetSqlStr(textBox6.Text)+"'";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"coach6");dataGrid1.DataSource=myDataSet.Tables["coach6"];}5、privatevoidbutton8_Click(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromcoachwherectv='"+GetSqlStr(textBox4.Text)+"'";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"coach4");dataGrid1.DataSource=myDataSet.Tables["coach4"];}6、privatevoidbutton9_Click(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromcoachwhereccondition='"+GetSqlStr(textBox5.Text)+"'";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"coach5");dataGrid1.DataSource=myDataSet.Tables["coach5"];}添加操作代码：privatevoidbutton2_Click(objectsender,EventArgse){try{stringconnstring,insertCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";insertCmd="InsertIntocoach(cno,ctype,cnumber,cnum,ctv,ccondition,cholder)Values('"+CheckInt(textBox7.Text)+"','"+GetSqlStr(textBox8.Text)+"','"+GetSqlStr(textBox9.Text)+"','"+GetSqlStr(textBox13.Text)+"','"+GetSqlStr(textBox10.Text)+"','"+GetSqlStr(textBox11.Text)+"','"+GetSqlStr(textBox12.Text)+"')";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(insertCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showcoach();MessageBox.Show("添加成功！");}catch{MessageBox.Show("添加失败！");}}修改代码：privatevoidbutton3_Click(objectsender,EventArgse){try{stringconnstring,updateCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";updateCmd="updatecoachSetcno='"+CheckInt(textBox20.Text)+"',ctype='"+GetSqlStr(textBox19.Text)+"',cnumber='"+GetSqlStr(textBox18.Text)+"',cnum='"+GetSqlStr(textBox14.Text)+"',ctv='"+GetSqlStr(textBox17.Text)+"',ccondition='"+GetSqlStr(textBox16.Text)+"',cholder='"+GetSqlStr(textBox15.Text)+"'Wherectype='"+GetSqlStr(textBox19.Text)+"'";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(updateCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showcoach();MessageBox.Show("修改成功！");}catch{MessageBox.Show("修改成功！");}}删除代码：privatevoidbutton4_Click(objectsender,EventArgse){try{stringconnstring,delCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";delCmd="DeleteFromcoachWherecno="+CheckInt(textBox27.Text);OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(delCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showcoach();MessageBox.Show("删除成功！");}catch{MessageBox.Show("删除成功！");}}5、线路信息管理界面：公共代码privatevoidShowline(){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromline";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"line");dataGrid1.DataSource=myDataSet.Tables["line"];}privatestringGetSqlStr(stringstr){returnstr.Replace("'","''");}privateintCheckInt(stringstr){try{returnint.Parse(str);}catch{return0;}}搜索操作代码：privatevoidbutton1_Click(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromlinewherelstart='"+GetSqlStr(textBox2.Text)+"'andlarrival='"+GetSqlStr(textBox3.Text)+"'";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"line");dataGrid1.DataSource=myDataSet.Tables["line"];}添加代码:privatevoidbutton2_Click(objectsender,EventArgse){try{stringconnstring,insertCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";insertCmd="InsertIntoline(lno,lstart,larrival,ltime)Values('"+CheckInt(textBox6.Text)+"','"+GetSqlStr(textBox5.Text)+"','"+GetSqlStr(textBox4.Text)+"','"+GetSqlStr(textBox7.Text)+"')";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(insertCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showline();MessageBox.Show("添加成功！");}catch{MessageBox.Show("添加失败！");}}修改代码：privatevoidbutton3_Click(objectsender,EventArgse){try{stringconnstring,updateCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";updateCmd="updatelineSetlno='"+CheckInt(textBox10.Text)+"',lstart='"+GetSqlStr(textBox9.Text)+"',larrival='"+GetSqlStr(textBox8.Text)+"',ltime='"+GetSqlStr(textBox1.Text)+"'Wherelstart='"+GetSqlStr(textBox9.Text)+"'";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(updateCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showline();MessageBox.Show("修改成功！");}catch{MessageBox.Show("修改失败！");}}删除代码：privatevoidbutton4_Click(objectsender,EventArgse){try{stringconnstring,delCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";delCmd="DeleteFromlineWherelno="+CheckInt(textBox14.Text);OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(delCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showline();MessageBox.Show("删除成功！");}catch{MessageBox.Show("删除失败！");}}6、车票信息管理界面：公共代码privatevoidShowticket(){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromticket";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"ticket");dataGrid1.DataSource=myDataSet.Tables["ticket"];}privatestringGetSqlStr(stringstr){returnstr.Replace("'","''");}privateintCheckInt(stringstr){try{returnint.Parse(str);}catch{return0;}}搜索代码privatevoidbutton1_Click_1(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Selectcnumber,startcity,arrivalcity,price,soldticket,lastticket,tdate,ttimeFromticketwherestartcity='"+GetSqlStr(textBox1.Text)+"'andarrivalcity='"+GetSqlStr(textBox2.Text)+"'andcnumber='"+GetSqlStr(textBox3.Text)+"'andtdate='"+GetSqlStr(textBox4.Text)+"'";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"ticket");dataGrid1.DataSource=myDataSet.Tables["ticket"];}添加代码privatevoidbutton2_Click(objectsender,EventArgse){try{stringconnstring,insertCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";insertCmd="InsertIntoticket(tno,cnumber,startcity,arrivalcity,price,soldticket,lastticket,tdate,ttime)Values('"+CheckInt(textBox5.Text)+"','"+GetSqlStr(textBox7.Text)+"','"+GetSqlStr(textBox6.Text)+"','"+GetSqlStr(textBox21.Text)+"','"+GetSqlStr(textBox9.Text)+"','"+GetSqlStr(textBox10.Text)+"','"+GetSqlStr(textBox11.Text)+"','"+GetSqlStr(textBox8.Text)+"','"+GetSqlStr(textBox12.Text)+"')";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(insertCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showticket();MessageBox.Show("添加成功！");}catch{MessageBox.Show("添加失败！");}}修改代码privatevoidbutton3_Click(objectsender,EventArgse){try{stringconnstring,updateCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";updateCmd="updateticketSettno='"+CheckInt(textBox18.Text)+"',cnumber='"+GetSqlStr(textBox17.Text)+"',startcity='"+GetSqlStr(textBox20.Text)+"',arrivalcity='"+GetSqlStr(textBox22.Text)+"',price='"+GetSqlStr(textBox16.Text)+"',soldticket='"+GetSqlStr(textBox15.Text)+"',lastticket='"+GetSqlStr(textBox14.Text)+"',tdate='"+GetSqlStr(textBox19.Text)+"',ttime='"+GetSqlStr(textBox13.Text)+"'Wherecnumber='"+GetSqlStr(textBox17.Text)+"'";OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(updateCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showticket();MessageBox.Show("修改成功！");}catch{MessageBox.Show("修改失败！");}}删除代码privatevoidbutton4_Click(objectsender,EventArgse){try{stringconnstring,delCmd;connstring="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";delCmd="DeleteFromticketWheretno="+CheckInt(textBox26.Text);OleDbConnectionconn;OleDbCommandcmd;conn=newOleDbConnection(connstring);conn.Open();cmd=newOleDbCommand(delCmd,conn);cmd.ExecuteNonQuery();conn.Close();Showticket();MessageBox.Show("删除成功！");}catch{MessageBox.Show("删除失败！");}}8、票务管理界面：公共代码protectedDataTabletable;privatevoidShowticket(){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromticket";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"ticket");dataGrid1.DataSource=myDataSet.Tables["ticket"];}privatestringGetSqlStr(stringstr){returnstr.Replace("'","''");}privateintCheckInt(stringstr){try{returnint.Parse(str);}catch{return0;}}查询操作代码：privatevoidbutton1_Click(objectsender,EventArgse){stringconnStr,selectCmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Selecttno,startcity,arrivalcity,price,lastticket,tdate,ttime,ctv,ccondition,cholder,ltimeFromticket,coach,linewherestartcity='"+GetSqlStr(textBox1.Text)+"'andarrivalcity='"+GetSqlStr(textBox2.Text)+"'andtdate='"+GetSqlStr(textBox3.Text)+"'";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"ticket");dataGrid1.DataSource=myDataSet.Tables["ticket"];}购买操作代码：publicboolupdteticket(){boolflag=false;stringconnStr,selectCmd,updatecmd;connStr="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=Coach.mdb";selectCmd="Select*Fromticket";OleDbConnectionconn;OleDbDataAdaptermyAdapter;DataSetmyDataSet=newDataSet();conn=newOleDbConnection(connStr);myAdapter=newOleDbDataAdapter(selectCmd,conn);myAdapter.Fill(myDataSet,"ticket");