Comments by Member 14760154 (Top 20 by date)

Schedule Time_in Time_out Finger_in
2020-04-18 22:00:00.0000000 08:00:00.0000000 2020-04-18 21:36:23.613
Finger_out Min(finger_in) Max(finger_in)
2020-04-18 21:36:23.613 2020-04-18 21:36:23.613 NULL

i also try this,but always return false , although i have select the list

I think i have found the problem, the servers not installed office yet,

but i found i new problem , I think i can't convert xls into xlsx using interop excel.

Does any other way to convert xls into xlsx?

I am sorry ,actually i just copied the wrong code ,
i have changed the code into (for int i=1;i

Actually ,my problem is I want to insert schedule into my database by using excel ,because it will be taken long time if i use form to insert it ,

but sometimes i write wrong datetime format , and its make an error ,

now i try to solve it , i will validate my data before inserted to database,

I wish ,when i have 1 row error and 4 not error, all row would not inserted to database ,

but my current condition after change it is ,when i row error it failed to insert to database ,but another 4 rows is successfully inserted to database

for some problem ,it works ,but it cause another problem ,

protected void check(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
string[] arr = new String[15];
string filename = "Hr_Report_" + DateTime.Now.ToString("dddd_dd_MMMM_yyyy") + ".xls";
FileUpload1.SaveAs(temp_file + filename);
string tempfile = temp_file + filename;
string finalfile = final + "final.xls";
string c = @tempfile;
string b = @finalfile;
DataTable table = new DataTable();
FileInfo existingFile = new FileInfo(tempfile); //+ FileUpload1.FileName);
using (ExcelPackage package = new ExcelPackage(existingFile))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[1];
int colCount = worksheet.Dimension.End.Column;
int rowCount = worksheet.Dimension.End.Row;
table.Columns.Add("emp_fullname", typeof(DateTime));
table.Columns.Add("emp_nik", typeof(string));
table.Columns.Add("Timer_Finger", typeof(string));
bool chValidity =true;
for (int i = 1; i < rowCount && chValidity==true; i++)
{
DateTime d;
chValidity = DateTime.TryParseExact(
worksheet.Cells[i + 1, 1].Value.ToString(),
"MM/dd/yyyy h:mm:ss",
CultureInfo.InvariantCulture,
DateTimeStyles.None,
out d);
if (chValidity == false)
{
TableRow row = new TableRow();
TableCell cell1 = new TableCell();
cell1.Text = worksheet.Cells[i + 1, 1].Value.ToString() + " " + worksheet.Cells[i + 1, 2].Value.ToString() + " " + worksheet.Cells[i + 1, 2].Value.ToString() + " Baris ke " + i;
row.Cells.Add(cell1);
myTable.Rows.Add(row);
File.AppendAllText("E:\\test.txt", label1.Text);
}
}
if (chValidity == true)
{
label1.Text = "suskses";
}
}
}
else
{
Response.Write("window.alert('File Belum diupload')");
}
}

i have tried it,it return true also ,

when i remove "ch_validity==true" in the "for" statement

now the problem is ,its break and only insert the first false row , the next row that was false not inserted into the table ,

Can you help me ,solve this ?

I wish like this
15/10/2020 Wrong at line 2
16/10/2020 Wrong at line 3
16/10/2020 Wrong at line 6

and my program show this
15/10/2020 Wrong at line 2

i have try like this,
but it's still does not work

this is my updated code


function reload() {
//Session["LogedUserID"] = null;
window.location = "../Login.aspx";
Session.Abandon();
//document.cookie.split(";").forEach(function (c) {
//document.cookie = c.replace(/^ +/, "").replace(/=.*/, "=;expires=" + new Date().toUTCString() + ";path=/");
//});
}

yes i do,

i wish i can union them,

Actually my problem is ,i want to merge data from database and data from an excel file,
and then i will sort them ,

i get data from database using store procedure ,
and data from excel i get using eppplus

This is my sample data
001600063 2020-04-14 10:54:45.147
001800081 2020-04-14 10:54:36.540
001800081 2020-04-14 10:54:10.440
001600063 2020-04-13 23:40:10.223
001800081 2020-04-13 11:33:57.000
this is from database sql server

this is second data
001800082 4/14/2020 11:01:52 AM
001600063 4/14/2020 11:02:01 AM
this is from excel file

actually i want to merge both data and sort them ,