Click here to Skip to main content
15,899,659 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have two table in database one for centre registered and another one for it's payment, let's say I have three centre and each one of these might have any no.of payment records or rows for each centre. I want to print the each payment records just below it's centre.

For example..

Centre1 details
Payment detail row 1 for centre 1
Payment detail row 2 for centre 1

Centre2 details

Payment details for centre 2
Payment row for centre 2 and so on....


Technology used.. Asp. Net vb and ms sql server

What I have tried:

I have print both the tables data using stringbuilder
But separately.

For example...
All the centre table details

All the payment table for each centre given above
Posted
Updated 30-Apr-22 2:49am
Comments
Richard MacCutchan 30-Apr-22 9:09am    
What exactly is the problem? You start by getting the centre details from the database, and follw that with a request for all payment records.

While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
 
Share this answer
 
I am not looking for a complete solution here, I would make a fool out of me if I did that, I am possibly looking for just a hind, that's all, I have been in this industry for a little while and I know quite well how it works so it's okay if any one can help in community else I would be fine either way, I beg your pardon in case my question was not explained well or I am kinda new to asking questions on community. Next time I will make myself crystal clear...

Thanks again for all the help and concern
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900