Hello , I would like to enquire if how could I put MYSQL Row to a TextBox ?
Here is my code
Private Sub Form1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load MySqlConnection = New MySqlConnection MySqlConnection.ConnectionString = "server=localhost;Port=3306; user id =root; password=****; database=visualbasic" MySqlConnection.Open() Dim Myadapter As New MySqlDataAdapter Dim Sqlquery = "Select Sec FROM codes where username = '" & Info.Text & "' AND code = '" & Form5.Code.Text & "';" Dim command As New MySqlCommand command.Connection = MySqlConnection command.CommandText = Sqlquery Myadapter.SelectCommand = command Dim Mydata As MySqlDataReader Mydata = command.ExecuteReader If Mydata.HasRows = 1 Then MsgBox("Blabla") End If The coloured RED part . How can i change it to send the rows values to a Textbox? Cause my program will close within a seconds specified . and it uses mysql to check if the value of seconds is how much. If it is still not very detailed, i am willing to tell more. (Coloured Green [Sec] Equals to Seconds) End Sub
Edited 5 Years Ago by coolsasuke: n/a