CIST $2342$

C# Programming II

LAB HS $(60$ Points$)$

DB Access

In this Lab we are going to access a Database.

The database has $4$ tables that we are

interested in: the Instructor Trable and the

Shident Table, the Course Table and the

Section Table.

Part

$1.)$ Inpur Course from Datmbase and

Diptay AyxixCD$)$: Add anew Function to

your Conseclass, Call this function

seleciDE$($int cid$).$ This function will take only

one argument. This argument will be the

ConseID. In the function you are to use this

ConseID to search the database for the other

information about this Course, fike

coursename, cte. To test this out, use the

Course Button on your form Object. Change

the code behind the Course bution. See code

below:

To Selcets

Course c$1$;

c$1=$new Course$()$:

c$1.$selectDB$(\text{'}$CIST $1220\text{'})$;

c$1.$display$($:

II you should see data from the database

for Course "CIST $1220".$

$2.)$ Invur Sections from the Dotobase and

your Section class. Call this function

seleciDE$($int cm