[help]with databases i guess.

Download MySQL Connector for .Net (Google).

Add the .dll from Installed folder\bin\net 2.0 as reference...

[php] Private conn As New MySqlConnection
Private Const connstr As String = "server=Your IP;" & "user id=username;" & "password=password;" & "database=database name"
Private reader As MySqlDataReader[/php]

[php] Private Sub InsertName()
Dim strSQL As String = ""

conn = New MySqlConnection(strConn)
conn.Open()

strSQL = "INSERT INTO Table(Column) VALUES('" & Textbox1.text & "')"

Dim cmd As New MySqlCommand(strSQL, conn)
cmd.ExecuteNonQuery()

conn.Close()

MsgBox("Your name has been added to the database." MsgBoxStyle.Information, "Success")

Catch ex As MySqlException
conn.Close()
End Try

GetNames()

End Sub[/php]

[php]Private Sub GetNames

Dim strConn As String = connstr
Dim strSQL As String = "SELECT * FROM Table'"

conn = New MySqlConnection(strConn)
conn.Open()

Dim cmd As New MySqlCommand(strSQL, conn)
reader = cmd.ExecuteReader

Do While reader.Read
Textbox1.Text &= reader("Column") & vbNewLine
Loop

reader.Close()
End Sub[/php]

Button_Click

[php]Dim t as new threading.thread(addressof InsertName)
t.priority = threading.thread.priority.highest
t.start[/php]


I just fully wrote this up for you...Feel free to copy & paste...

Keep in mind that you have to change:

-Column
-Table
-Textbox1.Text

Other than giving you code to c&p I advice you to start reading: SQL SELECT Statement and SQL INSERT INTO Statement

I wouldn't give him that code AGAIN. =P

I just told him to learn a bit of SQL so it would be easier to understand what you wrote.. xd because i'm pretty sure he is clueless about queries and non-queries ofc i wouldn't rewrite the code.

Alright, he should...

INSERT INTO Table(Column,Column) VALUES ('Value','Value')

SELECT * FROM Table WHERE Column='Value' AND/OR Column='Value'

UPDATE Table SET Column='Value'

=P