cmd.ExecuteScalar()

[ednayap]

hie..

anyone know how to find out if cmd.ExecuteScalar() is empty?

tanx a lot

 

[bungpeng]

ExecuteScalar is empty?

I cant get what you mean. Because ExecuteScalar is only performance the insert, update and delete but not select, so it wont return any records to you.

 

[Derek Stone]

Dim o As Object = cmd.ExecuteScalar()

If Not o Is Nothing Then
     A value was returned
Else
     No value was returned
End If

 

[bungpeng]

Oh, yes! sorry, I thought ExecuteScalar was ExecuteNonQuery...

 

[ednayap]

oh
tanx all