大家看看我这样写有什么问题？

[ircfan]

Dim IntId As Integer = 0
Dim have As Boolean
Dim Outtime As Date
Dim pas As String
Dim SqlStr As String = "Select id,have,outtime,pas from card Where numb= '"& cardnum.text &"' And pas='"& cardpass.text &"'"
Dim mySqlConnection As SqlConnection=new SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
Dim mySqlCommand As SqlCommand = New SqlCommand(SqlStr,mySqlConnection)

mySqlCommand.Connection.Open
IntId =Ctype(mySqlCommand.ExecuteScalar,Integer)
have =Ctype(mySqlCommand.ExecuteScalar,Boolean)
Outtime =Ctype(mySqlCommand.ExecuteScalar,Date)
pas =Ctype(mySqlCommand.ExecuteScalar,String)

[momoguagua]

为什么不用Dim myReader As SqlDataReader = mySqlCommand.ExecuteNonQuery？然后再IntId=Ctype(myReader["??"],Integer]
你那么用不知道多个ExecuterScalar可不可以共用一个打开的Connection