using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;
using?System.Data.OleDb;
using?System.Data.SqlClient;

public?partial?class?_Default?:?System.Web.UI.Page
{
????string?strConn?=?“Data?Source=MICROSOF-4ACCF3;Database=BaoBiao;Uid=sa;Pwd=123“;?//鏈接SQL數據庫
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????SqlConnection?cn?=?new?SqlConnection（strConn）;
????????cn.Open（）;
????????SqlDataAdapter?sda?=?new?SqlDataAdapter（“select?*?from?baobiao“?cn）;//表
????????DataSet?ds?=?new?DataSet（）;
????????sda.Fill（ds?“baobiao“）;
????????this.GridView1.DataSource?=?ds.Tables[“baobiao“];
????????this.GridView1.DataKeyNames?=?new?string[]?{?“ASID“?};//
????????this.GridView1.DataBind（）;

????}
????///?

????///?查詢EXCEL電子表格添加到DATASET
???///?

????///?服務器路徑
????///?表名
????///?
????///?
????///?
????
????public?DataSet?ExecleDs（string?filenameurl?string?table）
????{
????????string?strConn?=?“Provider=Microsoft.Jet.OleDb.4.0;“?+?“data?source=“?+?filenameurl?+?“;Extended?Properties=‘Excel?8.0;?HDR=YES;?IMEX=1‘“;
????????OleDbConnection?conn?=?new?OleDbConnection（strConn）;
????????conn.Open（）;
????????DataSet?ds?=?new?DataSet（）;
????????OleDbDataAdapter?odda?=?new?OleDbDataAdapter（“select?*?from?[Sheet1$]“?conn）;
????????odda.Fill（ds?table）;
????????return?ds;
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
?????????if?（FileUpload1.HasFile?==?false）//HasFile用來檢查FileUpload是否有指定文件
???????{
????????????Response.Write（“ript>alert（‘請您選擇Excel文件‘）ript>?“）;
????????????return;//當無文件時返回
??????}
??????string?IsXls=System.IO.Path.GetExtension（FileUpload1.FileName）.ToString（）.ToLower（）;//System.IO.Path.GetExtension獲得文件的擴展名
???????if?（IsXls?!=?“.xls“?）??//檢查格式是否為.xls
???????{
???????????Response.Write（“ript>alert（‘只可以選擇Excel文件‘）ript>“）;
????????????return;//當選擇的不是Excel文件時返回
???????}
????????SqlConnection?cn?=?new?SqlConnection（strConn）;?
????????cn.Open（）;
????????string?filename?=?DateTime.Now.ToString（“yyyymmddhhMMss“）?+?FileUpload1.FileName;??????????????//獲取Execle文件名??DateTime日期函數
????????string?savePath?=?Server.MapPath（（“~\\upfiles\\“）?+?filename）;//Server.MapPath?獲得虛擬服務器相對路徑
?????????FileUpload1.SaveAs（savePath）;????????????????????????//SaveAs?將上傳的文件內容保存在服務器上
?????????DataSet?ds?=?ExecleDs（savePath?filename）;???????????//調用自定義方法
????????DataRow[]?dr?=?ds.Tables[0].Select（）;????????????//定義一個DataRow數組
???????int?rowsnum?=?ds.Tables[0].Rows.Count;
????????if?（rowsnum?==?0）?????????????????????????????????
????????{
????????????Response.Write（“ript>alert（‘Excel表為空表無數據!‘）ript>“）;???//當Excel表為空時對用戶進行提示
????????}
????????else
??????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????2293760??2011-08-19?12:17??Excel2sql\App_Code\BaoBiao.mdf

?????文件?????573440??2011-08-19?12:18??Excel2sql\App_Code\BaoBiao_log.LDF

?????文件????1835008??2011-08-19?12:17??Excel2sql\App_Data\hhaspx_Data.MDF

?????文件????1048576??2011-08-19?12:17??Excel2sql\App_Data\hhaspx_Log.LDF

?????文件????2293760??2011-08-19?12:17??Excel2sql\BaoBiao.mdf

?????文件?????573440??2011-08-19?12:17??Excel2sql\BaoBiao_log.LDF

?????文件???????1458??2011-08-19?12:17??Excel2sql\Default.aspx

?????文件???????5805??2011-08-19?12:17??Excel2sql\Default.aspx.cs

?????文件???????1570??2011-08-19?12:17??Excel2sql\Excel導入.sln

????..A..H.?????11264??2011-08-19?12:19??Excel2sql\Excel導入.suo

?????文件???????4945??2011-08-19?12:18??Excel2sql\from.gif

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20090806100752工資表1.xls

?????文件??????25600??2011-08-19?12:18??Excel2sql\upfiles\20091906100706保興國.xls

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20091906100719工資表1.xls

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20092006100702工資表1.xls

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20092006100737工資表1.xls

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20092506110728工資表1.xls

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20092706100717工資表1.xls

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20092913080721工資表.xls

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20093106100709工資表1.xls

?????文件??????13824??2011-08-19?12:18??Excel2sql\upfiles\20093513080719工資表.xls

?????文件??????19456??2011-08-19?12:18??Excel2sql\upfiles\20110218070806航班.xls

?????文件??????17920??2011-08-19?12:18??Excel2sql\upfiles\20110719120858復件?復件?航班.xls

?????文件??????17920??2011-08-19?12:18??Excel2sql\upfiles\20110819120850復件?復件?復件?航班.xls

?????文件??????17408??2011-08-19?12:18??Excel2sql\upfiles\20111019120856復件?航班.xls

?????文件??????17408??2011-08-19?12:18??Excel2sql\upfiles\20111119120846復件?航班.xls

?????文件??????19456??2011-08-19?12:18??Excel2sql\upfiles\20111218070816航班.xls

?????文件??????17408??2011-08-19?12:18??Excel2sql\upfiles\20111419110809復件?航班.xls

?????文件??????19456??2011-08-19?12:18??Excel2sql\upfiles\20111518070845航班.xls

?????文件??????19456??2011-08-19?12:18??Excel2sql\upfiles\20111718070853航班.xls

............此處省略38個文件信息