急 在线等待！ 高手请进

[gq198718]

public DataTable SearchProduct(string Region,string ProductName, string Manufacturer)
{
string strSql = string.Empty;
strSql = "SELECT " +
"Guid ," +
"ProductNumber ," +
"ProductName ," +
"ProductStyle ," +
"ProductOrigin ," +
"PackUnit ," +
"ReferencePrice ," +
当Region = NUll时候要求ReferencePrice 列的值都为* 该怎么修改？

[昵称被占用了]

"ReferencePrice ," +
------>

"ReferencePrice = case when Region is null then '*' else ReferencePrice end ," +

[gq198718]

我试试，谢谢回答

[gq198718]

没有效果哦

[水族杰纶]

或者写存储过程吧
在存储过程中判断

[gq198718]

SearchProduct(string Region,string ProductName, string Manufacturer)
是Region参数

[昵称被占用了]

[Quote=引用 5 楼 gq198718 的回复:]
SearchProduct(string Region,string ProductName, string Manufacturer)
是Region参数
[/Quote]
...

string strSql = string.Empty;
strSql = "SELECT " +
"Guid ," +
"ProductNumber ," +
"ProductName ," +
"ProductStyle ," +
"ProductOrigin ," +
"PackUnit ,"
if Region = string.Empty
strSql = strSql +
"ReferencePrice ='*',"
else
strSql = strSql +
"ReferencePrice ,"

strSql = strSql + ...

[ycproc]

存储过程 判断 好些 免得 前台输入了引起的 怪问题

[ycproc]

存储过程 判断 好些 免得 前台输入了引起的 怪问题

[gq198718]

非常感谢！ 我再去试试

[guoruixiaoni]

高手怎么还不进来 讲讲啊