Is it possible to create a dataview on a dataset which combines
(concatonates) two columns into one without having to copy the dataset into
another dataset?
I have two columns that I generally need to be seperate... but I have a need
to databind this dataset to a combo box and display a concatonated version
of the two columns in the GUI... is there a way to do this with a databound
combobox to a dataset?
Thanks,
Extreme
eXtreme - 30 Jun 2005 01:47 GMT
Found the answer:
Dim dc As DataColumn
dc = New DataColumn("FullName",GetType(System.String))
dc.Expression = "FirstName + ':' +LastName"
dataSet.Tables("customers").Columns.Add(dc).
> Is it possible to create a dataview on a dataset which combines
> (concatonates) two columns into one without having to copy the dataset
[quoted text clipped - 7 lines]
> Thanks,
> Extreme