473,729 Members | 2,309 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Displaying data in tabular format in asp from database

34 New Member
Hello,
I have to display all the data from the database in tables in ASP. I am able to get the data but the problem is of displaying one to many relations.Like below Title1 has two records but how would i display in the table
Title1 heading1 heading 2 heading 3
x y x1 y1
a b a1 b1

Tite2 heading1 heading 2 heading 3
x y x1 y1
a b a1 b1

My loop is getting all the data together. I don't know hoe to seperate that

Could any one help with this.

Many thanks,
Teju
May 31 '07 #1
2 2387
jhardman
3,406 Recognized Expert Specialist
Hello,
I have to display all the data from the database in tables in ASP. I am able to get the data but the problem is of displaying one to many relations.Like below Title1 has two records but how would i display in the table
Title1 heading1 heading 2 heading 3
x y x1 y1
a b a1 b1

Tite2 heading1 heading 2 heading 3
x y x1 y1
a b a1 b1

My loop is getting all the data together. I don't know hoe to seperate that

Could any one help with this.

Many thanks,
Teju
I'm not sure I got you exactly. I once had to display a long list of works written by different authors. The authors were in one table and the works in another. So essentially I had a list of authors, and under each was a table of their works. Is this something similar to what you want? How is your db table set up? Is it more than one table?

Jared
May 31 '07 #2
teju
34 New Member
Hello,
Actually, I wanted to display one to many relationship data on the ASP page. SO that it shouldn't display the duplicate titles.

I got it from asp faq web

Thanks for your help
Jun 1 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
1334
by: Joo Park | last post by:
Hello, i have an aspx page that displays data in tabular format. I'd like to change this page so that it outputs that same data into excel format. what needs to change in an aspx page to do that? thx in advance!
2
1321
by: t | last post by:
Hi, I have the following problem. The web-based software I am to create is going to display tabular data. Lots of data so I need some pagging mechanism. I thought about creating three classes: GridView (displayng tabular data), PaggingControl (displaying and buttons) and DataSource (for retrieving data from the db. In the database I have following data: id | column1 | column2 -------------------------------------
1
1726
by: kunu601 | last post by:
hi my self uttam . i am working in r & d organization . friends i need a he lp from u . if any one of u know how add two sections(consisting of caption, header, footer ) be displayed on the same data page in ms access 2003 or 2005.i tried to display two tables on the data page in tabular format but i could not do it. it is allowing to display one table but it is not allowing to display the other table separately in tabular format . i...
13
2899
by: David W. Fenton | last post by:
I've been struggling the last two days with something I thought was very easy, which is to open a web page with a form on it and populate the form with data passed in a query string (either POST or GET). I got Application.FollowHyperlink *kind* of working, but was having problem with double encoding of some characters (I had to do special things with + signs in the data, as well as never figuring out why some data was getting...
3
5725
by: maylee21 | last post by:
hi, anyone can help me figure out how to read data from a text file like this: 10980012907200228082002 and extract the data according to this kind of format: Record type 1 TY-RECORD PIC (1). ID-PARTICIPANT PIC (6).
2
2188
by: NasirMunir | last post by:
I have created a table in access (copied from excel). Then I created a form which contains a text field and a list box. The text field is actually a look-up field, where a user can enter a searchable text and the results are displayed in the list box(the search is done on the table which I copied from excel). Everything works fine as I want. The problem: I cannot copy the results from that list box to the excel sheet. It just copies the first...
38
3290
by: Sanders Kaufman | last post by:
I'm converting my table-based layouts to css-positioned divs - but the ONLY reason I'm doing it is because it's *considered* a best practice. I don't really see where anything goes hinky when tables are used - but I'm doing it anyway because the HTML and CSS specs says to reserve tables for tabular data. So as I convert my login widgit to a css thing, I'm saying to myself - hey, this form is most certainly "tabular data" - even if it...
3
2219
scubak1w1
by: scubak1w1 | last post by:
Hello, I am wanting a "pretty output" of tabular data generated on the fly and saved in an array (PHP)... That is, I have a link so users can chart (JpGraph) and download (CSV) tabular data, based on their selections on a query web page and using PHP, etc to pull the data out of a PostgreSQL database. I have been requested to make ('on the fly') a 'reporting quality' version of the CSV available for download - sort of like you might get...
4
6267
by: jeet123 | last post by:
hi, i am new to c#. How can i make a form which displays data in a tabular format where the data is retrieved from the database (ms-access) and displayed in that from in table. No matter if the table data is editable or not but yes, the user must be able to print that data. if we can add this feature of if the records displayed exceeds the paper size i.e A4 size paper then the next records should come on next page. i'll be thankful if anybody...
0
9281
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9200
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9142
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8148
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6722
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4525
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4795
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2680
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2163
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.