How to customize & show the timing in GridView

hi,

In this case RowDataBound event of grid view definately help you to resolve this issue.

Try.

First register RowDataBound event on page load

protected void Page_Load(object sender, EventArgs e)
{
  GridView1.RowDataBound += new GridViewRowEventHandler(GridView1_RowDataBound);
}

AND
void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
  if (e.Row.RowType == DataControlRowType.DataRow)
  {
  string Date = e.Row.Cells[5].Text;
  DateTime dt = new DateTime();
  DateTime.TryParse(Date, out dt);
  e.Row.Cells[5].Text = dt.ToShortTimeString();
  }
}
In above code e.Row.Cells[5].Text Replce you index. i.e. "5" is replace with your actual index of column in above code.

Hope this help.

hi,

are taking your webservice responce in datatable or dataset?

If yes then check the datatype of the column that contain date.

it might your column datatype is string so auto format is not support.

I am trying following code.

code side:

DataTable dt = new DataTable();

DataColumn dc1 = new DataColumn();
dc1.DataType = typeof(System.String);
dc1.ColumnName = "Name";
dt.Columns.Add(dc1);

DataColumn dc = new DataColumn();
dc.DataType = typeof(System.DateTime);
dc.ColumnName = "myDate";
dt.Columns.Add(dc);

DataRow dr = dt.NewRow();
dr[0] = "Jignesh";
dr[1] = DateTime.Now;

dt.Rows.Add(dr);

GridView1.DataSource = dt;
GridView1.DataBind();

Aspx side:


   
       
       
   


try and let me if you have any more query.

hope this help.

hi,

please try, following code in column tag.


   
        Text='<%# Eval("date","{0:HH:MM}") %>' asp:Label>
   


hope this help.

Im unable to get where i need to customize this. Is it possible to customize when i bind the values as follows.

<%#Eval("MenuTimeFrom")%>

Is it possible to customize Here?

Hi,

You can convert the timing as below.

DateTime dt = DateTime.Now;

String.Format("{0:t}", dt);


This will return exactly what you expect...

DateTime.Now.ToString("hh:mm tt")