Filtering problem on DataView

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I'm very very new. so please be pacient =)
I'm trying to set the DataSource of a datagrid using the RowFilter property
of a dataView.
Employee is the Table already in a Dataset (connection to SQL Server)
EmployeeID is a GUID
TRDate is datetime
cboName is a Combobox on a Form (ValueMember = EmployeeID)


Dim tbl As DataTable
tbl = DsTimeRecording1.Tables("TimeRecording")
Dim dv As DataView = New DataView(tbl)

dv.RowFilter = "[EmployeeID] = " & Me.cboName.SelectedValue + " And
TRDate = " & dtpDate.Value
dgTimeRecording.DataSource = dv

Reported Error: Operator is not valid for type GUID and string " And TRDAte
= "
I'm using VS 2003 .NET

Thanks all
 
Back
Top