Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > format table in datagrid ? (0/1)

Reply
Thread Tools

format table in datagrid ? (0/1)

 
 
Sam --
Guest
Posts: n/a
 
      07-15-2004
hi all
first sorry for my bad english

I've a trouble.
I've a query like
SELECT au_id, title_id, au_ord, royaltyper
FROM titleauthor
WHERE (title_id IN ('TC7777', 'PS2091', 'BU1111', 'PS1372'))
ORDER BY title_id
)


au_id title_id au_ord royaltyper
267-41-2394 BU1111 2 40
724-80-9391 BU1111 1 60
724-80-9391 PS1372 2 25
756-30-7391 PS1372 1 75
899-46-2035 PS2091 2 50
998-72-3567 PS2091 1 50
267-41-2394 TC7777 2 30
472-27-2349 TC7777 3 30
672-71-3249 TC7777 1 40


I would have to format the table in a datagrid (I do not know if this
is the control more adapted for my scope) grouping for fields (in this
case title_id) so that me what of the type comes one

au_id au_ord royaltyper
BU1111
267-41-2394 2 40
724-80-9391 1 60
PS1372
724-80-9391 2 25
756-30-7391 1 75
PS2091
899-46-2035 2 50
998-72-3567 1 50
TC7777
267-41-2394 2 30
472-27-2349 3 30
672-71-3249 1 40

thanks
sam--





 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table/table rows/table data tag question? Rio HTML 4 11-05-2004 08:11 AM
Script to format existing Access table into wall calendar format? Lee Falataco ASP General 2 08-10-2004 01:42 AM
Re: format table in datagrid ? (1/1) Mike Smith ASP .Net 1 07-16-2004 05:43 AM
Re: format table in datagrid ? (1/1) MattC ASP .Net 1 07-16-2004 05:43 AM
Could not load type VTFixup Table from assembly Invalid token in v-table fix-up table. David Williams ASP .Net 2 08-12-2003 07:55 AM



Advertisments