第八次实验报告

1、usingusingusing System.Data;using System.Linq; using System.Text;using System.Data.OleDb;namespace publicpartialclassForm1:publicOleDbConnectionDatabase1=newOleDbConnection(); mand CMD = newOleDbDataReader Reader; DataSetdt=newOleDbDataAdapteradapter=newprivate void der, EventArgs mandText = select

2、Sno,Sname,Ssex,Smaj from students where +sno.Text+if (t != null)mandText= updatestudentsset Sno=+ sno.Text+,Sname +sname.Text+,Ssex=+sex.Text+,Smaj=+smaj.Text+whereSno=+sno.Text+; mandText=selectSno,Sname,Ssex,Smajfromstudents; mand = CMD;adapter.Fill(dt, students); adapter.Fill(dt, students); mandT

3、ext = inserto studento,Sname,Ssex,Smaj) values ( + sno.Text + , + sname.Text + , + sex.Text + , + smaj.Text + );mandText=selectSno,Sname,Ssex,SmajfromstudentswhereSnolike % + textBox1.Text + % order by Sno;adapter.Fill(dt, students);private void der, EventArgs /if (cb2.Text = 学号mandText=selectSno,Sn

4、ame,Ssexm,Smajfromstudentswhere Sno like % + textBox1.Text + %order by Sno;/elseif(cb2.Text=mandText=selectSno,Sname,Ssexm,Smajfromstudentswhere Sname like % + textBox1.Text + %order by Sname;mandText = select Sno,Sname,Ssex,Smaj from students where + cb2.Text + like % + textBox1.Text + %order by +c

5、b2.Text+;adapter.Fill(dt, students);privatevoidsno.Text = dataGridView1Sno, e.RowIndex.Value.ToString(); sno.Text = dataGridView1Sno, e.RowIndex.Value.ToString(); sex.Text = dataGridView1Ssex, e.RowIndex.Value.ToString(); smaj.Text = dataGridView1Smaj, e.RowIndex.Value.ToString();private void der, E

6、ventArgs mandText=deletefromstudentswhereSno=+sno.Text+; mand = CMD;adapter.Fill(dt, students); private void der, EventArgs OpenFileDialogopenfileDialognewOpenFileDialog(); openfileDialog.DefaultExt = xls;/默认为 xls 格式openfileDialog.Filter = xls 文件(*.xls)|*.xls|xlsx 文件(*.xlsx)|*.xlsx|if (openfileDialo

7、g.ShowDialog() != stringFilePath=,File_Name= openfileDialog.FileName.LastIndexOf(); FilePath = openfileDialog.FileName.Substring(0,File_Name = openfileDialog.FileName.Substring(openfileDialog.FileName + ;Extended Properties=Excel 4.0;HDR=YES);con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,newobjectn

8、ull,null,null,Tablestring datainput = select * from + strTableNames + ; OleDbDataAdapter adapter = new OleDbDataAdapter(datainput, con);able dt = new DadataGridView1.DataSource = stringsuffix=openfileDialog.FileName.LastIndexOf(.); suffix=openfileDialog.FileName.Substring( +1); suffix = suffix.ToUpper();if (openfileDialog.FileName.IndexO