asp.net VB grouping datalist or datagrid results

[riprod7]

I have a database table with the following :
fabricname | Grade | Category

I need it to list like this :

Category1 Grade A
fabricname 1
fabricname 2
fabricname 3

Category1 Grade B
fabricname 1
fabricname 2
fabricname 3

Category2 Grade A
fabricname 1
fabricname 2
fabricname 3

Etc. Etc.

classic ASP, this would be very easy but in ASP.NET, I have no idea.
Everything on google seams to be done with Visual Studio and I don't know if Dreamweaver is too limiting to do that sort of stuff and if I need to switch to Visual Studio

Any pointers ?

[Newsgroup_User]

There's an example here:

http://aspnet101.com/aspnet101/tutorials.aspx?id=8

--
Jules
http://www.charon.co.uk/products.aspx
Charon Cart
Ecommerce for ASP/ASP.NET

[riprod7]

I actually found that tutorial before but it is not what I need. In that example, they have 2 different tables. Categories and Products. I only have 1 table that looks like this :

Category1 | Grade A | fabricname1
Category1 | Grade A | fabricname2
Category1 | Grade A | fabricname3
Category1 | Grade B | fabricname4
Category1 | Grade B | fabricname5
Category2 | Grade A | fabricname6
Category2 | Grade B | fabricname6
etc. etc.

You really think that there would be a simple way to group this list. I'm considering changing my whole project from ASP.NET back to classic ASP.

Also that tutorial just errors out anyway... you get the error "BC30269: Method 'Page_Load' has multiple definitions with identical signatures." I don't think it works with Dreamweaver.

[Newsgroup_User]

Whatever solution you use, you'd have to create a view. Something like

select Category,Grade from myTable group by Category,Grade

So, in effect, you'd then have 2 tables.

--
Jules
http://www.charon.co.uk/products.aspx
Charon Cart
Ecommerce for ASP/ASP.NET


"riprod7" <webforumsuser@macromedia.com> wrote in message
news:fji912$h3d$1@forums.macromedia.com...
>I actually found that tutorial before but it is not what I need. In that
> example, they have 2 different tables. Categories and Products. I only
> have 1
> table that looks like this :
>
> Category1 | Grade A | fabricname1
> Category1 | Grade A | fabricname2
> Category1 | Grade A | fabricname3
> Category1 | Grade B | fabricname4
> Category1 | Grade B | fabricname5
> Category2 | Grade A | fabricname6
> Category2 | Grade B | fabricname6
> etc. etc.
>
> You really think that there would be a simple way to group this list. I'm
> considering changing my whole project from ASP.NET back to classic ASP.
>
>

[riprod7]

Sorry Jules, I've tried for 2 days with the tutorial you pointed me to but it just doesn't work. Error after error.
I don't think it works with dreamweaver or maybe was created in something else.

Anyone know of any dreamweaver sample code or tutorials for this. It seams like it should be a very common thing. You would like it would be a function built into datalist or repeat region.

Maybe there is an extension ?
I have downloaded a trial of Visual Studio to see if that can do it.