Hi Paul,

Thanks for posting in the group.

Based on the description, the quesiton is: how to show datetime format as
MM/DD/YYYY in datagrids, right?

Could you please let me know which type of application you are working on
now, asp.net web form application or a windows form application?

For a web form application, you can set datetime format like:
In the property builder screen for the grid.
In the Columns tab.
In the select columns box, highlight your date field.
Then enter, {0:d/M/yyyy}, in the data formatting expression box.
There you go no more time in your date column.

you can also try:
Modify the format of the date while the data is being bound to your control.

private void myDataGrid_ItemDataBound(object sender,
System.Web.UI.WebControls.DataGridItemEventArgs e)
{
   // Get the data item and make sure it is a non-null object
   DataRowView drv = (DataRowView) e.Item.DataItem;
   if (drv == null)
       return;

   DateTime dt = Convert.ToDateTime(drv["MyDate"].ToString());
   e.Item.Cells[yourCellIndex].Text = dt.ToString("MM/dd/yyyy");  //You
can try out different formats here.
}

If it is a windows forms applicaiton, you need to create a column style.  
Column style is an object that defines what the column looks and behaves
like, including such things as color, font, and the presence of controls,
such as check boxes. The .NET Framework includes two types of column-style
classes by default: the DataGridTextBoxColumn and DataGridBoolColumn
classes. In this case, you need to customize a style class by inheriting
the class DataGridTextBoxColumn.

Hope that helps.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ?C www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.