03-26-2013, 11:46 AM
i have n0w pr0vided this c0de in the updater f0rm:
but it is saying an error in the msgbox....
The snapshot of the error and my sql database snapshot is given below:
Error:
Database:
Please help me why this problem occurs.....
Code:
Imports MySql.Data.MySqlClient
Public Class updater
Public conn As MySqlConnection
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
conn = New MySqlConnection(ServerString)
Try
conn.Open()
Dim sqlquery As String = "SELECT vlink, dlink, ftpu, dtpp FROM updater"
Dim data As MySqlDataReader
Dim adapter As New MySqlDataAdapter
Dim command As New MySqlCommand
command.CommandText = sqlquery
command.Connection = conn
adapter.SelectCommand = command
data = command.ExecuteReader
Dim vlink As String = ""
Dim dlink As String = ""
Dim ftpu As String = ""
Dim dtpp As String = ""
While data.Read()
If data.HasRows() Then
vlink = data(1).ToString
dlink = data(2).ToString
ftpu = data(3).ToString
dtpp = data(4).ToString
End If
End While
UpdateVB1.checkforupdate(vlink, "0.0.9", dlink, ftpu, dtpp, True)
data.Close()
conn.Close()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
End Class
but it is saying an error in the msgbox....
The snapshot of the error and my sql database snapshot is given below:
Error:
Database:
Please help me why this problem occurs.....