binding to data table

[Guest]

hey all,

i'm binding my datagrid to a data table (not within a dataset) and am trying
to format a column as a date, can someone please show me how to do that?

thanks,
rodchar

 

[tom pester]

It's somewhere in this gem :

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

Let me know if you have any more questions...

Cheers,
Tom Pester

 

[Chris Botha]

Here is an example to change email text into hyperlinks, your code should be
pretty much the same.

DataGrid1.DataSource = myTable
DataGrid1.DataBind()
Dim oneDataGridItem As DataGridItem
For Each oneDataGridItem In DataGrid1.Items
Dim emailText As String = oneDataGridItem.Cells(INX_EMAIL).Text.Trim()
If emailText <> "&nbsp;" Then ' Not empty
oneDataGridItem.Cells(INX_EMAIL).Text = "<a href='mailto:" & emailText
& "'>" & emailText & "</a>"
End If
Next

 

[Guest]

thanks everyone for the help.

Here is an example to change email text into hyperlinks, your code should be
pretty much the same.

DataGrid1.DataSource = myTable
DataGrid1.DataBind()
Dim oneDataGridItem As DataGridItem
For Each oneDataGridItem In DataGrid1.Items
Dim emailText As String = oneDataGridItem.Cells(INX_EMAIL).Text.Trim()
If emailText <> " " Then ' Not empty
oneDataGridItem.Cells(INX_EMAIL).Text = "<a href='mailto:" & emailText
& "'>" & emailText & "</a>"
End If
Next