本文同步发布在博客园 http://www.cnblogs.com/zk09/articles/1868304.html
页面HTML代码:
<%@ page language="C#" autoeventwireup="true" codefile="Default.aspx.cs" inherits="_Default" %>
<!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 数据导入 数据库</title>
<script type="text/javascript" src="js/jquery-1.4.2.min.js"></script>
<script type="text/javascript">
$(function(){
$("#"+"<%=btnImport.ClientID %>").click(function(){
var fileName = $("#"+"<%=excelFile.ClientID %>").val();
if(fileName==""){
alert("请选择Excel文件!");
return false;
}
else{
var extension = fileName.substring(fileName.lastIndexOf('.')+1);
if(extension!="xlsx"&&extension!="xls"){
alert("上传的文件不是Excel文件,请重试!");
return false;
}
}
return true;
});
});
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<fieldset>
<legend>数据导入:</legend>
<table>
<tr>
<td style="width: 182px">
数据Excel:</td>
<td>
<asp:fileupload id="excelFile" runat="server" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:button id="btnImport" runat="server" text="导入" οnclick="btnImport_Click" />
<input id="btnCancel" type="button" value="取消" οnclick='window.location.href="Default.aspx"' /></td>
</tr>
</table>
</fieldset>
</div>
<div id="errorDiv" runat="server">
<fieldset>
<legend>错误信息:</legend>
<textarea id="errorArea" runat="server" style="width: 722px; height: 88px"></textarea>
</fieldset>
</div>
<div id="confrimDiv" runat="server">
<fieldset>
<legend>导入确认:</legend>
<asp:gridview id="GVConfirm" runat="server" cssclass="grid">
</asp:gridview>
<div id="buttonDiv" runat="server" visible="false">
<asp:button id="btnConfirm" runat="server" text="确定" οnclick="btnConfirm_Click" />
<input id="btnNotConfirm" type="button" value="取消" οnclick='window.location.href="Default.aspx"' />
</div>
</fieldset>
</div>
</form>
</body>
</html>
C# 代码 :