Reputation: 67
I have dataset with a table Temp, and i want to change the format of a DateTime field. Is there any direct method to do that.
myDataSet->Tables->Item["Temp"]->Columns->Item["DateTimeColumnName"]
this is the column, Temp is the table and how can i achieve this? i want to do it in Ado.net.
Upvotes: 0
Views: 253
Reputation: 1054
Try this..
foreach (DataRow row in myDataSet.Tables[0].Rows)
{
row["UrDateColumn"]= DateTime.Parse(String.Format("{0}:dd-MM-yyyy",dr["UrDateColumn"]));
}
Upvotes: 1