Affect the data table

Dinesh Santhalingam

I have a data table .I load it from sql .The table containing three columns .Now i want to make some change in the table.(ex)I want to change a column date time(mm/dd/yy)to dd/mm/yy format.

private void chartload()
{
datatable dt=new datatable();
//Table have some data.
List<eDetails> elist = new List<licenseDetails>();
elist = (from DataRow dr in dt.Rows
select new licenseDetails()
{
Name = dr["Name"].ToString(),
Obj= dr["obj"].ToString(),
Time=Convert.ToDateTime(dr["Time"]).ToString("dd/mm/yy H:mm")
}).ToList();
//I affect the date format
//I want to load my list to data table
}
public class eDetails
{
public string Name { get; set; }
public string Inuse { get; set; }
public string Time { get; set; }
}

I want to load my list to data table .Suggest some ideas.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

David Wood9y ago
If I'm correct in thinking that your date/time is stored as a number and the field formating is done local to the display.

Therefore if you have a database table and you are viewing the date field in the table as

mm/dd/yy

if you set the date format in the design of the new list field to

dd/mm/yy

when you design it, you only have to pass the date value, and the formatting will be done for you.
Midhun Tp9y ago
Hi,

Below code can be used to convert the datetime in your required format.

string Time = Convert.ToDateTime("12/30/2016 12:00:00 AM").ToString("dd/MM/yyyy hh:mm:ss tt");

Make sure you are getting values in correct format from datatable.
Mangesh G9y ago
Dinesh issue is that Ur datatable column is of datetime an we are not able to convert
Your converted value to datetime back

try changing the datatype of the column to the string Once if u can

an check it

Hope it Helps
Dinesh Santhalingam9y ago
Before :12/30/2016 12:00:00 AM

I want to change 30/12/2016 12:00:00 AM

@Mangesh
Mangesh G9y ago
Hey dinesh Good morning Can u post the values u r getting before going through this change
Dinesh Santhalingam9y ago
Hi mangesh,
Error populating in your suggestion,
dt.Select().ToList<DataRow>()
.ForEach(
x =>
{
x["Time"] = Convert.ToDateTime(x["Time"]).ToString("dd/mm/yy H:mm");// String was not recognized as a valid DateTime

});
dt.AcceptChanges();
I don't know how to overcome this error.
Bikesh Srivastava9y ago
I think its typecasting error,send error what you are getting.
Mangesh G9y ago
Try this

dt.Select().ToList()
.ForEach(
x =>
{
x["Time"] = Convert.ToDateTime(x["Time"]).ToString("dd/mm/yy H:mm");

});
dt.AcceptChanges();
Amit Gupta9y ago
Check below link
http://www.c-sharpcorner.com/UploadFile/1a81c5/list-to-datatable-converter-using-C-Sharp/

I could not understand behind your logic to convert the DateTime format, if you are binding with the datagrid, you can set the format there.