You can still use typed dataset but the fields will come from two tables instead of just one. You can create relations between datatable within a dataset but It would not be as easy. Also, I am not sure if you can display data on the same datagrid row from two different related tables.


>So I should do that instead of using a typed dataset? Is there a way to set a relation in the dataset? Would that be a better way?
>
>Jim
>
>>The easiest would be to join both tables in a SQL to create a single data table and bind it to the grid.
>>
>>>All,
>>>
>>> I have a web application that uses a typed dataset. I want to retrieve fields from two different tables in the dataset and display them in a grid. What is the best way to do this?