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.IO;
using?System.Text.Regularexpressions;
using?System.Data;
using?System.Data.OleDb;

public?partial?class?_Default?:?System.Web.UI.Page?
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{

????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????string?xlsName?=?UpXls（）;
????????if?（xlsName?!=?““）
????????{
????????????string?connstr?=?“Provider=Microsoft.Jet.OLEDB.4.0;Data?Source=“?+?Server.MapPath（xlsName）?+?“;Extended?Properties=Excel?8.0“;

????????????OleDbConnection?cn?=?new?OleDbConnection（connstr）;
????????????cn.Open（）;
????????????DataTable?dt?=?cn.GetOleDbSchemaTable（
???????????????????OleDbSchemaGuid.Tables
???????????????????new?object[]?{?null?null?null?“TABLE“?}
???????????????????）;
????????????string?sql?=?“select?*?from?[“?+?dt.Rows[0][“TABLE_NAME“]?+?“]“;

????????????DataTable?dtCard?=?new?DataTable（）;
????????????OleDbDataAdapter?ada?=?new?OleDbDataAdapter（sql?cn）;
????????????ada.Fill（dtCard）;

????????????foreach?（DataRow?r?in?dtCard.Rows）
????????????{
????????????????string?cardnumber?=?r[0].ToString（）;
????????????????string?cardPwd?=?r[1].ToString（）;
????????????????//?insert?into?card?db
????????????????//?to?do

????????????}

????????????cn.Close（）;
????????????cn.Dispose（）;

????????????//
????????????File.Delete（Server.MapPath（xlsName））;
????????}
????}

????string?UpXls（）
????{
????????//目錄
????????string?upfilePath?=?“temp“;
????????if?（Directory.Exists（Server.MapPath（upfilePath））?==?false）
????????{
????????????Directory.CreateDirectory（Server.MapPath（upfilePath））;
????????}
????????//大小
????????if?（this.File1.PostedFile.ContentLength?????????{
????????????Response.Write（“ript>alert（‘請選擇文件！‘）;ript>“）;
????????????return?““;
????????}

????????//類型
????????string?exName?=?Regex.Match（this.File1.PostedFile.FileName?@“\.[^.]+$“）.Value;
????????if?（exName?!=?“.xls“）
????????{
????????????Response.Write（“ript>alert（‘文件類型錯誤！\\r\\n只能為Excel格式！‘）;ript>“）;
????????????return?““;
????????}
????????//重名
????????string?filename?=?Guid.NewGuid（）.ToString（）?+?exName;
????????this.File1.PostedFile.SaveAs（
????????????Server.MapPath（upfilePath?+?“/“?+?filename）
????????????）;
????????return?upfilePath?+?“/“?+?filename;
????}
}

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

?????文件?????180224??2008-11-03?15:39??ExcelToDb\db.mdb

?????文件????????759??2008-11-03?15:13??ExcelToDb\Default.aspx

?????文件???????2642??2008-11-03?15:38??ExcelToDb\Default.aspx.cs

?????文件???????1546??2008-11-03?15:24??ExcelToDb\Web.Config

?????文件??????13824??2008-11-03?15:36??ka.xls

?????目錄??????????0??2008-11-03?15:08??ExcelToDb\App_Data

?????目錄??????????0??2008-11-03?15:37??ExcelToDb\temp

?????目錄??????????0??2008-11-03?15:39??ExcelToDb

?????文件?????????28??2018-12-26?10:31??版權所有.txt

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

???????????????199023????????????????????9