Filtering problem on DataView

[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

 

[Sijin Joseph]

You need to encloase the data value in ##

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

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph