Creating Tables

[tehon3299]

Hey -

How would I create an SQL table on an ASPX page? If I use:

Create Table tbMisc

then it say Create is not defined? Whats the problem? I have Import Namespace="System.Data.Sqlclient". Any ideas?

Thanks

 

[Robby]

try this...

            Dim con As New SqlConnection("server=127.0.0.1;Trusted_Connection=yes;database=Northwind")
            con.Open()

            Dim cmd As New SqlCommand("CREATE TABLE Test (Col1  Text, col2 Text)", con)
            cmd.ExecuteNonQuery()
            con.Close()

 

[tehon3299]

That works perfect. Now how could I use a variable for the table name??

Thanks

 

[Robby]

Dim cmd As New SqlCommand("CREATE TABLE " & TextBox1.Text.ToString & " (Col1  Text, col2 Text)", con)