score:1

Accepted answer
var areaname = (string.isnullorempty(convert.tostring(pmodel.areaname))
                   ? (object)dbnull.value : pmodel.areaname)

mysqlcommand.parameters.addwithvalue("@areaname", "%" + areaname + "%");

score:1

mysqlcommand.commandtext = "select * from plantareacodes where (@areacode is null or areacode like areacode) and (@areaname is null or like @areaname) and (@comments is null or comments like @comments);";

Related Query

More Query from same tag