Using SqlDataSource In Visual Studio

Before you can call the Insert method on your SqlDataSource you need to correctly define its InsertCommand. Here is how you can do it:

protected void ItemBox_TextChanged(object sender, EventArgs e)
{
    if(setFire)
    {
        SqlDataSource1.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
        string storedProcedureName = .... // The name of your stored procedure

        SqlDataSource1.InsertCommand= storedProcedureName;

        // Then you should add a SqlParameter object into the collection
        // of Parameters for the Insert Command
        // Its name correspond to the variable name expected by your
        // stored procedure and its value comes from your textbox
        string paramName = .... // The parameter name in your stored procedure

        SqlDataSource1.InsertParameters.Add(paramName, yourTextBoxName.Text);

        // Now you can call Insert()

        SqlDataSource1.Insert();
        GridView1.DataBind();
        Label1.Text = GridView1.Rows.Count.ToString() + " Results Found";
        Label2.Text = ItemBox.Text;

        setFire = false;
        ItemBox.Text = "";
        ItemBox.Focus();
        setFire = true;
    }
}

I was able to resolve my issues. I had two stored procedures I needed to execute. One was tied to a GridView and the other was just to return an output parameter that I would display on screen.

With SqlDataSource1 (the object tied to my GridView) I didn't need to call SqlDataSource1.Insert(). Just doing the GridView1.DataBind() command worked fine.

As for the other I couldn't get the SqlDataSource object to behave like I wanted, so I ended up using the method outlined in the youtube video below:

https://www.youtube.com/watch?v=stIWeAcO45Y

It ended up working perfectly.

Thank you so much @alainlompo for your help above. Although I didn't end up using that technique I did find your example very useful.