我在代码里计算试验数据,并显示在程序界面各自的TextBox里,下面是我的代码,请高手们帮我看看这段程序有什么问题?由于试验次数不定,所以用了动态数组。
Dim i As Integer
i = 0
Dim Chg() As Single
Dim Rs As Adodc1.Recordset
ReDim Chg(i) As Single
Rs.MoveFirst
While Not Adodc1.Recordset.EOF
Chg(i) = Abs(Rs.Fields("试验后") - Rs.Fields("试验前")) / Rs.Fields("试 验前")
另一问题:这个结果要显示百分比,怎么实现?
i = i + 1
AverageText.Text = "Chg(i)"
ReDim Preserve Chg(i) As Single
Rs.MoveNext
Wend
Dim i As Integer
i = 0
Dim Chg() As Single
Dim Rs As Adodc1.Recordset
ReDim Chg(i) As Single
Rs.MoveFirst
While Not Adodc1.Recordset.EOF
Chg(i) = Abs(Rs.Fields("试验后") - Rs.Fields("试验前")) / Rs.Fields("试 验前")
另一问题:这个结果要显示百分比,怎么实现?
i = i + 1
AverageText.Text = "Chg(i)"
ReDim Preserve Chg(i) As Single
Rs.MoveNext
Wend
解决方案 »
- 如何取得MSHFlexGrid某列的序号数字(送分)
- 如何判断字体的颜色?急急急
- 关于QQ游戏类似斗地主这样的游戏。。。
- xml解析后,怎么在DataGrid中显示记录呢?想直接从xml读取记录而不通过绑定Recordset,有没有办法呢?
- 放分救急!
- 如果模拟一个CBN_SELCHANGE?
- 高手前辈来帮帮我啊,WebBrowse控件在哪里找?怎么按出来的?在线等
- 提供上海工作机会给有能力,能踏踏实实工作的应届大专生
- VB中跳出循环,继续执行的语句是什么?
- 谁做过"条形码"打印呀! 给点见意! 高分给你哟! UP有分!
- Winsock控件的RemoteHost若设置为域名,能否自动触发DNS做域名解析
- 急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急急......火烧眉毛了
dim conn as new adodb.connection
dim rs as new adodb.recordset
Dim Chg() As Singleconn.connectionstring="..." '与数据库的连接语句
conn.open
if rs.state=adstateopen then rs.close
rs.open "select * from tablename",conn,adopenkeyset,adlockreadonly
reDim Chg(i) As Single
for i=0 to rs.recordcount
Chg(i) = Abs(Rs.Fields("试验后") - Rs.Fields("试验前")) / Rs.Fields("试验前")
Rs.MoveNext
next i
rs.close
conn.close
set rs=nothing
set conn=nothing
改下
Dim i As Integer
dim conn as new adodb.connection
dim rs as new adodb.recordset
Dim Chg() As Single
’出百分号
Dim strPer() As Stringconn.connectionstring="..." '与数据库的连接语句
conn.open
if rs.state=adstateopen then rs.close
rs.open "select * from tablename",conn,adopenkeyset,adlockreadonly
i=rs.recordcount
reDim Chg(i) As Single
reDim strPer(i) as stringfor i=0 to rs.recordcount
Chg(i) = Abs(Rs.Fields("试验后") - Rs.Fields("试验前")) / Rs.Fields("试验前")
’出百分号
strPer(i)=CStr(Round(Chg(i), 2) * 100) & "%"
Rs.MoveNext
next i
rs.close
conn.close
set rs=nothing
set conn=nothing
// Dim Rs As Adodc1.Recordset一句应为:
Dim Rs As new ADODB.Recordset
Rs = Adodc1.Recordset
Set Rs = Adodc1.Recordset
Dim i As Integer
i = 0
Dim Chg() As Single
Dim Rs As Adodc1.Recordset
ReDim Chg(i) As Single
Rs.MoveFirst
While Not Adodc1.Recordset.EOF
Chg(i) = Abs(Rs.Fields("试验后") - Rs.Fields("试验前")) / Rs.Fields("试验前")
ptext(i)=CStr(Round(Chg(i), 2) * 100) & "%"
i = i + 1
AverageText(i).Text = Chg(i)
ReDim Preserve Chg(i) As Single
Rs.MoveNext
Wend
我只要在程序界面放一个Textbox来显示计算的结果,你用ptext(i)会不会要求用多个Textbox控件呢?