14th Lecture

14th Lecture

to see all the tables from the database

command is

select * from sysobjects where type='u'

for making employee id unique and user doesnt froced to enter i t

crete table Employees(Employeeid int primary key identity,Name varchar(50),Department varchar(50))

1 create table

2 cre0te application

3 change name of the form

4 add a new form

5 design the form

6 Move to open coding window of frmEmplloyee With f7

7 declare two datamemebers int localmode and int emlpoyeeid

8 create function named startEmployee in frmEmployee class(build solution)

9 open main from > add a button>write buttons code(run burron application)

10 oppen frmemployee and write save buttoncode(run the appication)

11 open frmmain and add new button > write its code

12 open coding windw of frmemployee and write code in startemployee function

13 Run the application

14 change save button code