关于返加记录数的函数处理,是错在哪儿了??始终返加数0

[wsxwsx123456789]

关于返加记录数的函数处理,是错在哪儿了??
Public Function Z_ReturnCount(ByVal SQLString As String, ByVal tablename As String) As Integer
'Return符合条件的记录个数
Dim conn As New SqlConnection()
conn.ConnectionString = SqlConnection
conn.Open()
Dim custAdapter As SqlDataAdapter = New SqlDataAdapter(SQLString, conn)
Dim tmpdataset As DataSet = New DataSet()
Dim aa = custAdapter.Fill(tmpdataset, tablename)
Dim Z_Count As Integer = 0
Z_Count = tmpdataset.Tables(0).Rows.Count
tmpdataset.Dispose()
custAdapter.Dispose()
conn.Dispose()
Return Z_Count
End Function

调用方法:
Z_ReturnCount("select * from book","AA")
问题,返回数值应该不是0,而是>1的整数

[htpower]

Dim aa = custAdapter.Fill(tmpdataset, tablename)
Dim Z_Count As Integer = 0
Z_Count = tmpdataset.Tables(tablename).Rows.Count

[wsxwsx123456789]

楼上的,不好意思,没有看清楚,与源码有哪些地方有区别??

[wdgphc]

Public Function Z_ReturnCount(ByVal SQLString As String, ByVal tablename As String) As Integer
'Return符合条件的记录个数
Dim conn As New SqlConnection(SQLString)
conn.ConnectionString = SqlConnection
conn.Open()
Dim custAdapter As SqlDataAdapter = New SqlDataAdapter(conn)
Dim tmpdataset As DataSet = New DataSet()
Dim aa = custAdapter.Fill(tmpdataset, tablename)
Dim Z_Count As Integer = 0
Z_Count = tmpdataset.Tables(0).Rows.Count
tmpdataset.Dispose()
custAdapter.Dispose()
conn.Dispose()
Return Z_Count
End Function

只是帮3楼的贴一下编辑后的代码

[wsxwsx123456789]

谢谢各位,已经搞定

[wsxwsx123456789]

楼上说将Z_Count = tmpdataset.Tables(0).Rows.Count ===>Z_Count = tmpdataset.Tables(tablename).Rows.Count
好象没有什么区别??但在调试中能计算正确,说明是正确的,但没有明白其中的区别?谢谢指教

[hmilj245216]

Public Function Z_ReturnCount(ByVal SQLString As String, ByVal tablename As String) As Integer 
        'Return符合条件的记录个数 
        Dim conn As New SqlConnection(SQLString) 
        conn.ConnectionString = SqlConnection 
        conn.Open() 
        Dim custAdapter As SqlDataAdapter = New SqlDataAdapter(conn) 
        Dim tmpdataset As DataSet = New DataSet() 
        Dim aa = custAdapter.Fill(tmpdataset, tablename) 
        Dim Z_Count As Integer = 0 
        Z_Count = tmpdataset.Tables(0).Rows.Count 
        tmpdataset.Dispose() 
        custAdapter.Dispose() 
        conn.Dispose() 
        Return Z_Count 
    End Function 

现在你试一试

[hmilj245216]

把上面的“”去掉，我是想加颜色让你看清楚，结果没加上