troubleshooting Question

Create Table in MSSQL & VB 2005

Avatar of pkvasan
pkvasan asked on
Microsoft SQL ServerVisual Basic.NET
5 Comments1 Solution520 ViewsLast Modified:
Hi
i want to create as and when i enter new profile of a person iam using SQL's CREATE TABLE Query, but iam getting error can any one hel me to over come this


Private Sub CreatePerTable()
        Dim TableID As String
        TableID = TextPerID.Text
        Dim cn As New SqlConnection(DataConn)
        Dim cmd As New SqlCommand("create Table '" & TableID & "' (SLNO INT,NAME varchar(20))", cn)
        cn.Open()
        cmd.ExecuteNonQuery()
        MsgBox("Created Table", MsgBoxStyle.Information, "Confirmation")
        cn.Close()
    End Sub
ASKER CERTIFIED SOLUTION
the_bachelor

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros