以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  [求助]遇到问题了,求组!  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=29504)

--  作者:zkysm
--  发布时间:2013/3/8 2:02:00
--  [求助]遇到问题了,求组!
在输入查询代码时候遇到下列问题。我使用TextBox插件来进行查询筛选,我编写的代码是
Dim cpbm As WinForm.TextBox = e.Form.Controls("TextBox1")
Dim cpmc As WinForm.TextBox = e.Form.Controls("TextBox2")
Dim cpgg As WinForm.TextBox = e.Form.Controls("TextBox3")
Dim dw As WinForm.TextBox = e.Form.Controls("TextBox4")
Dim cpdj As WinForm.TextBox = e.Form.Controls("TextBox5")
Dim gykh As WinForm.TextBox = e.Form.Controls("TextBox6")

Tables("产品目录").Filter="TextBox1 like \'*" & cpbm.text & "*\' and TextBox2 like \'*" & cpmc.text & "*\' and TextBox3 like \'*" & cpgg.text & "*\' and TextBox4 like \'*" & dw.text & "*\' and TextBox5 like \'*" & cpdj.text & "*\' and TextBox6 like \'*" & gykh.text & "*\'"

在使用按钮查询时候出现下面错误提示
.NET Framework 版本:2.0.50727.3053
Foxtable 版本:2012.11.28.1
错误所在事件:
详细错误信息:
System.Data.EvaluateException: Cannot find column [TextBox1].
   at System.Data.NameNode.Bind(DataTable table, List`1 list)
   at System.Data.BinaryNode.Bind(DataTable table, List`1 list)
   at System.Data.BinaryNode.Bind(DataTable table, List`1 list)
   at System.Data.BinaryNode.Bind(DataTable table, List`1 list)
   at System.Data.BinaryNode.Bind(DataTable table, List`1 list)
   at System.Data.BinaryNode.Bind(DataTable table, List`1 list)
   at System.Data.BinaryNode.Bind(DataTable table, List`1 list)
   at System.Data.DataExpression.Bind(DataTable table)
   at System.Data.DataExpression..ctor(DataTable table, String expression, Type type)
   at System.Data.Select..ctor(DataTable table, String filterExpression, String sort, DataViewRowState recordStates)
   at System.Data.DataTable.Select(String filterExpression)
   at Foxtable.OOO0OOl111.set_Filter(String O10ll)

请问是那里输入出错了?

--  作者:y2287958
--  发布时间:2013/3/8 6:20:00
--  
like 的前面应该是直接书写列名的,否则要用“&”连接起来。你试试。