Re: Formatting fields on DataGrid

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You'll need to specify a BoundColumn and then set its DataFormatString, so something like this:

<asp:BoundColumn DataField="newstarttime" DataFormatString="{0:t}"></asp:BoundColumn>

Here are the docs on the format string for DateTime:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatetimeclasstostringtopic3.asp?frame=true

-Brock
DevelopMentor
http://staff.develop.com/ballen



I have a datagrid on my web form and I have populated it with the
following code:

Dim strConn As String
Dim strSQL As String
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\Test\MyDatabase.MDB;"
strSQL = "Select client, newstarttime, newendtime, ccode from
EventTable WHERE client <> '' ORDER BY client"
Dim cnn As New OleDbConnection(strConn)
Dim cmd As New OleDbDataAdapter(strSQL, strConn)
Dim ds As New DataSet
cmd.Fill(ds, "EventTable")
DataGrid1.DataSource = ds
DataGrid1.DataBind()
-----------------------------------------------
Question:  How can I format the newstarttime and the newendtime fields
to
just show time.
in the table, they are defined as Date/Time fields.

Thanks,

Gary




.

Relevant Pages