以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- [求助]临时表取值(已解决) (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=84942) |
-- 作者:yyzlxc -- 发布时间:2016/5/13 14:33:00 -- [求助]临时表取值(已解决) 用此方法取值出错,如何解决,请各位老师指教,谢谢!! Dim cpkh As String = Forms("代码采集").Controls("ComboBox1").Value Dim cmd1 As New SQLCommand Dim dt1 As DataTable cmd1.C \'外部数据源 Dim cmb1 As WinForm.ComboBox cmd1.CommandText = "S ELECT StyleNo,CutFormID F rom {CutForm}" dt1 = cmd1.ExecuteReader() Dim dr1 As DataRow = cmd1.SQLFind("StyleNo = \'" & cpkh & "\'") Dim cjdid As Integer = dr1("CutFormID") MessageBox.Show(cjdid) [此贴子已经被作者于2016/5/13 14:38:32编辑过]
|
-- 作者:大红袍 -- 发布时间:2016/5/13 14:34:00 -- Dim dr1 As DataRow = dt1.SQLFind("StyleNo = \'" & cpkh & "\'") [此贴子已经被作者于2016/5/13 14:34:31编辑过]
|
-- 作者:yyzlxc -- 发布时间:2016/5/13 14:38:00 -- 不好意思,犯了一个低级错误,谢谢大红袍老师! |