Import Excel Data using FileUpload Control To Database using AJAX jQuery

Question

How to extract excel data to Database with upload using ajax Jquery because I dont the page to load And I dont want to use Update Panel thanks

AnandM · Accepted Answer

Hi zzzI have created a sample which full fill your requirement taking reference of below articlesRead and Import Excel data to DataTable using ClosedXml in ASPNet with C and VBNet Upload multiple files with Progress Bar using Flash in ASPNetFilePathcspublic static class FilePath     ltsummarygt     Gets or sets FilePath     ltsummarygt    public static string FilePathDetail  get set Defaultaspxltdivgt    ltaspFileUpload ID34FileUpload134 runat34server34 gt    ltbr gt    ltaspButton ID34btnDisplay34 Text34Display34 runat34server34 gt    ltbr gt    ltbr gt    lttable id34tblExcel34gt    lttablegtltdivgtltdivgt    ltlink rel34Stylesheet34 type34textcss34 href34CSSuploadifycss34 gt    ltscript type34textjavascript34 src39httpajaxaspnetcdncomajaxjQueryjquery183minjs39gtltscriptgt    ltscript type34t

Import Excel Data using FileUpload Control To Database using AJAX jQuery

Company

Explore

Follow us

Contact Us