Mike,
You could put a calculated field in your DataSet to handle this:
this.oData.Columns.Add("CustomerDisplay");
this.oData.Columns["CustomerDisplay"].Expression = "CustomerName + CustomerContact";
~~Bonnie
>Hello,
>
>In one instance in my application, I wanted to merge 2 fields in my combobox for display purposes, so I modified my SQL statement like so:
>
>
>SELECT Customer.*, [CustomerName]+' - '+[CustomerContact] AS CustomerDisplay FROM Customer
>
>
>I created a dataview from this table and bound my combobox to it.
>
>The question I have is did I have to do that in the SQL statement? Do Dataviews have the functionality to accomplish that?
>
>TIA,
>MAC