Filtering DataGridView with Date Cannot perform '=' operation on System.DateTime and System.String
Posted on 2006-11-27
Error Message: Cannot perform '=' operation on System.DateTime and System.String
I have a Dataset with date values that look like "11/23/2006" , that format.
I am trying to use a combobox to sort datagridview to only show things concerning tomorrow.
Pretty simple but I keep getting that error message. I have made my column in the dataset a String type
string dt = DateTime.Today.AddDays(01).ToShortDateString() ;
if (sortBox.Text == "Due Tomorrow")
dsAssignment.assignmentsTable.DefaultView.RowFilter = "dueDate = " + dt + "";