下面的代码展示了如何将Excel内容显示到GridView中:
aspx代码:
.aspx
<%
@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TCQA.Web._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></head><body> <form id="form1" runat="server"> <input type="file" id="f_path" runat="server" /> <asp:Button ID="btnImport" runat="server" Text="导入" OnClick="btnImport_Click" /> <asp:GridView ID="gv_list" runat="Server" AutoGenerateColumns="true"> </asp:GridView> </form></body></html>
.cs代码:
protected
void
btnImport_Click(
object
sender, EventArgs e)
{
string Path = f_path.Value; string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection conn = new OleDbConnection(strConn); conn.Open(); string strExcel = ""; OleDbDataAdapter myCommand = null; DataSet ds = null; strExcel = "select * from [sheet1$]"; myCommand = new OleDbDataAdapter(strExcel, strConn); ds = new DataSet(); myCommand.Fill(ds, "table1"); gv_list.DataSource = ds; gv_list.DataBind();
}
扫一扫
9362
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
