Can anybody tell how to filter the row having date as string to DateTime ?

[Ripendra007]

hi all, i want to filter the date which is in label1.text
like
dview.RowFilter = "dir_bdate = '"+label1.Text+" '" ;
here dir_bdate is my DateTime field of database and label1 contains string in DD/MM/YYYY formate so this is giving me an error like below



Error :System.Data.EvaluateException: Cannot perform '=' operation on System.DateTime and System.String. at System.Data.BinaryNode.SetTypeMismatchError(Int32 op, Type left, Type right) at System.Data.BinaryNode.Compare(Object vLeft, Object vRight, Type type, Int32 op) at System.Data.BinaryNode.EvalBinaryOp(Int32 op, ExpressionNode left, ExpressionNode right, DataRow row, DataRowVersion version, Int32[] recordNos) at System.Data.BinaryNode.Eval(DataRow row, DataRowVersion version) at System.Data.DataFilter.Invoke(DataRow row, DataRowVersion version) at System.Data.Index.AcceptRecord(Int32 record) at System.Data.Index.InitRecords() at System.Data.Index..ctor(DataTable table, Int32[] indexDesc, DataViewRowState recordStates, IFilter rowFilter) at System.Data.DataTable.GetIndex(Int32[] indexDesc, DataViewRowState recordStates, IFilter rowFilter) at System.Data.DataView.UpdateIndex(Boolean force) at System.Data.DataView.SetIndex(String newSort, DataViewRowState newRowStates, DataFilter newRowFilter) at System.Data.DataView.set_RowFilter(String value) at smail.BirthDateReport.PageIndex(Object sender, DataGridPageChangedEventArgs e) in c:\inetpub\wwwroot\smail\birthdatereport.aspx.cs:l ine 147



Please reply soon its very very urgent ?