How to use select query to populate text box?

[Darulehsan]

I want to know that how can we make SELECT * query possible in VB.net and also get the results in textbox??? help me please

[r035198x]

What have you tried so far?

[Darulehsan]

i even dont know the coding for that :(

[Nightraven]

vbcon.Open()
            Dim str As String = ""
           
            str = "SELECT * FROM mytablename"


Dim dbCommand As New SqlCommand(str, vbcon)
Dim dbReader = dbCommand.ExecuteReader


 While dbReader.Read()
                textboxtext = dbReader.Item("myvarname")
 End While
            dbReader.Close()