Hi Rex,
Couldn't you create your select statement to be executed on the backend that will be create a new DataTable to use to bind to? DataSets are not made to generate select statements using the DataTable contained in it. You need to do that all in the backend.
>All,
>
>In my web application I have 3 tables, EducationalActivities, EducationProviders, and EducationalActivitiesEducationProvidersXRef. As the names may tell you, the XRef is a cross reference table between the Activities and the Providers. I need to display the information as follows:
>
>
> _____ Provider #1
>
> _____ Provider #2
>
> _____ Provider #3
>
> _____ Provider #4
>
> _____ Provider #5
>
> _____ Provider #6
>
>
>With the underscores being text boxes to hold the count for each Provider.
>
>How can I do this?
>
>TIA
>
>Rex
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi