DataGridview combobox column

[Guest]

Hi All,

have a problem working with comboxbox column with .net 2.0 (VB please)
tblEmp - EmpId, EmpName, EmpRef
tblrole - roleid, rolename
tbluserrole- empid,username,pwd,roleid

I need to create a datagidview which displays empname,username,pwd,rolename
This is ok.

But now when a user clicks on a new row, the empname and rolename columns
needs to be a combobox. The user selects the empname from the comboxbox,
assigns a username, pwd and selects the rolename from the second combobox
column.
On saving this record, the transaction would be entered in the tbluserrole.

Tried a number of help, but can't get to the solution.

is this possible? help in vb please.

 

[Otis Mukinfus]

Hi All,

have a problem working with comboxbox column with .net 2.0 (VB please)
tblEmp - EmpId, EmpName, EmpRef
tblrole - roleid, rolename
tbluserrole- empid,username,pwd,roleid

I need to create a datagidview which displays empname,username,pwd,rolename
This is ok.

But now when a user clicks on a new row, the empname and rolename columns
needs to be a combobox. The user selects the empname from the comboxbox,
assigns a username, pwd and selects the rolename from the second combobox
column.
On saving this record, the transaction would be entered in the tbluserrole.

Tried a number of help, but can't get to the solution.

is this possible? help in vb please.

You need to change the column type of those two columns to ComboBox.
When you do this you will have to populate them with the choices from
a query or some kind of list.


Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com