I am pretty sure you can but never tried it myself with SP.
>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?
- Jayesh