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? What's 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)