Building Database App With Vb?

I am trying to write simple database application and try to understand ADO.net as well.say I have 2 table

1. table emp with the following field (empId, empName, empPhone, salary, deptId)

2. table dept with the following field (deptId, deptName, deptLocation, deptManager)

emp table is link to dept table via deptId.so I try to build a form with 2 data grids the top will be dept data grid and below it is emp data grid.I try to do this with out using the wizard so I know the flow and understand how to link together step by step.

in the form load section:

dim conn as new system.data.sqlclient.sqlconnection(connectionString)
dim daEmp as system.data.sqlclient.sqldataadapter
dim daDept as system.data.sqlclient.sqldataadapter

[code]....

I am kind of stuck on what to do next, I think the next step is to creat dataview from my understanding before mapping it to the datagrid, but on data grid documentation it say it can only filter datarow, it can't filter data column on the dataview.

I would like to be able to display deptName, deptLocation, no the whole column on the table to data grid, and when user select a record from dept datagrid then the employee info (empname, empphone, empsalary) is display on the second grid (again not the whole emp column table).

the user can update, add or delete emp record from employee data grid by clicing on update button, on update button callback routine I need to put something like.

daEmp.update()

from what my understanding then I need to create update, insert and delete routine and attach it to daEmp so the data grid know how to sync with sql server, so when the user say add new record since the data grid doesn't have all the field display, i.e deptId column is not on data grid, how the table know what the dept id would be? I'd like to learn without the wizard 1st since once I know how everything is link then it is easier to debug since the wizard create lots of file and it's everywhere which make it very hard to understand what is happening for someone new to vb & ado.