VB and MySQL 1

[cosmoh2o]

Please Help,
Does anybody know how to insert a variable's value into a mysql database with Visual Basic?

For Example:

Dim x as string
x = "Hello World."

Dim MyC as new OdbcCommand()
Dim Myconn as new OdbcConnection ("DSN=mysql_dsn&quot
Myconn.Open()
MyC.Connection = Myconn
MyC.CommandText = "INSERT INTO TABLE VALUES (x)"

I would like only the "value" of x placed in TABLE (i.e. "Hello World&quot. Thanks once again for any help.

 

[RiverGuy]

MyC.CommandText = "INSERT INTO TABLE VALUES '" & x & "'"

 

[cosmoh2o]

RiverGuy,

THank you VERY much. It worked great!!!

 

[RiverGuy]

NP. Just be careful to validate what that variable can contain, that it can't contain any malicious code.