Hi Tom,
I would suggest you to populate a datatable from the
resultset. Loop thru the datatable and set the the
repeating row/column to null string.
After which, this datatable can be set as the
datasource to the datagrid to obtain the data in the
format u require.
Bye,
Keerthy
--- Tom <[EMAIL PROTECTED]> wrote:
>
>
> I have to admit I am notice at ASP.NET though I have
> been doing some
> cool staff.
> I am writting because I need support in something
> that some of you
> might define as really easy..
>
> I am creating a dynamic webpage in ASP.NET in VB
> linked to an access
> database. The links with the database is
> perfect, I can use datalist, datagrid and
> dataitem.container...
>
> The problem I have is a way to display the info I
> get from the
> database.
>
> I have two tables
>
> Product
> -----------
> Product_id Name_P
> 1 P1
> 2 P2
>
>
> Sub_Product
> ------------------
> Product_id Name_SP Sub_Product_id
> 1 SP1 1
> 1 SP2 2
> 1 SP3 3
> 2 SP4 4
> 2 SP5 5
>
> The two tables are linked in a Access Query where it
> should take all
> the
> subproducts.product_id=product.product.id that are
> equal to
>
> Query:menu_query
> Sub Product Product
> ------------------
> -------------
> Product_id ------------------------
> Product_id
> Name_SP Name_P
> Sub_Product_id
>
>
> In ASP I have not problems to display them like this
>
> P1 SP1
> P1 SP2
> P1 SP3...
> P2 SP4.... and so on...
>
> What I want to achieve is a grouping by, and it
> should display like
> this
>
>
> P1
> SP1
> SP2
> SP3
> P2
> SP4
> SP5
>
>
> I have tried to use the nesting of datagrid in a
> datagrid, though it
> does not give me the level of flexebility I want in
> the design of
> the webpage.
>
> Do you have a piece of code to share that should
> work
> I can share the all aspx file and mdb file as well
> if it helps
>
> thanks
> Tom
>
>
>
>
>
>
>
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
