473,320 Members | 1,926 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Customizing a data view / Response.Write

What is the desired way to deliver a customized view of a database query?
The scenario is that I want to group records based on similar fields. Can I
use any built in data controls and achieve this level of customization? I
can accomplish my custom view via Response.Write, but this can't be the way
to go, for no other reason than it dumps out HTML prior to the <HTML> tag.
For example:

The data:

MAINGROUP SUBGROUP RECNO

--------- -------- -----

Dogs Labrador 1000

Dogs Labrador 1001

Dogs Labrador 1002

Dogs Schnauzer 1003

Dogs Schnauzer 1004

Dogs Poodle 1005

Mouse Mickey 1006

Cats Siamese 1007

Cats Siamese 1008

Cats Siberian 1009

Cats Siberian 1010

Desired View:

Animal Breed Details

------ ----- -------

Dogs Labrador 1000, 1001, 1002

Schnauzer 1003, 1004

Poodle 1005

Mouse Mickey 1006

Cats Siamese 1007, 1008

Siberian 1009, 1010

Thanks for any advice.

Brian
Nov 18 '05 #1
1 1364
Why not create a new datatable in the dataset, loop through the datatable
you got and insert summary rows into new datatable, then bind the new
datatable to DataGrid, DataList,......

"anony" <no**@m.com> wrote in message
news:qq*********************@twister.tampabay.rr.c om...
What is the desired way to deliver a customized view of a database query?
The scenario is that I want to group records based on similar fields. Can I use any built in data controls and achieve this level of customization? I
can accomplish my custom view via Response.Write, but this can't be the way to go, for no other reason than it dumps out HTML prior to the <HTML> tag.
For example:

The data:

MAINGROUP SUBGROUP RECNO

--------- -------- -----

Dogs Labrador 1000

Dogs Labrador 1001

Dogs Labrador 1002

Dogs Schnauzer 1003

Dogs Schnauzer 1004

Dogs Poodle 1005

Mouse Mickey 1006

Cats Siamese 1007

Cats Siamese 1008

Cats Siberian 1009

Cats Siberian 1010

Desired View:

Animal Breed Details

------ ----- -------

Dogs Labrador 1000, 1001, 1002

Schnauzer 1003, 1004

Poodle 1005

Mouse Mickey 1006

Cats Siamese 1007, 1008

Siberian 1009, 1010

Thanks for any advice.

Brian

Nov 18 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Jason | last post by:
Sorry for the post here but could not find an Exchange newgroup. I developed an application a year or 2 ago that sends SMTP email. The application allows the user to customize the text from...
12
by: pmud | last post by:
Hi, I am using teh following code for sorting the data grid but it doesnt work. I have set the auto generate columns to false. & set the sort expression for each field as the anme of that...
1
by: anony | last post by:
What is the desired way to deliver a customized view of a database query? The scenario is that I want to group records based on similar fields. Can I use any built in data controls and achieve...
4
by: Wayne P. | last post by:
I'm working on a shopping cart webapp and I need to perform a form POST of data to a 3rd party site (a payment processor, StormPay). I seem to be having problems doing this. I have an image...
5
by: Vishal | last post by:
Hello, I already asked this question in the ASP.NET forums, but no help came. So I am hoping that somebody can help me out. This is really very URGENT me. For my e-commerce application, I...
3
by: Nick | last post by:
Hi there, I'm hunting around for some kind of example on how to customize the largeicons view of a listview control, I would like to draw each item myself if possible, is it possible to owner...
4
by: Matt | last post by:
I have the following in a page and I am trying to update a record on the next page but for some reason the form data is not carrying over. Any ideas why? <form name=nxtlupdate method=post...
2
by: irishdudeinusa | last post by:
Hello Everyone, I have been working a webservice where I can use it in other applications that I am working on. However, I am running into a problem with the data returned and I was wondering if...
2
by: thecoolone | last post by:
I am trying to implement the yahoo search api using php. I prefer to use PHP serialized to get the result of the search displayed. Right now i get the output like: Array ( =Array ( =web ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.