比如有如下SQL语句:
SELECT *
FROM Table1
WHERE (ISDELETE IS NULL) AND (LIKELY = '参数')这个参数是我的Winform程序在运行时获取的主机名,在程序里这个SQL语句好写如下:
"SELECT * FROM Table1 WHERE (ISDELETE IS NULL) AND (LIKELY = '" + FormCheck.machineName + "')"可是在TableAdapter查询配置向导中,这个SQL语句怎么写?(即如何设定参数)注:Winform
SELECT *
FROM Table1
WHERE (ISDELETE IS NULL) AND (LIKELY = '参数')这个参数是我的Winform程序在运行时获取的主机名,在程序里这个SQL语句好写如下:
"SELECT * FROM Table1 WHERE (ISDELETE IS NULL) AND (LIKELY = '" + FormCheck.machineName + "')"可是在TableAdapter查询配置向导中,这个SQL语句怎么写?(即如何设定参数)注:Winform
如果参数是字符串,WHERE LIKELY LIKE ‘参数' "SELECT * FROM Table1 WHERE (ISDELETE IS NULL) AND (LIKELY LIKE '" +FormCheck.machineName + "')"