using?System;
using?System.Data;
using?System.Configuration;
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
{
????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）;
????????OleDbDataAdapter?odda?=?new?OleDbDataAdapter（“select?*?from?[sheet1$]“?conn）;
????????DataSet?ds?=?new?DataSet（）;
????????odda.Fill（ds?table）;
????????return?ds;
????}
????protected?void?Page_Load（object?sender?EventArgs?e）
????{

????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
?????????if?（FileUpload1.HasFile?==?false）
????????{
????????????Response.Write（“ript>alert（‘請您選擇Excel文件‘）ript>?“）;
????????????return;//當無文件時返回???????
????????}
????????string?IsXls?=?System.IO.Path.GetExtension（FileUpload1.FileName）.ToString（）.ToLower（）;
????????if?（IsXls?!=?“.xls“）
????????{
????????????Response.Write（“ript>alert（‘只可以選擇Excel文件‘）ript>“）;
????????????return;//當選擇的不是Excel文件時返回???????
????????}
????????String?serverPath?=?Server.MapPath（“~/“）?+?FileUpload1.FileName;
????????FileUpload1.SaveAs（serverPath）;
????????string?error?=?null;

????????SqlConnection?conn?=?new?SqlConnection（“Data?Source=192.168.0.47;Initial?Catalog=DB_TEST;Persist?Security?Info=True;User?ID=sa;Password=nkjyxxzx“）;
????????conn.Open（）;
????????//string?Sqlstrl?=?“?Truncate?table?wyy_news_system“;???//刪除原始表
????????//SqlCommand?comd?=?new?SqlCommand（Sqlstrl?conn）;
????????//comd.ExecuteNonQuery（）;

????????//string?strpath?=?FileUpload1.PostedFile.FileName.ToString（）;???//獲取Execle文件路徑???????
????????string?filename?=?FileUpload1.FileName;???????????????????????//獲取Execle文件名?????????
????????//DataSet?ds?=?conn.ExecleDs（strpathfilename）;
????????DataSet?ds?=?ExecleDs（serverPath?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
????????{

????????????string?news_name;
????????????string?news_content;
????????????string?news_person;
????????????string?news_hit_count;
????????????string?news_time;
????????????string?news_style;
????????????

????????????for?（int?i?=?0;?i?????????????{
????????????????news_name?=?dr[i][0].ToString（）;?????????????????????
????????????????news_content?=?dr[i][1].ToString（）;
????????????????news_person?=?dr[i][2].ToString（）;
????????????????news_hit_c

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

?????文件????????587??2016-01-11?10:19??excel-in\Default.aspx

?????文件???????4259??2016-01-11?16:09??excel-in\Default.aspx.cs

?????文件???????6292??2016-01-11?10:43??excel-in\Sys_baseInfo.txt

?????文件????????689??2015-12-28?11:56??excel-in\Web.config

?????文件??????13824??2016-01-11?16:10??excel-in\新建?Microsoft?Excel?工作表.xls

?????文件???????3196??2016-01-08?15:24??excel-out\App_Code\Class1.cs

?????文件???????1281??2015-12-11?11:08??excel-out\App_Code\Sys_Function.cs

?????文件????????743??2016-01-08?15:18??excel-out\Default.aspx.cs

?????文件????????695??2015-12-28?09:44??excel-out\web.config

?????目錄??????????0??2016-01-08?10:53??excel-out\App_Code

?????目錄??????????0??2016-01-11?16:08??excel-in

?????目錄??????????0??2016-01-08?10:46??excel-out

-----------?---------??----------?-----??----

????????????????31566????????????????????12