Softex IT Solutions Aug.2013 | Page 33

Page no:33 Database Programming Using DAO a. Display all records of Emp table in text boxes. b. Create an application to Add, Delete, Modify employees (using code) c. Display all the records of employees working in deptno 20. d. Display all the records in Grid. e. Create an application using Visual Data Manager. Using ADO a. Create an application, to scroll through the database records. use DSN with ADO Control. b. Write the same application using code. c. Write an application for book entry, i. That allows entering new book details like book name, author, publication, edition, price etc., will generate bookid auto. Adds the records in db ii. After selecting name of author display all the books with details having the same author. iii. Display the book details as per the price range entered by user. iv. Display all book details in MSFlex grid. Create proper reports using Data/Crystal reports. Note: All the assignments are mentioned using Visual Basic as the front end tool. Institutes may use any other front-end tool as per availa ???????((