select case语句查询数据
如果数据库有三个字段English,Simplified,Traditional.根据页面语言string language而查询不同的字段要怎样写那个sql语句获得那个dataset呢

[解决办法]
string sql="SELECT * FROM tb WHERE 1=1";
switch(language)
{
case "English":
sql+=" AND English=.....";
break;
case "Simplified":
sql+=" AND Simplified=.....";
break;

case "Traditional":
sql+=" AND Traditional=.....";
break;
default:
break;
}
[解决办法]