Problem while calling Ms Access Query from C# .net

[bhuvard]

Hi,

Will anybody please help me?

I have a MS Access Database with 1 Tabel and 2 queries.
e.g.

Tabel "client": Client containing fields name,address,ci ty,state,ziip

query1 "allClient" : Select * from client;
query2 "SelectedClient ": Select * from client where name Like '%ab%';

And I am using this database from my application developed in c# .net.

When I am reading table "Client" or query1 "allClient" through OleDbDataReader it's working perfectly.

But when I am using the same way with query2 "selectedClient " the datareader is empty eventhough there are some records in query result. The query is working nice in MS Access but not in my application.

Thanks,
Rajesh

[davef]

Hi,

Will anybody please help me?

I have a MS Access Database with 1 Tabel and 2 queries.
e.g.

Tabel "client": Client containing fields name,address,ci ty,state,ziip

query1 "allClient" : Select * from client;
query2 "SelectedClient ": Select * from client where name Like '%ab%';

And I am using this database from my application developed in c# .net.

When I am reading table "Client" or query1 "allClient" through OleDbDataReader it's working perfectly.

But when I am using the same way with query2 "selectedClient " the datareader is empty eventhough there are some records in query result. The query is working nice in MS Access but not in my application.

Thanks,
Rajesh

Try query2 "SelectedClient ": Select * from client where name Like '*ab*';