hi,guys:
Now i am in this situation:I want to use the cause "like",i wrote:
string commd = "select * from buyerinfo where BuyerName like '%?blurName%'";
MySqlParameter para = new MySqlParameter("?blurName", MySqlDbType.VarChar,
45, "BuyerName");
para.Value = blurName;
It didn't work.
I changed that like this:
string commd = "select * from buyerinfo where BuyerName like
'%"+"?blurName"+"%'";
MySqlParameter para = new MySqlParameter("?blurName", MySqlDbType.VarChar,
45, "BuyerName");
para.Value = blurName;
or:
blurName="'%"+"blurName"+"%'";
string commd = "select * from buyerinfo where BuyerName like ?blurName";
MySqlParameter para = new MySqlParameter("?blurName", MySqlDbType.VarChar,
45, "BuyerName");
para.Value = blurName;
or:
string commd = "select * from buyerinfo where BuyerName like '%?blurName%'";
MySqlParameter para = new MySqlParameter("?blurName", MySqlDbType.VarChar,
45, "BuyerName");
para.Value = blurName;
It also didn't work, when executed ,It returned nothing ,which definitely
wrong.
Any advise will be appreciated,thx!
--
Best regards！
haitao
--
Best regards!
海涛
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
