Could I create a table in the typed dataset with the fields I want and then fill that table from a stored procedure?

Jim

>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?