C# พี่ครับ เราจะกำหนด รูปแบบของวันที่ ตอน select ได้ไหมครับ ??

this.lbl2.Text = (string)dt.Rows[0]["workdate"].ToString("MMM ddd d");

DateTime dt = DateTime.ParseExact(dateString, "ddMMyyyy", 
                                  CultureInfo.InvariantCulture);
dt.ToString("yyyyMMdd");

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;


namespace Project56
{
    public partial class detailBoss3 : System.Web.UI.Page
    {   
        SqlConnection objConn = new SqlConnection();
        SqlCommand objCmd = new SqlCommand();
        String strConnString, strSQL;
        protected void Page_Load(object sender, EventArgs e)
        {
             strConnString = "Server=localhost;Uid=sa;PASSWORD=12345;database=mydatabase;Max Pool Size=400;Connect Timeout=600;";
            objConn = new SqlConnection(strConnString);
            objConn.Open();

            if (!Page.IsPostBack)
            {
                ViewData();
            }
        }
        protected void ViewData()
        {
            SqlDataAdapter dtAdapter;
            DataTable dt = new DataTable();
            strSQL = "SELECT * FROM totalWork WHERE workID = '" + Request.QueryString["workID"] + "' ";
            dtAdapter = new SqlDataAdapter(strSQL, objConn);
            dtAdapter.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                this.lbl0.Text = (string)dt.Rows[0]["workID"].ToString();
                this.lbl1.Text = (string)dt.Rows[0]["workName"].ToString();
                this.lbl2.Text = (string)dt.Rows[0]["workdate"].ToString();
                this.lbl3.Text = (string)dt.Rows[0]["worktime"].ToString();
                this.lbl4.Text = (string)dt.Rows[0]["worktime2"].ToString();
                this.lbl5.Text = (string)dt.Rows[0]["worklocation"].ToString();
                this.lbl7.Text = (string)dt.Rows[0]["workdetail"].ToString();

            }

        }
    }
     
}

this.lbl2.Text = dt.Rows[0]["workdate"].ToString("MMM ddd d");

this.lbl2.Text = dt.Rows[0]["workdate"].Value.ToString("MMM ddd d");