Loading

DataTable.Select() Method

Carlos Sanchez

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Carlos Sanchez22y ago
Thank you bunny, That really works. I appreciate your help. thanx. Regards.
0
Giovanni Bejarasco22y ago
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") + "'");
0