資源描述:
《excel數(shù)據(jù)導(dǎo)入sql數(shù)據(jù)庫方法》由會員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在應(yīng)用文檔-天天文庫。
1、Excel導(dǎo)入數(shù)據(jù)到sqlserver2010中代碼實(shí)現(xiàn):usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Data.SqlClient;usingSystem.Data.OleDb;usingSystem.Collections;usingSystem.IO;publicpartialclas
2、spageitems_excelin:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse){if(FileUpload1.HasFile==false){Page.RegisterStartupScript("","");return;//當(dāng)無文件時(shí),返回}stringIsXls=Syste
3、m.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower();if(IsXls!=".xlsx"&&IsXls!=".xls"){Page.RegisterStartupScript("","");return;//當(dāng)選擇的不是Excel文件時(shí),返回}SqlConnectioncn=SqlHelp.GetCon();cn.Open();stringstrpath=FileUpload1.PostedFi
4、le.FileName.ToString();//獲取Execle文件路徑stringfilename=FileUpload1.FileName;//獲取Execle文件名DataSetds=ExecleDs(strpath,filename);DataRow[]dr=ds.Tables[0].Select();//定義一個DataRow數(shù)組introwsnum=ds.Tables[0].Rows.Count;if(rowsnum==0){Page.RegisterStartupScript("","");//當(dāng)Excel表為空時(shí),對用戶進(jìn)行提示}else{for(inti=0;i6、('"+dr[i]["name"].ToString()+"','"+dr[i]["sex"].ToString()+"','"+dr[i]["age"].ToString()+"')";SqlCommandcmd=newSqlCommand(insertstr,cn);try{cmd.ExecuteNonQuery();}catch(Exceptionex)//捕捉異常{Page.RegisterStartupScript("","");}}else{Pa
7、ge.RegisterStartupScript("","");//若存在,將已存在用戶信息打出,并提示此用戶無法插入continue;}}Page.RegisterStartupScript("","");}cn.Close();}publicDataSetExecleDs(stringfilenameurl,stringtable){//s
8、tringstrConn="Provider=Microsoft.Jet.OleDb.4.0;"+"datasource=