Member Avatar for Fenerbahce

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()

  • 2 Contributors
  • 1 Reply
  • 89 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by Amit007
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.