VS2005 combox question

[Bob]

The scenario is that of the employees table wherein there's an EmployeeId
and a ReportsTo field in the same table. The combobox is one in a datagrid
view that lets you select an employee from the employees table to fill in
the reportsto field, but since a person can't report to himself. I'm
wondering how to exclude the EmployeeId of the selected record from the
dropdown list of the combox. Ideally I think it would be to apply a filter
to the table that fills the combobox each time a new row is selected. Does
any one have any code snippets showing how to do that?
Any help would be appreciated.

Bob

[Bart Mermuys]

Hi,

"Bob" <bd*****@sgiims .com> wrote in message
news:%2******** *******@TK2MSFT NGP10.phx.gbl.. .

The scenario is that of the employees table wherein there's an EmployeeId
and a ReportsTo field in the same table. The combobox is one in a datagrid
view that lets you select an employee from the employees table to fill in
the reportsto field, but since a person can't report to himself. I'm
wondering how to exclude the EmployeeId of the selected record from the
dropdown list of the combox. Ideally I think it would be to apply a filter
to the table that fills the combobox each time a new row is selected. Does
any one have any code snippets showing how to do that?
Any help would be appreciated.
Have a look at the DataGridView faq(A.18) at:
http://forums.microsoft.com/MSDN/Sho...52467&SiteID=1

Applying it to your case, since you have circular reference you only need
one DataTable (and TableAdapter) eg. Employee. But you need 3
BindingSource's . One BindingSource is for the DataGridView, one for the
ReportsToComboB oxColumn and another only for the ComboBoxCell currently
being edited (and filtered). It's important that only the currently editing
ComboBoxCell has a filtered BindingSource, the others need the unfiltered
BindingSource so that they can correctly paint the lookup values.

What you need on the Form is the following:

- DataSet (eg. DataSet1) with a DataTable in it (eg. "Employee" )

- EmployeeBinding Source ( DataSource = DataSet1, DataMember="Emp loyee" )
- ReportsToBindin gSource ( DataSource = DataSet1, DataMember="Emp loyee" )
- ReportsToFilter edBindingSource ( DataSource = DataSet1,
DataMember="Emp loyee" )

- EmlpoyeeDataGri dView ( DataSource = EmployeeBinding Source )
- ReportsToDataGr idViewColumn
DataSource = ReportsToBindin gSource
DisplayMember=" EmployeeName"
ValueMember="Em ployeeId"
DataPropertyNam e="ReportsTo"

Then in code you need:

Private Sub EmployeesDataGr idView_CellBegi nEdit(...) Handles ...

If (
EmlpoyeesDataGr idView.Columns( e.ColumnIndex). DataPropertyNam e="ReportsTo" )
Then

Dim editingCombo As DataGridViewCom boBoxCell = _
EmployeesDataGr idView(e.Column Index, e.RowIndex)

ReportsToFilter edBindingSource .Filter = "EmployeeId <>" + _
EmployeesDataGr idView("Employe eId", e.RowIndex).Val ue.ToString()

editingCombo.Da taSource = ReportsToFilter edBindingSource
End If
End Sub

Private Sub EmployeesDataGr idView_CellEndE dit(...) Handles ...

If (
EmlpoyeesDataGr idView.Columns( e.ColumnIndex). DataPropertyNam e="ReportsTo" )
Then
Dim editingCombo As DataGridViewCom boBoxCell = _
EmployeesDataGr idView(e.Column Index, e.RowIndex)

editingCombo.Da taSource = ReportsToBindin gSource
End If
End Sub
HTH,
Greetings


Bob

[Bob]

Thanks a lot Bart.

"Bart Mermuys" <bm************ *@hotmail.com> wrote in message
news:u4******** ******@TK2MSFTN GP09.phx.gbl...

Hi,

"Bob" <bd*****@sgiims .com> wrote in message
news:%2******** *******@TK2MSFT NGP10.phx.gbl.. .

The scenario is that of the employees table wherein there's an EmployeeId
and a ReportsTo field in the same table. The combobox is one in a
datagrid view that lets you select an employee from the employees table
to fill in the reportsto field, but since a person can't report to
himself. I'm wondering how to exclude the EmployeeId of the selected
record from the dropdown list of the combox. Ideally I think it would be
to apply a filter to the table that fills the combobox each time a new
row is selected. Does any one have any code snippets showing how to do
that?
Any help would be appreciated.

Have a look at the DataGridView faq(A.18) at:
http://forums.microsoft.com/MSDN/Sho...52467&SiteID=1

Applying it to your case, since you have circular reference you only need
one DataTable (and TableAdapter) eg. Employee. But you need 3
BindingSource's . One BindingSource is for the DataGridView, one for the
ReportsToComboB oxColumn and another only for the ComboBoxCell currently
being edited (and filtered). It's important that only the currently
editing ComboBoxCell has a filtered BindingSource, the others need the
unfiltered BindingSource so that they can correctly paint the lookup
values.

What you need on the Form is the following:

- DataSet (eg. DataSet1) with a DataTable in it (eg. "Employee" )

- EmployeeBinding Source ( DataSource = DataSet1, DataMember="Emp loyee" )
- ReportsToBindin gSource ( DataSource = DataSet1, DataMember="Emp loyee" )
- ReportsToFilter edBindingSource ( DataSource = DataSet1,
DataMember="Emp loyee" )

- EmlpoyeeDataGri dView ( DataSource = EmployeeBinding Source )
- ReportsToDataGr idViewColumn
DataSource = ReportsToBindin gSource
DisplayMember=" EmployeeName"
ValueMember="Em ployeeId"
DataPropertyNam e="ReportsTo"

Then in code you need:

Private Sub EmployeesDataGr idView_CellBegi nEdit(...) Handles ...

If (
EmlpoyeesDataGr idView.Columns( e.ColumnIndex). DataPropertyNam e="ReportsTo"
) Then

Dim editingCombo As DataGridViewCom boBoxCell = _
EmployeesDataGr idView(e.Column Index, e.RowIndex)

ReportsToFilter edBindingSource .Filter = "EmployeeId <>" + _
EmployeesDataGr idView("Employe eId", e.RowIndex).Val ue.ToString()

editingCombo.Da taSource = ReportsToFilter edBindingSource
End If
End Sub

Private Sub EmployeesDataGr idView_CellEndE dit(...) Handles ...

If (
EmlpoyeesDataGr idView.Columns( e.ColumnIndex). DataPropertyNam e="ReportsTo"
) Then
Dim editingCombo As DataGridViewCom boBoxCell = _
EmployeesDataGr idView(e.Column Index, e.RowIndex)

editingCombo.Da taSource = ReportsToBindin gSource
End If
End Sub
HTH,
Greetings

Bob