Dear Friends
DataView is pouplated from an oracle database table and when i tried to Filter records which has been created in between two dates gives me misguiding rows. I have tried with different date format, still getting wrong information.
Dim dt as New DataSet, dv as New DataView
Dim mAdapt = New OracleDataAdapter("SELECT * FROM Order", _Conn_)
mAdapt.SelectCommand.CommandType = CommandType.Text
mAdapt.Fill(dt, "Order")
dv.Table = dt.Table("Order")
dv.RowFilter = "Order_Date >= #" & Format(mFromDt, "MM/dd/yy") & "# AND " & _
Order_Date <= #" & Format(mToDt, "MM/dd/yy") & "#"
'mFromDt and mToDt are Date Type Variable.
Is anything wrong in Date Format or Character which enclosed Date Literal ?
Warun