1.页面:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ExcelToDS.aspx.cs" Inherits="MyWebSiteTest.ExcelToDS" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Excel 导入到DataSet Demo</title>
<style type="text/css">
table{ background-color:#eee; font-size:12px; color:#666; font-family:Arial,微软雅黑;}
table tr td{ background-color:#fff; padding:4px 10px;}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<table cellpadding="0" cellspacing="1">
<tr><td colspan="2" style="color:#e26f09;"><%=TipInfo() %></td></tr>
<tr>
<td style="width:100px;"><asp:FileUpload ID="FileUpload1" runat="server" /></td>
<td>
<asp:Button runat="server" ID="btnInputExcel" Text="导入Excel" style="height:22px;" OnClick="btnInputExcel_Click" />
<asp:Button runat="server" ID="btnReloadFile" Visible="false" Text="更换附件" style="height:22px;" OnClick="btnReloadFile_Click" />
</td>
</tr>
<%=(Session["employee_entran_filename"