Can't add info to database

Question

Hi

I'm trying to add some data to my database using this code

---

SqlCommand cmd = new SqlCommand("sp_insertDelivery", conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@SlotID", "1");

cmd.Parameters.AddWithValue("@CustID", textBoxCustNo.Text);

cmd.Parameters.AddWithValue("DeliveryDate", dateTimePicker1.Value.Date.ToShortDateString());

cmd.Parameters.AddWithValue("Chilled", textBoxChilled.Text);

cmd.Parameters.AddWithValue("Frozen", textBoxFrozen.Text);

cmd.Parameters.AddWithValue("Ambient", textBoxAmbient.Text);

cmd.Parameters.AddWithValue("OrderDate", System.DateTime.Now);

cmd.Parameters.AddWithValue("Notes", textBoxNotes.Text);

cmd.Connection.Open();

try

{

int i = 0;

i = cmd.ExecuteNonQuery();

if (i >= 1)

{

toolStripStatusLabel1.Text = "Customer order has been made";

}

else

{

toolStripStatusLabel1.Text = "error";

}

}

---

The weird thing is that it says that data has been added successfully but when I check to see if it is there then it hasn't added it.
I can add data manually so I don't think there is anything wrong with the permissions.

Any help would be great. PS This is ado.net 2.0