Using Access queries via asp.net

[Dirk Vervecken]

Hi i've got an application in dotnet that uses
queries from an Access database.
Now most of the common select statements return the desired data,
however, one the queries requires a parameter.
This particular queries does not return the correct data.
I've tested the query in access and it works.

Somehow the parameter that I pass from asp.net does not seem
to be arriving.
This is a sample query of how it looks:
PARAMETER xParam Text(30)
Select * from Table
WHERE param LIKE xparam
xparam contains a *-wildcard at the beginning and end of the string.

And this is how I summon the query
DataSet result = new DataSet();
string searchstring = "*DA*";
OleDbCommand sqlCommand = new OleDbCommand();
sqlCommand = new OleDbCommand("NAME_OF THE
QUERY",(OleDbConnection)conn.Connectie,(OleDbTrans action)conn.Transactie);
sqlCommand.Parameters.Add(new OleDbParameter("xParam", OleDbType.Char,
30));
sqlCommand.Parameters["xParam"].Value = searchstring;
sqlCommand.CommandType = CommandType.StoredProcedure;
this.oleDbDataAdapter1.SelectCommand = sqlCommand;
oleDbDataAdapter1.Fill(result);

I use this way to access other selectqueries that do not use
parameters
and these work just fine. Just the ones with parameters don't work.
Can you help me fix this?

Kind Regards
Dirk Vervecken
di************@vgc.be
Tel: [phone]
-----
Directie Financiën en Algemene Zaken
Informatica
-----
Vlaamse Gemeenschapscommissie
SaincteletteSquare 17
1000 Brussel
www.digitaalbrussel.be
-----

[Joe Fallon]

The * works inside Access.
But in OLEDB code you need to use the % sign.
--
Joe Fallon


"Dirk Vervecken" <Di************@vgc.be> wrote in message
news:6c**************************@posting.google.c om...

Hi i've got an application in dotnet that uses
queries from an Access database.
Now most of the common select statements return the desired data,
however, one the queries requires a parameter.
This particular queries does not return the correct data.
I've tested the query in access and it works.

Somehow the parameter that I pass from asp.net does not seem
to be arriving.
This is a sample query of how it looks:
PARAMETER xParam Text(30)
Select * from Table
WHERE param LIKE xparam
xparam contains a *-wildcard at the beginning and end of the string.

And this is how I summon the query
DataSet result = new DataSet();
string searchstring = "*DA*";
OleDbCommand sqlCommand = new OleDbCommand();
sqlCommand = new OleDbCommand("NAME_OF THE
QUERY",(OleDbConnection)conn.Connectie,(OleDbTrans action)conn.Transactie);
sqlCommand.Parameters.Add(new OleDbParameter("xParam", OleDbType.Char,
30));
sqlCommand.Parameters["xParam"].Value = searchstring;
sqlCommand.CommandType = CommandType.StoredProcedure;
this.oleDbDataAdapter1.SelectCommand = sqlCommand;
oleDbDataAdapter1.Fill(result);

I use this way to access other selectqueries that do not use
parameters
and these work just fine. Just the ones with parameters don't work.
Can you help me fix this?

Kind Regards
Dirk Vervecken
di************@vgc.be
Tel: [phone]
-----
Directie Financiën en Algemene Zaken
Informatica
-----
Vlaamse Gemeenschapscommissie
SaincteletteSquare 17
1000 Brussel
www.digitaalbrussel.be
-----

[Dirk Vervecken]

I've tried that. I've placed *'s directly in the access query. No
succes. It simply seems as though the info
in the parameter is not passed from the .net application
to Access.
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!