read a row from database

[met0555]

ok, tanks, but there is something that i didn't understand. if i only put this code will it work Dim rowIndex as integer = DataGridView1.CurrentCellAddress.Y 'This will get the row index of the current selected cell

Dim row as datagridviewrow = datagridview1.rows(rowIndex)
dim lyrics as string = row.cells(4).value.tostring 'Get the value of the fifth column on the row selected
RichTextBox1.clear()
Richtextbox1.text = lyrics

or i have to put the select.... ? and if i need a select statment , do i only need one or more?

(The lyrics are allready stored i the database)