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
Loading
kedar pawgiPosted Feb 15, 2013, 11:02 PM
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.