query related problem
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
but it not working,is it right way doing this.
whats the sol'n.