hi,
how can i find out that what number of record(row) my cursor focused on in database?

thanks

label1.text= active row`s number ?????

example :

Dim baglanti As New SqlClient.SqlConnection()
Dim command As New SqlClient.SqlCommand()
Dim kisiler As SqlClient.SqlDataReader

baglanti.ConnectionString = "data source=instance2000;" & "initial catalog=dbf;" & "integrated security= SSPI"
baglanti.Open()
command = baglanti.CreateCommand
command.CommandText = "select number, name, surname from veriler where [EMAIL="name=@name"]name=@name[/EMAIL]"
command.Parameters.AddWithValue("@name", TextBox1.Text)
kisiler = command.ExecuteReader()

If kisiler.HasRows Then
While kisiler.Read()
label1.text= active row`s number ?????
End While
Else
MsgBox("Kayit yok")
End If
baglanti.Close()
kisiler.Close()

This article has been dead for over six months. Start a new discussion instead.