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"));                
        }
    }
}