hi Team, the below pic shows date which i am gett

Question

Please help me out. The below pic shows that date i am getting from DB in string format. Now i want to change it into date. bcz after downloading the excel. I am unable to change the formatted cells to date format. i shown in below pic. now i am changing into this format. unable to change. Please help me out.

Jignesh Kumar · Answer

Hi, Convert your colunm using below code, DateTime.ParseExact( "YourDateColumn" , "dd/MM/yyyy" , null ); Or If if you have SQL query then you can convert at query level also like below select convert ( varchar , "YourDateColumn" , 103)

Vinay Singh · Answer

Hi chekc the below code. dr [ "birth_day" ]= DateTime . Parse ( String . Format ( "{0}:dd.MM.yyyy" , dr [ "birth_day" ])); This will help to convert the datatable value date field.

Rajanikant Hawaldar · Answer

OK, in downloading function your are passing datatable or dataset object so easily you can change date format in datatable or dataset only.https://stackoverflow.com/questions/1182362/formatting-datetime-column-in-a-dataset https://forums.asp.net/t/1451309.aspx?Changing+the+dateformat+in+the+dataset+column+whihc+is+of+DateTime+datatype https://stackoverflow.com/questions/39046827/convert-datetime-in-datarow-to-a-formatted-date-string https://www.c-sharpcorner.com/forums/set-data-type-mmddyyyy-for-data-table-column

sankeerth m · Answer

Thanks team

sankeerth m · Answer

System.FormatException: String was not recognized as a valid DateTime. at System.DateTimeParse.ParseExact(String s, String format, DateTimeFormatInfo dtfi, DateTimeStyles style) at System.DateTime.ParseExact(String s, String format, IFormatProvider provider)

sankeerth m · Answer

System.ArgumentException: String was not recognized as a valid DateTime.Couldn't store in G9 BIS Date Column. Expected type is DateTime. ---> i have this way. getting above error DataTable dttable = DataTools.GetData(DataTools.getConfigurationstring("MySql"), rawQuery + ";"); DataTable dt = new DataTable(); foreach (DataColumn col in dttable.Columns) { if (col.DataType == typeof(string)) { dt.Columns.Add(col.ColumnName, typeof(DateTime)); dt.ImportRow(dttable.Rows[1]); } }

Rajanikant Hawaldar · Answer

OK, in downloading function your are passing datatable or dataset object so easily you can change date format in datatable or dataset only.