Cant Submit Any Sort Of Variable Data

Hi there, i have written a page and for a long time it worked (or so i thought) now all of a sudden it dosnt. I have gone right back to basics and tried to only insert one variable, tried using a text box, a string pre populated, or a string populated by the text box - nothing seems to work. However if i hard code in the thing that i want, even into the SQL or into my param it works, whats going on! i think my programming skills are letting me down here!

here is what i am trying to use (as you can see i have commented out all that i was using to get back to basics)

Are there any pointers?SqlConnection objConnAddStock = new SqlConnection(sAddStock);

//This is the sql statement.

 int intUpdateQSStockID = Convert.ToInt32(Request.QueryString["qsStockID"]);

string strCondition;strCondition = "Brand New 12";using (objConnAddStock)

{

objConnAddStock.Open();string sqlAddStock = "UPDATE tbl_stock SET condition = @condition WHERE stock_id = " + intUpdateQSStockID;

 

 

 

 

 /*cat_id = @cat_id, sub_cat_id = @sub_cat_id, n_or_sh = @n_or_sh, " +

"description = @description, size = @size, colour = @colour, cost_price = @cost_price, " +

"selling_price = @selling_price, condition = @condition, notes = @notes, " +

"buying_in_recipt = @buying_in_recipt, visible = @visible, picture1 = @picture1, " +

"picture2 = @picture2, [picture3] = @picture3, picture4 = @picture4, " +

"picture1_thumb = @picture1_thumb, picture2_thumb = @picture2_thumb, " +

"picture3_thumb =@picture3_thumb, picture4_thumb = @picture4_thumb, title = @title, " +

"display_price = @display_price WHERE Stock_id = " + intUpdateQSStockID;*/

 SqlCommand objCmdAddStock = new SqlCommand(sqlAddStock, objConnAddStock);

objCmdAddStock.Parameters.AddWithValue("@condition", conditionTextBox.Text);/* objCmdAddStock.Parameters.AddWithValue("@cat_id", DropDownList2.SelectedValue);

objCmdAddStock.Parameters.AddWithValue("@sub_cat_id", DropDownList1.SelectedValue);

objCmdAddStock.Parameters.AddWithValue("@n_or_sh", n_or_shTextBox.Text);

objCmdAddStock.Parameters.AddWithValue("@description", txtDescription.Text);

objCmdAddStock.Parameters.AddWithValue("@size", sizeTextBox.Text);

objCmdAddStock.Parameters.AddWithValue("@colour", colourTextBox.Text);

objCmdAddStock.Parameters.AddWithValue("@cost_price", cost_priceTextBox.Text);

objCmdAddStock.Parameters.AddWithValue("@selling_price", selling_priceTextBox.Text);

objCmdAddStock.Parameters.AddWithValue("@condition", conditionTextBox.Text);

objCmdAddStock.Parameters.AddWithValue("@notes", notesTextBox.Text);

objCmdAddStock.Parameters.AddWithValue("@buying_in_recipt", TextBox3.Text);

objCmdAddStock.Parameters.AddWithValue("@visible", DropDownList4.SelectedValue);

objCmdAddStock.Parameters.AddWithValue("@picture1", txtPicture1.Text);

objCmdAddStock.Parameters.AddWithValue("@picture2", txtPicture2.Text);

objCmdAddStock.Parameters.AddWithValue("@picture3", txtPicture3.Text);

objCmdAddStock.Parameters.AddWithValue("@picture4", txtPicture4.Text);

objCmdAddStock.Parameters.AddWithValue("@picture1_thumb", txtPicture1_thumb.Text);

objCmdAddStock.Parameters.AddWithValue("@picture2_thumb", txtPicture2_thumb.Text);

objCmdAddStock.Parameters.AddWithValue("@picture3_thumb", txtPicture3_thumb.Text);

objCmdAddStock.Parameters.AddWithValue("@picture4_thumb", txtPicture4_thumb.Text);

objCmdAddStock.Parameters.AddWithValue("@title", txtTitle.Text);

objCmdAddStock.Parameters.AddWithValue("@display_price", txtDisplay.Text);*/

 

try

{

objCmdAddStock.ExecuteNonQuery();

}catch (Exception ex)

{Label17.Text = Convert.ToString(ex);

}finally

{

objConnAddStock.Close();

}Label17.Text = Convert.ToString(intUpdateQSStockID);

 

}