Formatting fields on DataGrid

[Gary Paris]

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

[Brock Allen]

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/de...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