1/2
Seat No.: Enrolment No.:
GUJARAT TECHNOLOGICAL UNIVERSITY
DIPLOMA ENGINEERING SEMESTER • EXAMINATION SUMMER 2018
Subject Code: 2360702 Date: 01-05-2018
Subject Name: Database Programming with VB.NET
Time: 10:30 AM to 01:00 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
4. Each question carry equal marks (14 marks)
Q.1

Explain different bound controls used in Windows Form.
07



07

Give the difference between ADO ADO.Net .


ADO ADO.Net

Q.2

Explain commands of SQL Server.
07


SQL
07

Describe relations between tables of SQL Server.


SQL

OR

Explain the primary key and other index.
07


Q.3

How to retrieve data using the DataReader Object.
07


DataReader Object
07

How to manipulate Data with ADO.Net.


ADO.Net

OR
Q.3

Explain How to work with Data in web forms.
07



07

Explain How to add, edit and delete Data using the Data Grid Control.




Q.4

Explain How to retrieve unique records using T-SQL Select Query.
07


T-SQL
07

Explain the Class in Visual Basic .NET.


Visual Basic .NET class

OR
2/2
Q.4

Write Data Validation Code That Can Be Reused in Other Classes.
07



07

Explain how to develop Reports Using Crystal Reports.


.

Q.5

Write a code to Select Whether the Report Will Be Displayed, Printed, or Exported Using Visual Basic .NET Code.
07


VB.Net
07

Explain how to Print Labels and Control the Order in Which Records Will Be Printed.


.

OR
Q.5

Explain how to Utilize XML Data in Your Visual Basic.NET Applications.
07


VB.Net XML
07

Explain how to Create and pass XML Web Services.


XML .