My .Net Code
# connDO.Open();
# SqlCommand comm = new SqlCommand("DOrders.dbo.p_Update", connDO);
# comm.CommandType = CommandType.StoredProcedure;
# daDirectOrders.UpdateCommand = comm;
#
# comm.Parameters.Add("@UOrderNumber", SqlDbType.Int, 32, uOrderNumber.ColumnName);
# comm.Parameters.Add("@ConfirmationCode", SqlDbType.VarChar, 50, confirmationCode.ColumnName);
# comm.Parameters["@ConfirmationCode"].SourceVersion = DataRowVersion.Original;
# comm.Parameters.Add("@Carrier", SqlDbType.VarChar, 50, doCarrier.ColumnName);
# comm.Parameters.Add("@Tracking", SqlDbType.VarChar, 50, doTracking.ColumnName);
# comm.Parameters.Add("@OrderID", SqlDbType.Int, 32, orderID2.ColumnName);
# comm.Parameters["@OrderID"].SourceVersion = DataRowVersion.Original;
# comm.Parameters.Add("@LineItem", SqlDbType.Int, 32, lineItem.ColumnName);
# comm.Parameters["@LineItem"].SourceVersion = DataRowVersion.Original;
#
# daDirectOrders.Update(dataSet);
# connDO.Close();My Stored Procedure:
# @UOrderNumber int,
# @ConfirmationCode varchar(50),
# @Carrier varchar(50),
# @Tracking varchar(50),
# @OrderID int,
# @LineItem int
#
# AS
# BEGIN
#
# SET NOCOUNT ON;
#
# UPDATE Orders
# SET UOrderNumber = @UOrderNumber
# WHERE ConfirmationCode = @ConfirmationCode
#
# UPDATE OrdersDetail
# SET Carrier = @Carrier, Tracking = @Tracking, LastUpdated = GETDATE()
# WHERE OrderID = @OrderID and LineItem = @LineItem
#
#
# END
When I run, I get the following error:
Procedure or function 'p_update' expects parameter '@Carrier' which was not supplied
Why isn't is recognizing my parameter? Also, it does not give a problem with @UOrderNumber and @ConfirmationCode. And when I do Parameters.AddWithValue and pass a string value, it does work. The problem is, that my value has to be a dataColumn from my dataset and addWithValue does not take a dataColumn from what I saw. (correct me if I'm wrong)
Thanks!
