數(shù)據(jù)庫應(yīng)用與開發(fā)實驗報告

四、實驗過程、步驟及內(nèi)容

在之前連接好學(xué)生數(shù)據(jù)庫的窗體中加入“Excel導(dǎo)入”按鈕

寫入代碼實現(xiàn)Excel導(dǎo)入數(shù)據(jù)庫

usingSystem;

usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;

usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;

usingSystem.Windows.Forms;usingSystem.Data.OleDb;

namespaceMDI窗體

{

publicpartialclassForm4:Form

{

publicForm4()

{

InitializeComponent();

}

OleDbConnectionmycnn=newOleDbConnection();OleDbCommandCMD=newOleDbCommand();OleDbDataReaderReader;

DataSetdt=newDataSet();

OleDbDataAdapteradapter=newOleDbDataAdapter();

privatevoidbutton5_Click(objectsender,EventArgse)

{

OpenFileDialogopenfileDialog=newOpenFileDialog();openfileDialog.DefaultExt="xlsx";

openfileDialog.Filter="xlsx文件(*.xlsx)|*.xlsx|xls文件(*.xls)|*.xls|所有文件(*.*)|*.*";

if(openfileDialog.ShowDialog()!=DialogResult.OK)

{

return;

}

try

{

stringFilePath="",File_Name="";

intpos=openfileDialog.FileName.LastIndexOf("\\");FilePath=openfileDialog.FileName.Substring(0,pos);File_Name=openfileDialog.FileName.Substring(pos+1);

OleDbConnectioncon=newOleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;DataSource="+openfileDialog.FileName+@";ExtendedProperties='Excel12.0;HDR=YES'");

con.Open();

DataTabledtSheetName=con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,newobject[]{null,null,null,"Table"});

stringstrTableNames=dtSheetName.Rows[0]["TABLE_NAME"].ToString();stringdatainput="select*from["+strTableNames+"]";OleDbDataAdapteradapter=newOleDbDataAdapter(datainput,con);DataTabledt=newDataTable();

dt.Clear();adapter.Fill(dt);con.Close();con.Dispose();

dataGridView1.DataSource=dt;dataGridView1.DataSource=dt;

}

catch

{

stringsuffix="";

intpos=openfileDialog.FileName.LastIndexOf(".");suffix=openfileDialog.FileName.Substring(pos+1);suffix=suffix.ToUpper();

if(openfileDialog.FileName.IndexOf("")>=0)MessageBox.Show("文件名中不能出現(xiàn)空格，請修改");

elseif(suffix!="xlsx"&&suffix!="xls")MessageBox.Show("請確定是xls或xlsx文件，請重試");

else

MessageBox.Show("請關(guān)閉當(dāng)前文件："+openfileDialog.FileName+"，

再試");

}

}

}

}

（2）運行結(jié)果

可以導(dǎo)入Excel文件，運行成功

注：報告內(nèi)頁的項目或內(nèi)容設(shè)置，根據(jù)實際情況可加以調(diào)整和補(bǔ)充，寫不下可附一頁。

五、實驗結(jié)論：

六、指導(dǎo)教師批閱意見：

成績評定：

指導(dǎo)教師簽