private void OpenFileDialog1_FileOk(object sender, CancelEventArgs e)
{
SFeedingGrid.Refresh();
var xlConn = string.Empty;
xlConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + openFileDialog1.FileName + ";Extended Properties=\"Excel 12.0;\";";
using (var myCommand = new OleDbDataAdapter("SELECT MonthYear,EmpCode,EmpName,EmpDW,EmpPH,EmpEL,EmpCL,EmpSL,EmpPymtMode FROM [Sheet1$]", xlConn))
{
myCommand.Fill(dt);
SFeedingGrid.DataSource = dt;
SFeedingGridView.BestFitColumns();
}
}
private void OpenFileDialog1_FileOk(object sender, CancelEventArgs e)
{
SFeedingGrid.Refresh();
var xlConn = string.Empty;
xlConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + openFileDialog1.FileName + ";Extended Properties=\"Excel 12.0;\";";
using (var myCommand = new OleDbDataAdapter("SELECT EmpPartyCode,AccName,UnitCode,UnitName, EmpCode,EmpName,EmpFHRelationTag,EmpFHName,EmpDeptCode,DeptDesc,EmpDesgCode,DesgDesc,EmpDOJ,EmpPFno,EmpUANNo,EmpBasic,EmpHRA,EmpConv,EmpPET,EmpSplAlw,EmpTDS,EmpMscD1,EmpPanNo,EmpAdharCardNo,EmpBankIFSCode,EmpBankAcNo,EmpDOB,PFTAG,FPFTAG,ESITAG FROM[Sheet1$]", xlConn))
{
myCommand.Fill(dt);
SFeedingGrid.DataSource = dt;
SFeedingGridView.BestFitColumns();
}
}
