DataTable.Select() Method

Question

Hi all! I have a problem the code below throws an exception: Code: DataRow[] Rows = dsDataSet.Tables[MyTable].Select(NumericColumn =  + NumVar +  AND DateColumn =  + DateVar.ToString(dd/MM/yyy)); Exception: Cannot perform '=' operation on System.DateTime and System.Double String value of the Select statement: NumericColumn = 1 AND DateColumn = 08/20/2004 somebody knows why? Thanx in advanced Regards

Carlos Sanchez · Answer

Thank you bunny That really works. I appreciate your help. thanx. Regards.

Giovanni Bejarasco · Answer

I havn't explored this part of ADO.NET yet but from my experience in SQL dates are enclosed in '' so i think this workaround would work: Select(NumericColumn =  + NumVar.ToString() +  AND DateColumn = ' + DateVar.ToString(dd/MM/yyyy) + ');