Use like and if

 

// Bind the work order number drop-down box value based on the input content and match the value similar to the input content var TCN = (from EE in linktosql. tascom from FF in linktosql. perpla from Gg in linktosql. eminfo where sqlmethods. like (EE. tascomnum, "%" + txttascomnum. text. trim () + "%") & ff. destype = "regular" & GG. emname = (FF. drawperson = NULL? Ff. desperson: ff. drawperson) & ee. tascomid = ff. fk_tascomid & GG. nawhosp = "zhangmingming" & ee. isdeleted = false select ee. tascomnum ). distinct (); cbb_tascomnum.items.insert (0, "select"); cbb_tascomnum.selectedindex = 0; cbb_tascomnum.items.addrange (TCN. toarray ());