Concatenating DataColumn

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Job Lot

    Concatenating DataColumn

    How can I concatenate values of two data columns and show the concatenated
    value in the third column. I am using a XML file which contains data and I am
    using DataSet’s ReadXml method to populate DataSet.

    I want FirstName and LastName column to show as one column containing full
    name. for eg. “Shane” “Warne” as “Shane Warne”

    Thanks
  • Ben Strackany

    #2
    Re: Concatenating DataColumn

    You could add a Column and set the Expression property to "FirstName + ' ' +
    LastName"

    --
    Ben Strackany
    DevelopmentNow is an award-winning creative software development agency integrating mobile, web, hardware, mixed reality, and emerging technology.


    <a href="http://www.development now.com">dn</a>


    "Job Lot" <JobLot@discuss ions.microsoft. com> wrote in message
    news:47285655-C968-4F29-BF3E-B4093D689848@mi crosoft.com...[color=blue]
    > How can I concatenate values of two data columns and show the concatenated
    > value in the third column. I am using a XML file which contains data and I[/color]
    am[color=blue]
    > using DataSet's ReadXml method to populate DataSet.
    >
    > I want FirstName and LastName column to show as one column containing full
    > name. for eg. "Shane" "Warne" as "Shane Warne"
    >
    > Thanks[/color]


    Comment

    Working...