[Mono-devel-list] RowFilter, Select expression, DataTable.GetErrors() bugs?

bandito banditaras at gmail.com
Tue Aug 2 03:37:53 EDT 2005

Hello all.

I'm using mono and the MySql connector (
First, I'm having this problem with the RowFilter expression. 
I want to do a DataTable.Select(someFilterHere), but if the filter
contains a single quote, I cannot escape it. For example
string filter = "ProductTitle = 'aa''aa'"; //invalid expression
string filter = "ProductTitle = 'aa\\'aa'"; //invalid expression
string filter = @"ProductTitle = 'aa\'aa'"; //invalid expression
The first expression works fine in .Net.

Next, I perform an update using MySqlDataAdapter.Update method. 
After the update is completed, DataTable.GetErrors() returns all rows
as erroneous.
Yet, I can see in the database that all records have been updated
successfully (except from one, which i'm trying to track down, but I
cant :) ).
I'm wondering if anyone else has encoutered any of these problems, Mr.
Google knows nothing of it.

Thanks in Advance
George Chatzigeorgiou

P.S Development platform is a linux box, if it makes any difference.

More information about the Mono-devel-list mailing list