Get multiple datatable from objectdatasource

Last post 12-19-2006 2:10 PM by purell. 2 replies.

Sort Posts:

  • Get multiple datatable from objectdatasource

    12-18-2006, 5:35 PM
    • Member
      534 point Member
    • purell
    • Member since 06-29-2006, 10:17 PM
    • Posts 206

    Dim

    dt As datatable = ctype(objSelectWS.Select(),DataView).ToTable()

    The objectdatasource will return back a dataset.  3 datatables are attached to that dataset.

    How do I retrieve let's say datatable(2)?


  • Re: Get multiple datatable from objectdatasource

    12-19-2006, 8:45 AM
    Answer
    • All-Star
      86,764 point All-Star
    • ecbruck
    • Member since 12-30-2005, 7:39 PM
    • Des Moines, IA
    • Posts 9,209
    • Moderator
    From looking at the documentation, if a DataSet is returned, only the first DataTable of the DataSet is extracted from which the DataView is created.
    Thanks, Ed

    Microsoft MVP - ASP/ASP.NET

  • Re: Get multiple datatable from objectdatasource

    12-19-2006, 2:10 PM
    • Member
      534 point Member
    • purell
    • Member since 06-29-2006, 10:17 PM
    • Posts 206
    Too bad. They should of made it more flexible.
Page 1 of 1 (3 items)