Krivahn Doss

Krivahn Doss

  • NA
  • 33
  • 0

Windows DataGridView

Sep 9 2008 8:08 AM

Windows DataGridView

Table1: Terminal
Fields: TerminalID, TerminalName
Data: 1, DF
2, ADL
3, FG

Table2: Employee
Fields: EmpID,EmpName
Data: 1, Johan
2, Piet

Table3: EmpTerminal
Fields: EmpID, TerminalID, TimeAttendence, Access
Data: 1, 2, true, false
3, 2, false, false

On the form is all the details of an employee filtered by empID.
I would like to show a DataGridview with all the terminals. If a EmpTeminal exist for that employee I want to show the data in the grid view & if the employee does not have any terminals then I want to inter data to the EmpTerminal for that employee. A user can Activate or deactivate (TimeAttendence, Access) EmpTerminals for a specific employee.