date formatting in data grid.
-
Below is the code. I want to format the date column of data grid like "13,January 1900". i know DataFromatString = "{0:d}" for bound column. I am creating column dynamically. could anyone help to solve this issue. private DataView CreateDataSourceSourceWise() { string strSQL; string connstring = HttpContext.Current.Application["connstring"].ToString(); SqlConnection readConnection = new SqlConnection(connstring); SqlDataReader dbReader = null; int nUID = Convert.ToInt32(Session["UID"]); string CaName = Request.QueryString["CategoryName"]; strSQL= "select Description,CategoryName,GroupName,GroupImage,CreatedDate from group where ((UserID= '" + nUID + "') and ( CategoryName = '" + CaName + "' ))"; SqlCommand readCommand = new SqlCommand(strSQL,readConnection); readCommand.Connection.Open(); dbReader = readCommand.ExecuteReader(); DataTable dt = new DataTable(); DataRow dr; DataView dv; if (dbReader != null) { dt.Columns.Add(new DataColumn(Request.QueryString["CategoryName"])); dt.Columns.Add(new DataColumn("Join" , typeof(string))); dt.Columns.Add(new DataColumn("Members" , typeof(string))); dt.Columns.Add(new DataColumn ("DateCreated")); while (dbReader.Read()) { dr = dt.NewRow(); StringBuilder strTop = new StringBuilder(""); strTop.Append(ShowImageNew(dbReader)); strTop.Append("
"); strTop.Append(""); strTop.Append(""); strTop.Append(Convert.ToString(dbReader["GroupName"])); strTop.Append("
"); strTop.Append(" "); strTop.Append(Convert.ToString(dbReader["Description"])); strTop.Append(""); dr[0] = strTop.ToString(); dr[1] = "
"; dr[2] ="
" + dbReader["CategoryName"].ToString() +"
"; string strlink =" []( + Convert.ToString(dbReader[)"; dr[3] ="
" + dbReader["CreatedDate"] +"
"; dt.Rows.Add(dr); } } else { Response.Write(("No Groups were created for this Category") + Request.QueryString["CategoryName"]);