Try cnn.Open() Dim query As String query = "CREATE TABLE best.new (id INT NOT NULL, name VARCHAR(45) NULL, date DATETIME NULL, PRIMARY KEY (id));" cmd = New MySqlCommand(query, cnn) reader = cmd.ExecuteReader MessageBox.Show("table created") cnn.Close()
Dim rename As String Rename = ("RENAME TABLE new To" TextBox1.Text) cmd = New MySqlCommand(Rename, cnn) reader = cmd.ExecuteReader MessageBox.Show("renamed") cnn.Close()
Dim rename As String Rename = ("RENAME TABLE new To " & TextBox1.Text) cmd = New MySqlCommand(Rename, cnn) reader = cmd.ExecuteReader MessageBox.Show("renamed") cnn.Close()
Rename = ("RENAME TABLE new To" TextBox1.Text)
Rename = ("RENAME TABLE new To " TextBox1.Text)
Rename = "RENAME TABLE best.new TO " & TextBox1.Text
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)