2013年6月5日 星期三

C# Excel to GridView

[C#]Excel to GridView

HTML:
  1. <form id="form1" runat="server">
  2. <div>
  3. <asp:FileUpload ID="FileUpload1" runat="server" />
  4. <asp:Button ID="Button1" runat="server" Text="Upload" OnClick="Button1_Click" />
  5. <br />
  6. <asp:GridView ID="GridView1" runat="server">
  7. </asp:GridView>
  8. <asp:Label ID="lbl_Err" runat="server" Text="Label"></asp:Label><br />
  9. <div runat="server" clientidmode="Static" id="DIV1">
  10. </div>
  11. </div>
  12. </form>

C#:
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data;
  8.  
  9. public partial class Test_FileUpload : System.Web.UI.Page
  10. {
  11. protected void Page_Load(object sender, EventArgs e)
  12. {
  13. }
  14. protected void Button1_Click(object sender, EventArgs e)
  15. {
  16. try
  17. {
  18. string FileFullPath = string.Empty;
  19. DataSet ds = null;
  20. DataTable dt = null;
  21.  
  22. File_Upload flu = new File_Upload();
  23. flu.Set_AllowedExtension = "EXCEL";
  24. flu.UploadXLS(FileUpload1);
  25. ImportData imp = new ImportData();
  26. ds = imp.GetExcelData(flu.Get_SavePath + flu.Get_FileName);
  27. dt = ds.Tables[0];
  28. GridView1.DataSource = dt;
  29. GridView1.DataBind();
  30. }
  31. catch (Exception ex)
  32. {
  33. lbl_Err.Text = ex.Message;
  34. }
  35. }
  36. }

沒有留言:

張貼留言