Jim,

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

I've been staying away from questions about grids and asp.net, since I've not used either, but this is also a data question, so maybe I can answer at least that part of it. <g> You *can* add a table to your typed DataSet and fill it from a SP . You can also set relations in your DataSet, but that is something that I haven't messed around with yet, so I can't give you any specifics.

Anyway, not much help I know.

~~Bonnie


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