I want that when i execute a select query,then the no of rews affected
by the query are to be known.
I've wrote the following code

Dim ret as integer
cmdSelect = New SqlCommand("Select Tech_Name From Technology where Tech_Name='" & Tech_Txt.Text & "' ", con)
ret = cmdSelect.ExecuteNonQuery

If (ret = 0) Then
'some operation
else
'some...
end if

but it not working,is it right way doing this.
whats the sol'n.

abhinavjain

__________________
abhinavjain

whats the error u get?

try to use executeQuery insteed of executenonQuery. executeNonQuery is for insert, update and delete.

hope this help
life's Ng

If nothing works then try out this

Dim ret as integer = 0
Dim myreader

cmdSelect = New SqlCommand("Select ....., con)
myreader = cmdSelect.ExecuteReader
While myreader.read()
     ret += 1
End While

myreader.close()
con.close()

If (ret = 0) Then
'some operation
else
'some...
end if


-.. -..