Display a datagrid using the dataset as the source?

I am not sure how to display this in my report. I have dataset that queries the database to find a list of ingredients. I would like each ingredient listed in a grid. Under each individual ingredient is its amount, which is found from the database, using the Product and Ingredient name discussed above. The ingredient dataset has a list of ingredients. So I need the first one displayed in the first field, the second in the second field and so on. Then I need to ordert the Amounts Dataset properly so that the amount appears directly below the appropriate ingredient. How do you make a table cell display the first member of a dataset, then the second cell display the second and so on? Right now it is trying to display all the ingredients in one cell. I hope this makes sence. Thanks.I dont know if that makes any sence, so I found some better words to describe my problem. I have a table that I would like to transpose. This table could be long, so I only want it transposed for 5 or 5 columns, then word-wrapped to the next line so it can all fit on one page. How do you transpose a table. Is this a reporting issue, or should this be done on the Sql side? Thanks.sql

disable datagrid resize

Hi,
How to disiable the column resize event in windows data grid control
Regards
ImtiazHi
How does it relate to SQL Server? You will probably get more accurate answer
in .NET user group.
"imtiaz" <Imtiaz@.microsoft.com> wrote in message
news:eapMhB9VGHA.5668@.TK2MSFTNGP15.phx.gbl...
> Hi,
> How to disiable the column resize event in windows data grid control
> Regards
> Imtiaz
>