Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - What’s Wrong with This Code?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

What’s Wrong with This Code?

 Post Reply Post Reply
Author
davidshq View Drop Down
Senior Member
Senior Member


Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
Post Options Post Options   Thanks (0) Thanks(0)   Quote davidshq Quote  Post ReplyReply Direct Link To This Post Topic: What’s Wrong with This Code?
    Posted: 23 October 2005 at 3:58pm
This code looks perfect to me, but its throwing an error. Basically its telling me that I need to create the Parameters before I use them, but as you can see - I did create them. Any ideas?
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        ' Declare variables.
        SqlDataSource1.InsertParameters("varTitle").DefaultValue = TextBox1.Text
        SqlDataSource1.InsertParameters("varPopularity").Defau ltValue = DropDownList1.SelectedValue
        SqlDataSource1.InsertParameters("varDescription").DefaultValue = TextBox2.Text
        SqlDataSource1.InsertParameters("varDangers").DefaultValue = TextBox3.Text
        SqlDataSource1.InsertParameters("varVariants").DefaultValue = TextBox4.Text
        SqlDataSource1.InsertParameters("varSource").DefaultValue = TextBox5.Text
        SqlDataSource1.InsertParameters("varType").DefaultValue = DropDownList2.SelectedValue
        SqlDataSource1.InsertParameters("varApproved").DefaultValue = 0
        SqlDataSource1.Insert()
        TextBox1.Text = ""
        TextBox2.Text = ""
        TextBox3.Text = ""
        TextBox4.Text = ""
        TextBox5.Text = ""
        ' Dim sql As String = "INSERT INTO Game (Title, Popularity, Description, Dangers, Variants, Source, Type, Approved) VALUES ('" & varNewTitle & "', " & varPopularity & ", '" & varNewDescription & "', '" & varNewDangers & "', '" & varNewVariants & "', '" & varNewSource & "', " & varType & ", 0)"
        ' Add Game to database.
        'SqlDataSource1.InsertCommand = sql
        ' SqlDataSource1.Insert()
    End Sub
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Me.IsPostBack = False Then
            SqlDataSource1.InsertCommandTy pe = SqlDataSourceCommandType.StoredProcedure
            SqlDataSource1.InsertCommand = "AddGames"
            SqlDataSource1.InsertParameter s.Add(New Parameter("varTitle", TypeCode.String))
            SqlDataSource1.InsertParameter s.Add(New Parameter("varPopularity", TypeCode.Int16))
            SqlDataSource1.InsertParameter s.Add(New Parameter("varDescription", TypeCode.String))
            SqlDataSource1.InsertParameter s.Add(New Parameter("varDangers", TypeCode.String))
            SqlDataSource1.InsertParameter s.Add(New Parameter("varVariants", TypeCode.String))
            SqlDataSource1.InsertParameter s.Add(New Parameter("varSource", TypeCode.String))
            SqlDataSource1.InsertParameter s.Add(New Parameter("varType", TypeCode.Int16))
            SqlDataSource1.InsertParameter s.Add(New Parameter("varApproved", TypeCode.Int16))
        End If
    End Sub
Back to Top
davidshq View Drop Down
Senior Member
Senior Member


Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
Post Options Post Options   Thanks (0) Thanks(0)   Quote davidshq Quote  Post ReplyReply Direct Link To This Post Posted: 23 October 2005 at 4:20pm
I used Page.IsPostBack instead and it worked fine. Weird, huh?
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.