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;
- }
- }
- }
沒有留言:
張貼留言