<asp:Button ID="btndwn" runat="server" Text="Download Excel" OnClick="btndwn_Click" /> <asp:FileUpload ID="fleupld" runat="server" /> <asp:Button ID="btnupld" runat="server" Text="Upload Excel" OnClick="btnupld_Click" />
strDirectoryName = fleupld.PostedFile.FileName; strFileName = fleupld.FileName; strFullDirectoryName = dirInfo.FullName + "\\" + strFileName; fleupld.PostedFile.SaveAs(strFullDirectoryName); sConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" + dirInfo.FullName + " ;Extended Properties=\"Text;HDR=YES;FMT=Delimited\""; objConn = new OleDbConnection(sConnectionString); objConn.Open();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)