How to Print the data of MS Access in C#

Question

Hello I am developing one school-application. The detail is as follows: (1) I have a database(MS ACCESS) named SCHOOL (2) In that database there is one table named student_det. (3) There are 5 fields in that table which are roll_no name age addr and class. (4) Now i want to extract data from the database depending on the selection of the roll_no of the student from the front-end (5) I want to build this application in such a way that suppose programmer enter any roll_no then it will print the details of that student with School-name on the top (like-wise shopping-receipts where shop name is written on top) Please help in this. Thanks and Regards

kedar pawgi · Answer

You will have to fire a query of table school. The query will be :--- The following query need to be fired on a button click event. string qry = select * from school where roll_no=' + convert.ToInt32( textbox1.text )+ ' ; In above query textbox1 is where u r going to accept the roll no or if its combobox then replace textbox1 with combobox1. As roll_no  is integer (expected to be integer) the value from textbox or combobox need to convert to integer. For the other details like shopping-receipt u have to do the same type of query depending on ur primary key. To Display it on top u have arrange that thing into the report properly as u want. Hope this will work for u.