结合DataGrid控件ASP.NET上传并读取Excel文件数据

最新推荐文章于 2024-09-25 11:09:10 发布

langzi588

最新推荐文章于 2024-09-25 11:09:10 发布

阅读量481

点赞数

文章标签： datagrid excel asp.net button dataset properties

本文链接：https://blog.csdn.net/langzi588/article/details/6698877

版权

 
 <%@ 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>ASP.NET上传并读取Excel中的数据</title> 
</head> 
<body> 
<form id="form1" runat="server"> 
<div> 
<input id="File1" type="file" name="File1" runat="server" /><asp:Button ID="Button1" runat="server" 
Text="Button" OnClick="Button1_Click" /> 
<asp:DataGrid ID="DataGrid1" runat="server"> 
</asp:DataGrid></div> 
</form> 
</body> 
</html>
 

后台代码：

 
 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.OracleClient; 
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 strPath = "C://Inetpub//wwwroot//ASP.NET_ExcelToOracle//" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls"; 
File1.PostedFile.SaveAs(strPath); 
string mystring = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = '" + strPath + "';Extended Properties=Excel 8.0"; 
OleDbConnection cnnxls = new OleDbConnection(mystring); 
OleDbDataAdapter myDa = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls); 
DataSet myDs = new DataSet(); 
myDa.Fill(myDs); 
DataGrid1.DataSource = myDs.Tables[0]; 
DataGrid1.DataBind(); 
} 
}
 