I have memebrship system with mysql database.
In the table I have comumns named Username, password, information...
I have to found the row with the username who have logged in and put the text from information column in textbox...

try this, if you have any problem with it let me know

Dim datas as DataSet
Dim datar as DataRow
dim oledat as SqlDataAdapter

oledat=new SqlDataAdapter("select information from tablename  where username='" & username.text & "'",connection)


For Each datar in datas.Tables(0).Rows

Textbox1.Text = datar.Item("information")