Gis wrote:
> Hello, I'm trying to bind table Employee already on a dataset DsName. But
> Employee references to other tables PersonnelGroup and PersonnelStatus. I
> want cbobox cboName only to show Employees whose Status = 'Current' and Group
> = 'ATBDE'
> Here's part of the code:
>
> Dim employeePersonnelGroupRel As DataRelation =
> DsName.Relations.Add(DsName.Tables("PersonnelGroup").Columns("PersonnelGroupID"), _
> DsName.Tables("Employee").Columns("PersonnelGroupID"))
>
> Dim employeePersonnelStatusRel As DataRelation =
> DsName.Relations.Add(DsName.Tables("PersonnelStatus").Columns("PersonnelStatusID"), _
> DsName.Tables("Employee").Columns("PersonnelStatusID"))
>
> ' para cboName
>
> cboName.ValueMember = "EmployeeID"
> cboName.DisplayMember = "FullName"
> strRowFilter = String.Format("'{0}' = 'Current' And '{1}' = 'ATBDE'
> And TRActive = 1", _
>
> DsName.Relations("employeePersonnelStatusRel").ParentTable.Columns("Status"),
> _
> DsName.Relations("employeePersonnelGroupRel").ParentTable.Columns("GroupName"))
> dv.RowFilter = strRowFilter
> cboName.DataSource = dv
>
> -----
> strRowFilter is not working...
> Error displayed: Object Reference not set to an instance of an object..