The EntitySpaces Community

Share and learn about the EntitySpaces Architecture.
Welcome to The EntitySpaces Community Sign in | Join | Help
in
Home Forums Photos

Loop through columns in esdatasource entity

Last post 03-06-2008, 1:29 PM by ryansalt. 1 replies.
Sort Posts: Previous Next
  •  03-06-2008, 1:20 PM 8288

    Loop through columns in esdatasource entity

    Hi

    I'm trying to implement filtering by column on a Telerik Radgrid, using esdatasource and following the example code below:

     

    Code:
    ds = GetDataSet("SELECT Country, City, Address FROM Customers")
    Dim dataColumn As DataColumn
    For Each dataColumn In ds.Tables(0).Columns
    Dim gridColumn As New MyCustomFilteringColumn()
    Me.RadGrid1.MasterTableView.Columns.Add(gridColumn)
    gridColumn.DataField = dataColumn.ColumnName
    gridColumn.HeaderText = dataColumn.ColumnName
    Next dataColumn

    How does this translate to looping through the underlying datatable columns in an ES collection (coll) instead of a dataset? I thought that this would work, but apparently not:

     

    Code:
    For Each dataColumn In coll.es.Meta.Columns
     

     

  •  03-06-2008, 1:29 PM 8289 in reply to 8288

    Re: Loop through columns in esdatasource entity

    Answered my own question almost as soon as i'd posted!

     

    Code:
    Dim dataColumn As EntitySpaces.Interfaces.esColumnMetadata
        For Each dataColumn In coll.es.Meta.Columns
            Dim gridColumn As New MyCustomFilteringColumn()
    	Me.RadGrid1.MasterTableView.Columns.Add(gridColumn)
    	    gridColumn.DataField = dataColumn.Alias
    	    gridColumn.HeaderText = dataColumn.Alias
        Next dataColumn
     
View as RSS news feed in XML