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