Why wont this work!??!??!

[area91]

Hey,

I am a 13 year old developer. I was playing around with SQL Server 2k0 Eval. Edition. Can someone tell me why this wont work?

Dim stringa, stringb As String
        stringa = Server.HtmlEncode(TextBox1.Text)
        stringb = Server.HtmlEncode(TextBox2.Text)
        Dim cmd As SqlCommand
        Dim cnn As SqlConnection
        cnn = New SqlConnection("server=localhost;user=dex2;pwd=password1;database=pocketdotnet;")
        cmd = New SqlCommand("INSERT INTO " & Me.Session.Item("workgroup") & "News (title, disc, postedby, uid) VALUES ('" & stringa & "', '" & stringb & "', '" & Me.Session.Item("username") & "', '" & Int((999999 - 11111 + 1) * Rnd() + 11111) & "'", cnn)
        cnn.Open()
        cmd.ExecuteNonQuery()
        cnn.Close()

Thanks!

[DevGrp]

Are you getting any errors??

Also you might wanna try using parameters for your sql statement.

[area91]

there is my error..btw i don't think this makes a diff. but I am using .NET Framework version 1.2 Alpha...here is the what i get...

[Buy2easy.com]

Try entering in the connection and sql statement manually...it has been a while since i have done it (i wrote a library to do DB stuff) but i think there is a cmd.connection variable and a cmd.command or something like that also double check to make sure that you have all you column names correct cause if not then it will throw an error...also use the database connection toolbox to create a connection to your DB and then go to the connection properties to get the connection string that it creates. I will try to post back later with the code I used to perform an executenonquery.