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