Convert datatable date to dd / mm / yyyy format in asp.net

Question

I have datatablein which I want to get the date in format dd/mm/yyyy.

I am currently getting the date as

01-01-2012 12:00:00 AM

Below is my code

strInvoice_date = dt.Rows[i]["INVOICE_DATE"].ToString();

Answer 1

Transform and then imagine how you want:

  strInvoice_date = Convert.ToDateTime(dt.Rows[i]["INVOICE_DATE"]).ToString("dd/MM/yyyy");

Answer 2

Your dt.Rows[i]["INVOICE_DATE"]retuns object, and when you call the method, ToStringit will call not .object.ToString() DateTime.ToString()

INVOICE_DATE DateTime datatable, object DateTime dd/MM/yyyy ( , ) , InvariantCulture.

var Invoice_date = (DateTime)dt.Rows[i]["INVOICE_DATE"]
                               .ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);

INVOICE_DATE string datatable, object.ToString, DateTime .

var Invoice_date = DateTime.ParseExact(dt.Rows[i]["INVOICE_DATE"].ToString(), 
                                      "dd-MM-yyyy hh:mm:ss tt", 
                                       CultureInfo.InvariantCulture)
                          .ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);

Answer 3

ToString(),

 strInvoice_date = Convert.ToDateTime(dt.Rows[i]["INVOICE_DATE"]).ToString("dd/mm/yyyy");

,

Answer 4

strInvoice_date = Convert.ToDateTime(dt.Rows[i]["INVOICE_DATE"].ToString("0:dd/MM/yyyy"));