个人学习代码保存:例11.读取Excel文件中的数据

前台代码：Default.aspx

<%@ 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">

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server">

</asp:GridView>

</div>

</form>

</body>

</html>

后台代码：Default.aspx.cs

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;

public partial class _Default : System.Web.UI.Page

{

private static string connstr=ConfigurationManager.AppSettings["ConnectionString"].ToString();

private static string dbpath = ConfigurationManager.AppSettings["DBPATH"].ToString();

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

this.GridView1.DataSource = CreateDataSource();

this.GridView1.DataBind();

}

private DataSet CreateDataSource()

{

String ExcelDBPath = connstr + Server.MapPath(dbpath) + ";";

OleDbConnection conn = new OleDbConnection(ExcelDBPath);

OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", conn);

DataSet myDataSet = new DataSet();

myCommand.Fill(myDataSet);

return myDataSet;

}

web.config

<?xml version="1.0"?>

</appSettings>

<system.web>

posted on 2008-01-14 04:56 wangbin 阅读(272) 评论(0) 编辑收藏举报