想实现的功能是将LISTBOX1中选中的内容添加到LISTBOX2中去,但是点击按键后DATASET修改了,但两个LISTBOX不刷新,即使我重新调用FILL()来绑定数据源也不行。LISTBOX1中的查询语句是SE...
想实现的功能是将LISTBOX1中选中的内容添加到LISTBOX2中去,
但是点击按键后DATASET修改了,但两个LISTBOX不刷新,即使我重新调用FILL()来绑定数据源也不行。
LISTBOX1中的查询语句是SELECT OperateName,OperateID,OperateClass
FROM dbo_Operate
WHERE (OperateID NOT IN
(SELECT dbo_Operate_1.OperateID
FROM ((dbo_Operate dbo_Operate_1 INNER JOIN
dbo_OperateRights ON dbo_Operate_1.OperateID = dbo_OperateRights.OperateId AND
dbo_Operate_1.OperateID = dbo_OperateRights.OperateId) INNER JOIN
dbo_Operator ON dbo_OperateRights.OperatorId = dbo_Operator.OperatorID)
WHERE (dbo_OperateRights.OperatorId = ?)))
LISTBOX2中的查询语句是SELECT dbo_Operate.OperateName, dbo_Operate.OperateID, dbo_Operate.OperateClass
FROM ((dbo_Operate dbo_Operate INNER JOIN
dbo_OperateRights ON dbo_Operate.OperateID = dbo_OperateRights.OperateId AND
dbo_Operate.OperateID = dbo_OperateRights.OperateId) INNER JOIN
dbo_Operator ON dbo_OperateRights.OperatorId = dbo_Operator.OperatorID)
WHERE (dbo_OperateRights.OperatorId = ?)
但是我把这个FORM关掉,重新再打开这个窗口,LISTBOX1和LISTBOX2中显示的数据就是更新过了的。
请问有什么办法可以解决,让我点击按键之后就更新这个窗口。
我做的是WINFORM程序
展开