好象不对吧,我看如下行不行
Dim colName as String
Dim yy As String
dim rs as new ado.recordset
yy="select sum(dj*ss1) as "&colName& "from sale_ming where xsbh='"&Combo1.text&"'"
set rs=conn.execute yy
text1(0).text=rs(yy)
Dim colName as String
Dim yy As String
dim rs as new ado.recordset
yy="select sum(dj*ss1) as "&colName& "from sale_ming where xsbh='"&Combo1.text&"'"
set rs=conn.execute yy
text1(0).text=rs(yy)
解决方案 »
- 菜鸟请教在VB中调用STL格式三维模型,应该是利用OpenGL,求详解
- vb中如何用dbf的索引
- 求助vb 读取数据问题
- 发布我的PureBasic处女作,Compactor 1.0 功能演示版,望大家捧场!
- VScrollBar属性中调用BackColor,FillColor方法
- 如何讓VB打包工具生成的安裝工具在卸載時完全刪除安裝了的文件。
- 打包问题!
- ???哪里有类似Dreamweaver 功能的网页编辑的源代码???
- 如何让我在自己机器写的宏(excel)在别人的机器上也可以用。
- 求助!一个易懂的技巧问题,新手高手都可以解决。
- VB中的字体大小如何转换到HTML文件中去,还有其它的转换,比如说<table width=500>在VB里面又是多少像素?
- 关于vscrollbar的使用方法
Conn.Execute yy用Conn.Execute yy执行SQL时不返回记录集,所以text1(0).text=rs(yy)这句就不对了
……
set rs=Conn.Execute yy
Dim yy As String
yy = "select sum (dj*ssl) as sumval from sale_ming where xsbh='" & Combo1.Text & "'"
dim rst as adodb.recordset
set rst = Conn.Execute yyText1(0).Text = rst.fields(sumval)如果你要使控件数组对记录集字段进行引用请按下面的代码书写:
dim i as integer
for i = 0 to rst.recordcoun
text (i).text = rst.fields(sumval)
rst.movenext
next
这句是不是有问题呀
dim rs as adodb.recordset
yy="select sum(dj*ss1) as column1 from sale_ming where xsbh='"&Combo1.text&"'"
set rs=connectionName.execute(yy)
text1(0).text=rs.fields("column1").value
Dim xRec As daodb.recordset
yy = "select sum (dj*ssl) from sale_ming where xsbh='" & Combo1.Text & "'"
set xRec=Conn.OpenRecordSet(yy,dbopendynaset)
Text1(0).Text = xRec.fields(0)
set xRec=nothing
"select sum (dj*ssl) as io from sale_ming where xsbh='" & trim(Combo1.Text) & "'"
这个xsbh字段是什么类型的?字符加'',long等不加,日期datevalue('')
Rs_3.Open "select dj,ssl from sale_ming where xsbh='" & Combo1.Text & "'", Conn, adOpenStatic, adLockBatchOptimistic
yy = 0
Do While Not Rs_3.EOF
yy = yy + Rs_3.Fields(0) * Rs_3.Fields(1)
Rs_3.MoveNext
Loop
Text1(0).Text = Format(yy, "0.00")
Rs_3.Close
yy = 0
Do While Not Rs_3.EOF
yy = yy + Rs_3.Fields(0) * Rs_3.Fields(1)
Rs_3.MoveNext
Loop
Text1(0).Text = Format(yy, "0.00")
Rs_3.Close
dim rst as adodb.recordset
Dim io As Integer
yy = "select sum (dj*ssl) as uvalue from sale_ming where xsbh='" & Combo1.Text & "'"
set rst=Conn.Execute(yy)
io=val(rst("uvalue")&"")
Text1(0).Text = io
=====================
www.myvc.net
编程技术论坛欢迎你的加盟!