How to print multiple records of sql

Question

0.00/5 (No votes)

See more:

Hello,
I am having a webpage which contains a print button. when I click on print button the student ID no. is passed to print.aspx page. In this page I have a form with some text boxes. Whenever this id no. is passed all these text boxes filled from a database( all fields related to that ID no.)
Instead of id no., I wil pass class name like (VIIth standard). then all the records should be printed one after another.(For example: this VII standard contain 20 students) then I need to print twenty pages. I wil put two buttons in print.aspx page (Back, Next).
Kindly help me in this regard to print multiple pages at a time(using C#.net) with code.

Thanks in advance for taking pain for me

Posted 9-Mar-13 1:34am

2012programmer

Add a Solution

Comments

Sushil Mate 9-Mar-13 8:48am

Start with step by step tutorial of C#, ASP.NET & SQL. All the best.

Maciej Los 10-Mar-13 8:21am

Not clear. Please, be more specific and provide more details (example).
What have you done till now?
What do you mean "print 20 pages"? Do you want to print student details for each student in a class?
Have you seen similar questions: http://www.codeproject.com/Questions/351577/How-to-print-in-asp-net [^]

2012programmer 11-Mar-13 13:12pm

I have an application form, in this form there is some static content and dynamic content available. This dynamic content will be changed based on database records. For each row of a table in database one page should be published. " Print 20 pages means If there are 20 rows in that table then 20 pages should be printed. Like Mail merge feature in MS-Word, some content is static and some content is dynamic but when we publish this static content is repeated for each record. Thank you.

armie340 13-Mar-13 0:31am

visit this site-->http://www.sqlines.com/articles/sql-server/select_into_when_multiple_rows

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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