二○○九~二○一○學年第二學期 2.系統分析與設計2.2窗體類型2.3流程圖身份驗證藥品信息銷售情況用戶管理空。能，是按照會員編號查詢的，把編號輸入文代碼privatevoidbutton1_Click(objectsender,EventArgse){stringcnProviderMicrosoftJetOLEDB.4.0;DataSource="+Application.StartupPath+OleDbConnectioncnnnewOleDbConnectioncn;OleDbConnectioncnnnewOleDbConnectioncn;textBoxTextOleDbCommandcomnewOleDbCommand(txt3,cnn);DataTabledtnewDataTable();OleDbDataAdapterdanewOleDbDataAdaptercomOleDbCommandBuildercbnewOleDbCommandBuilder(da);{MessageBox.Show("無此用戶,請重新輸入");}{FormmynewForm2();myShowDialog;}}4.2藥品信息插入的相關代碼privatevoidbutton3_Click(objectsender,EventArgse){StringstrSQLINSERTINTOb(藥品名稱,價格,生產批號,藥物數量,生產日期,保質期)VALUES('"+textBox1.Text+"',"+textBox2.Text+","+textBox3.Text+","+textBox4.Text+","+textBox5.Text+","+textBox6.Text+")";cebiaomdbOleDbCommandcommnewOleDbCommandstrSQL,conn);{onQuery}xceptionex{}}4.3藥品信息刪除的相關代碼privatevoidbutton2_Click(objectsender,EventArgse){CmdonnectionconnrdelCmdDeleteFrombWhere品名稱="+"'"+textBox8.Text+"'";DbCommandcmdewOleDbConnectionconnStr{cmdnewOleDbCommanddelCmdconnnQueryMessageBoxShow("刪除成功");}xceptionex{MessageBox.Show("Errorinhanding:"+ex.Message);}{}}4.4藥品信息查詢的相關代碼privatevoidbutton4_Click(objectsender,EventArgse){tronnectionconnDbCommandcmdReadermyReaderewOleDbConnectionconnStr{cmdnewOleDbCommandselectCmdconnmyReadercmdExecuteReader();{gn+++}{w}myReaderClose}xceptionex{}{}}4.5藥品信息更新的相關代碼privatevoidbutton1_Click(objectsender,EventArgse){leDbConnectionconnnewOleDbConnectionProviderMicrosoftJetOLEDBDataSourcebiao.mdb");{apternewOleDbDataAdapterdadapterSelectCommandnewOleDbCommandstrSqlconn);ewDataSetdsetidViewDataSourcedsetTables}xceptionex{}{}}4.6文本框清空的相關代碼privatevoidbutton6_Click(objectsender,EventArgse){textBox1.Text="";textBox2.Text="";textBox3.Text="";textBox4.Text="";textBox5.Text="";textBox6.Text="";textBox7.Text="";textBox8.Text="";richTextBox1.Text="";}4.7月總收入排序的相關代碼privatevoidbutton2_Click(objectsender,EventArgse){OleDbConnectionanewOleDbConnectionProviderMicrosoft.Jet.OLEDB.4.0;DatacebiaomdbstringsqlStringselectfromorderby月總收入";OleDbCommandtnewOleDbCommand(sqlString,a);DbDataReaderdrtExecuteReaderrichTextBoxText="月份\t\t月總收入\n";whiledrRead()){richTextBoxAppendText(dr["月份"]+"\t\t");richTextBoxAppendText(dr["月總收入"]+"\t\t\n");}}5.