DataTable反向模糊匹配查找语法
正向写法:
string filter = "code like '%"+sheetname+"%'";
filter值为: code like '%表F.3_1%'
反向写法:
string filter = "'" + sheetname + "' like '%'+ code+'%'";
filter值为: '表F.3_1' like '%'+ code+'%'
正向写法:
string filter = "code like '%"+sheetname+"%'";
filter值为: code like '%表F.3_1%'
反向写法:
string filter = "'" + sheetname + "' like '%'+ code+'%'";
filter值为: '表F.3_1' like '%'+ code+'%'