我将数据类型改成double,Dim arr1(4, 50) As Double
然后Public Function SqlInput() As Double(,)函数定义这里
我现在要在按钮里调用这个函数的话,我应该怎么写,
dim Intoarr as new Intoarray
返回值=intoarr.sqlinput(参数)
用什么接这个返回值,调用的时候,传递的参数怎么写。。。。
大神你帮我看看,我这个函数里是不是没有参数啊,
您好,我把代码贴上,您如果有时间的话帮我看一看可以吗,
Imports System.Data.SqlClient
Public Class IntoArray
Public Function SqlInput() As Integer(,)
Dim conn As SqlConnection = New SqlConnection(DbConnstr.connstring()) '创建链接对象
Dim sqlStr As String = "select * from test_data"
Dim cmd As SqlCommand = New SqlCommand(sqlStr, conn) '创建命令对象
Dim da As SqlDataAdapter = New SqlDataAdapter(cmd)
Dim ds As New DataSet
Try
conn.Open()
da.Fill(ds, "Dtable")
Catch ex As Exception
conn.Close()
Throw New Exception(ex.Message)
Finally
conn.Close()
End Try
Dim B_max As Integer = Dtable.Compute("max(B)", "")
Dim B_min As Int32 = Dtable.Compute("min(B)", "")
Dim A_max As Int32 = Dtable.Compute("max(A)", "")
Dim A_min As Int32 = Dtable.Compute("min(A)", "")
Dim D_max As Int32 = Dtable.Compute("max(D)", "")
Dim D_min As Int32 = Dtable.Compute("min(D)", "")
Dim P_max As Int32 = Dtable.Compute("max(P)", "")
Dim P_min As Int32 = Dtable.Compute("min(P)", "")
Dim B_average As Int32 = (B_max - B_min) / 5
Dim A_average As Int32 = (A_max - A_min) / 5
Dim D_average As Int32 = (D_max - D_min) / 5
Dim P_average As Int32 = (P_max - P_min) / 5
Dim arr1(,) As Int32
For i = 0 To Dtable.Rows.Count - 1
If Dtable.Rows(i).Item("B") / B_average < 1 Then
arr1(i, 1) = 20 * 0.4
ElseIf Dtable.Rows(i).Item("B") / B_average < 2 Then
arr1(i, 1) = 40 * 0.4
ElseIf Dtable.Rows(i).Item("B") / B_average < 3 Then
arr1(i, 1) = 60 * 0.4
ElseIf Dtable.Rows(i).Item("B") / B_average < 4 Then
arr1(i, 1) = 80 * 0.4
Else
arr1(i, 1) = 100 * 0.4
End If
Next
Return arr1
End Function
End Class
实现的功能就是这个表里的badp这四列分别取一个(最大值-最小值)/5的值,然后这四列的每一行分别除以这个值,得到的结果我想存到数组里返回