如何得到SQL查询结果,谢谢
htys3 2003-08-21 03:56:20 Dim conGetQuery As SqlConnection
Dim cmdGetQuery As SqlCommand
Dim strGetQuery As String
conGetQuery = New SqlConnection(ConfigurationSettings.AppSettings("DBPath"))
strGetQuery = "SELECT count(*) FROM a where a_class = '类别1'"
cmdGetQuery = New SqlCommand( strGetQuery, conGetQuery)
conGetQuery.Open()
lblNum.Text=cmdGetQuery.ExecuteScalar()'这里我应该用什么函数能传回的lblNum?
conGetQuery.Close()