I have a calculated column called "Display" in a DataTable called
"MyTable".
The Display column is three columns concatenated onto each other.
They are iID, cTitle, dtCreationDate.
Is there a way to calculate the Display column so Creation date starts
at the same place, or in other words, to pad the Title column.
For example right now in my ListBox it shows:
1234 Title of 1234 08/20/03
4321 Long Title of 4321 08/20/03
and I would like it to look like:
1234 Title of 1234 08/20/03
4321 Long Title of 4321 08/20/03
The code I have to calculate the Display column is this:
m_dstPlans.Tables("Plans").Columns.Add("Display", GetType(String), _
"iID + ' ' + cTitle + ' ' + dtCreationDate")
|