Run this code
HTML
Order Date of OrderId 10248 =
<asp:Label ID="lblOrderDate" runat="server" />
Namespace
using System.Configuration;
using System.Data.SqlClient;
using System.Globalization;
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.PopulateOrderDate();
}
}
private void PopulateOrderDate()
{
string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT OrderDate FROM Orders WHERE OrderID = 10248", conn))
{
conn.Open();
object orderDate = cmd.ExecuteScalar();
conn.Close();
DateTime enUS = Convert.ToDateTime(orderDate, new CultureInfo("en-US"));
this.lblOrderDate.Text = enUS.ToString("dd/MM/yyyy", new CultureInfo("en-GB"));
}
}
}