Create multiple pdf file as Marksheet of 1000 students

Question

I create a Marksheet table. marksheet_tb where more than 100 students mark details is stored. I want to generate pdf file of these 100 students individually as Marksheet. Please help me.

Prakash Mondal · Answer

Hi Thivagar, I have a marksheet entry form (C# Windows Form) and already entered all details. Another Windows Form is there where a "Generate Marksheet" button. I want to generate individually pdf file of Marksheet in a single click. suppose, reg_no academic_year slno com_pk sub1 sub2 sub3 sub4 total average grade STU12 2018 1 STU12/2018/1 80 92 84 82 338 84.5 A STU13 2018 1 STU13/2018/1 84 90 90 88 352 88 A this is the marksheet_tb table. where more than 100 students is there. I want to generate individually marksheet file format is pdf. like that for registration no STU123, his marksheet pdf file name is STU12_2018_1.pdf Do you help me?

Thivagar Segar · Answer

Hi Prakash, i hope you are trying to do the above requirement in ASP.NET, if so then you can create a search page first where the students can give the register number to view the result and on second page you can use the databse query likse select * from marksheet_tb where reg_no = 'Textbox.Text ' and with the help of SQLReader you can fetch the data's from SQL and display in the second page. Ref: https://stackoverflow.com/questions/16565035/how-do-i-get-values-from-a-sql-database-into-textboxes-using-c