Anil Singh | Code-sample.com

DataTable Sheets = connectionString.GetOleDbSchemaTable( OleDbSchemaGuid .Tables, null ); foreach ( DataRow dr in Sheets.Rows) {     string sheetStr = dr[2].ToString().Replace( "'" , "" );     OleDbDataAdapter dataAdapter = new OleDbDataAdapter ( "select * from [" + sheetStr + "]" , connectionString);     var ds = new DataSet ();     dataAdapter.Fill(ds, "DataTable" );     DataTable data = ds.Tables[ "DataTable" ];     if (ds.Tables[ "DataTable" ]. Rows.Count > 0)     {         GetSetUploadExcelData(uploadExl, data, CompanyID, TenantID);     } }