Bind columns to different tables in a dataset

[Karthik]

Hi,

Great tool.

I have a dataset that contains multiple tables. I want to display the data in the grid view with each column possibly referring to data in different table in the dataset. Appreciate if you let me know how I can do this?

I have the xml representation of the dataset below. I would like to display the grid view with eachrow as follows

WinServNo, ServiceName, CultureID, DisplayName, Description, Created Date, Startuptype

<?xml version="1.0" standalone="yes"?>
<root>
  <ws>
    <WinServNo>3</WinServNo>
    <ServiceName>aec</ServiceName>
    <wst>
      <CultureId>1033</CultureId>
      <DisplayName>Microsoft Kernel Acoustic Echo Canceller</DisplayName>
      <Description />
      <dws>
        <DeviceNo>22</DeviceNo>
        <StartupType>3</StartupType>
        <CreateDate>2007-04-27T04:21:00</CreateDate>
      </dws>
    </wst>
  </ws>
  <ws>
    <WinServNo>4</WinServNo>
    <ServiceName>AeLookupSvc</ServiceName>
    <wst>
      <CultureId>1033</CultureId>
      <DisplayName>Application Experience Lookup Service</DisplayName>
      <Description>Processes application compatibility lookup requests for applications as they are launched.</Description>
      <dws>
        <DeviceNo>22</DeviceNo>
        <StartupType>2</StartupType>
        <CreateDate>2007-04-27T04:21:00</CreateDate>
      </dws>
    </wst>
  </ws>
  </root>

Thanks,
Karthik

[Julian Benkov]

Hello Karthik,

First you should create a DataTable with the needed columns (WinServNo, ServiceName, CultureID, DisplayName, Description, Created Date, Startuptype) and populate it with data from your dataset. After that set the DataSource property to reference the created table.
I hope this helps.

 
Sincerely yours,
Julian Benkov
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center