在输入查询代码时候遇到下列问题。我使用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)
请问是那里输入出错了?