I am using Framwork 1.1, C#, and Access 2000.
My table is called "sample1".If has only 1 column
called "firstname" in it.
There are 3 rows in "firstname":
this is a dog
I have no doggies
there are only cats here
Now, if I use the following select:
SELECT sample1.firstname FROM Sample1 where firstname
like '*dog*'
2 rows returned.
If I use the following :
OleDbCommand SelCmd = new OleDbCommand("SELECT
sample1.firstname FROM Sample1 where firstname
like '*dog*'",MyConn );
OleDbDataAdapter DAx = new OleDbDataAdapter();
DAx.SelectCommand = SelCmd;
DAx.Fill( ds, "sample1" );
Zero rows are returned and no exceptions are thrown. Is
there a problem i can't see in the parsing the provider
is doing or do I need to change the syntax?
Help! - thanks in advance.
|