VS 2005 Using sqldatasource queries with "where" clause
Posted: Mon 15 May 2006 03:43
Hi!
I want to use an sqldatasource with a select statement like this:
select a, b, c from table where d = Profile.custominfo;
VS 2005 puts it like this:
select a, b, c from table where d = ([custominfo] = ?);
and then it adds:
Unfortunately that does not work with the mysql connector.
Any ideas?
I want to use an sqldatasource with a select statement like this:
select a, b, c from table where d = Profile.custominfo;
VS 2005 puts it like this:
select a, b, c from table where d = ([custominfo] = ?);
and then it adds:
Unfortunately that does not work with the mysql connector.
Any ideas?