HTML:
<form id="form1" runat="server">
<div>
<asp:FileUpload ID="FileUpload1" runat="server" />
<asp:Button ID="Button1" runat="server" Text="Upload" OnClick="Button1_Click" />
<br />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
<asp:Label ID="lbl_Err" runat="server" Text="Label"></asp:Label><br />
<div runat="server" clientidmode="Static" id="DIV1">
</div>
</div>
</form>
C#:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class Test_FileUpload : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string FileFullPath = string.Empty;
DataSet ds = null;
DataTable dt = null;
File_Upload flu = new File_Upload();
flu.Set_AllowedExtension = "EXCEL";
flu.UploadXLS(FileUpload1);
ImportData imp = new ImportData();
ds = imp.GetExcelData(flu.Get_SavePath + flu.Get_FileName);
dt = ds.Tables[0];
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch (Exception ex)
{
lbl_Err.Text = ex.Message;
}
}
}
沒有留言:
張貼留言