Question
3
Replies
154
Views
Staidlogic
Staidlogic
IN
Staidlogic
Posted: January 17, 2019
Last activity: January 18, 2019
Last activity: 18 Jan 2019 6:20 EST
Closed
Dateformat in datagridview
while exporting data from excel into datagridview .i am unable to fetch the exact date. i am attaching the same screenshot for reference.
help me resloving these problem.
Thanks®ards
Anilkumarreddy
Posted: 2 years ago
PEGA
Pegasystems Inc.
US
Are you pulling the cell value out as a string?
Posted: 2 years ago
Staidlogic
Staidlogic
IN
We are directly exporting it to Datagridview. But we are not taking it seperately as a string. How can we change its state from string to Date format?
Posted: 2 years ago
Infosys
Infosys
IN
Try by applying dateformat on columns using c# code.
dataGridView1.Columns[0].DefaultCellStyle.Format = "dd/MM/yyyy";