**Button click:** protected void btnUploadExcelFiles_Click(object sender, EventArgs e) { string[] strFiles = Directory.GetFiles(strPath); foreach (string strFile in strFiles) { ClsExcelUpload objExcelUpload = new ClsExcelUpload(); string szConnectionString1 = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + strFile + "';Extended Properties=\"Excel 12.0;HDR=YES;\""; objExcelUpload.ReadExcel(szConnectionString1, strFile); } } **function ReadExcel:** public string ReadExcel(string szConnectionString, string strFile) { OleDbConnection objConn = new OleDbConnection(); objConn.ConnectionString = szConnectionString; objConn.Open(); OleDbDataAdapter DAobjBasicInfo = new OleDbDataAdapter(); DAobjBasicInfo = new OleDbDataAdapter("select * from [Sheet1$]", objConn); DataTable dt1 = new DataTable(); DAobjBasicInfo.Fill(dt1); objConn.Close(); objConn.Dispose(); return ""; }
foreach (string strFile in strFiles) { ClsExcelUpload objExcelUpload = new ClsExcelUpload(); string szConnectionString1 = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + strFile + "';Extended Properties=\"Excel 12.0;HDR=YES;\""; objExcelUpload.ReadExcel(szConnectionString1, strFile); }
foreach (string strFile in strFiles) { ClsExcelUpload objExcelUpload = new ClsExcelUpload(); string szConnectionString1 = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + strFile + "';Extended Properties=\"Excel 12.0;HDR=YES;\""; objExcelUpload.ReadExcel(szConnectionString1, strFile); // Presumably something else happens here objExcelUpload = null; GC.Collect(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)