Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How can I read a link from mysql databse???
#1
Hello,
I watched all the brandonio's video tutorials on youtube..

I worked according to his video tutorials....

Now at one stage I got a problem here...I made an updater for my software using UpdateVB component and wants to get the version.txt links and SFX download link from the database...I tried something but it doesn't work....

What have I tried:
[code2=vbnet]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
While data.Read()
If data.HasRows() Then
Dim vlink As String = data(1).ToString
Dim dlink As String = data(2).ToString
Dim ftpu As String = data(3).ToString
Dim ftpp As String = data(4).ToString
End If
End While
UpdateVB1.checkforupdate("vlink", "0.0.9", "dlink", "ftpu", "ftpp", showUI:=True)
data.Close()
conn.Close()
Catch ex As Exception
End Try
End Sub
End Class[/code2]

but by my codes the updater didn't response at all and I also get no error...

Please help me how can I do this or by which codes I can solve my problem...I am a beginner in vb.net..

Please help me...

Thanks in advance.....


Messages In This Thread
How can I read a link from mysql databse??? - by mnxford - 03-19-2013, 11:12 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How do I use Listview to delete MySQL DB records kismetgerald 10 33,855 11-28-2012, 05:19 PM
Last Post: brandonio21
  [SOLVED] MySQL Update Query - What am I doing wrong? kismetgerald 11 43,302 10-18-2012, 07:16 PM
Last Post: brandonio21
  How do I fill my form with MySQL data based on Combobox? kismetgerald 8 26,704 10-14-2012, 09:05 PM
Last Post: brandonio21
  Read certain lines brco900033 3 14,631 09-26-2012, 03:56 PM
Last Post: brandonio21
  Read and delete lines brco900033 6 22,562 09-16-2012, 09:38 AM
Last Post: brandonio21
  Help with creating an INSERT statement using MySQL kismetgerald 4 16,752 08-30-2012, 03:03 PM
Last Post: brandonio21
  MySQL Database Issue Moldraxian 7 29,044 08-13-2012, 08:58 PM
Last Post: brandonio21
  MySql Database Queries in VB.Net Moldraxian 6 22,378 07-26-2012, 03:44 PM
Last Post: Moldraxian
  How to Package MySql Connector and MySql Program? Moldraxian 3 14,754 07-20-2012, 12:23 PM
Last Post: brandonio21
  MySql Help Blackrobot 3 14,615 04-06-2012, 03:49 AM
Last Post: xolara

Forum Jump:


Users browsing this thread: 1 Guest(s)