Link to home
Start Free TrialLog in
Avatar of Rowel Virgo
Rowel VirgoFlag for Philippines

asked on

Item From Database to Textbox?

How to display the size of tblmountertrace_1 (to) 9 to text box? Please see picture:

User generated image
Im using this code but I dont know how to query. I put it on the Timer (timSERVERSIZE) to update every 4 Hours a day.

        Private Sub timSERVERSIZE_Tick(sender As Object, e As EventArgs) Handles timSERVERSIZE.Tick
        Dim cmd2 As New MySqlCommand
        Dim myDA2 As New MySqlDataAdapter(cmd2)
        Dim myDT2 As New DataTable
        cmd2.Connection = conn
        cmd2.CommandText = "SELECT * FROM esd_reco ?????????????????????????????????????"
        myDA2.Fill(myDT2)
        TextBox1.items.add(myDA2)  <<<<<<<<<<<<??????????????????????????


    End Sub

Open in new window


Thanks for the help
ASKER CERTIFIED SOLUTION
Avatar of yo_bee
yo_bee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Rowel Virgo

ASKER

OK Thanks!