如何执行Sql 语句 获取返回值

[zdebug]

如题~~~

sqlstr = "select count(*) as counts from Tablea where 1=1

请问我如何在vb.net 中执行这句话，并且得到我要的 counts 值，谢谢！！

[水如烟]

cm.ExecuteScalar()

[zdebug]

能详细点嘛？

dim count as string

count = ?? cm.ExecuteScalar() ??? 这样可以？？

谢谢~！

[guying999]

dim result as object
dim count as int

result = cm.ExecuteScalar()

If result not null then
count = Convert(result,Int32)
Else
count = 0
End If

[水如烟]

        Dim cn As New SqlClient.SqlConnection("你的连接字串")
        Dim cm As New SqlClient.SqlCommand("select count(*) as counts from Tablea", cn)
        cn.Open()
        Dim count As Integer = CType(cm.ExecuteScalar, Integer)
        cn.Close()

        cn.Dispose()
        cm.Dispose()

[yellowdong]

Dim conn As New SqlClient.SqlConnection("连接字符串")
Dim comm As New SqlClient.SqlCommand
dim str as string=""
try
conn.Open()
comm.Connection = conn
comm.CommandText = "select count(*) as counts from Tablea where 1=1 "
str=cmm.ExecuteScalar.tostring()
Catch ex As Exception
msgbox(ex.message)
cnn.Close()
comm.Dispose()
comm = Nothing
conn.Dispose()
conn = Nothing
End Try

[zdebug]

请问我这句话怎么是错误的啊，错误是“是一个类型，不能用作表达式”

Convert(result,Int32)

[zdebug]

谢谢 lzmtw 我在试你的代码

[zdebug]

谢谢 lzmtw 、yellowdong 、guying999

lzmtw 你的代码可以