Member Avatar for dionisov

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...

  • 2 Contributors
  • 1 Reply
  • 99 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by meffe
Member Avatar for meffe

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)

oledat.Fill(datas)

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

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

Next
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.