Populate DataGrid Dynamically

[scabral79]

Hi,

i need to populate a datagrid dynamically based on data from a stored procedure that is stored locally using dataadapter.

the issue i am having is that the stored procedure uses a parameter and based on the parameter a different set of fields is returned.

How do i populate or build the datagrid based on the different fields that are returned? do i need to build multiple datagrids based on the different result sets or is there a way to build it dynamically?

thanks
Scott

 

[ethorn10]

set the AutoGenerateColumns="true" in the datagrid.

<asp:DataGrid ID="foo" AutoGenerateColumns="true">
</asp:DataGrid>