Asp.net Forum

Ask Question   UnAnswered
Home » Forum » Asp.net       RSS Feeds

databind several table

  Asked By: Craig    Date: Jun 04    Category: Asp.net    Views: 1376

i have data set with 3 tables.
(same table with 3 queries)
can i bind all of them into datagrid?



2 Answers Found

Answer #1    Answered By: Logan Bouchard     Answered On: Jun 04

Well DataSet is more like 3 dimensional object compared to datagrid  which is 2d like. In order to get the data  from all 3 tables  into te same datagrid I'd use DataView on those and try assemble all data to be presenred in a single datagrid. Could do that in the first place and have one table  with all data and use DataViews to look at it with different criteria. Just use union all on all 3 tables with dataview and you will have all info for your datagrid to display. Not sure you can BIND them directly thou. Just don't see how.

Answer #2    Answered By: Aidyn Smith     Answered On: Jun 04

There is no binding between different tables  via DataSet object for viewing purposes. You can only filter and sort them via DataViews and regarding to parent table's data.
I would also like to have DataSet capability like SQL Query to join tables and get out exactly what I want, which would BTW be also VERY VERY fast, while all data  resides in-memory. Like DataSet Query. No Procedures or any of the other other SQL capabilities, but only pure SELECTING, DELETING, INSERTING, UPDATING and DROPING.

Didn't find what you were looking for? Find more on databind several table Or get search suggestion and latest updates.