不能让我的更新工作 [英] Can't get my Update to work

问题描述

我使用一个存储过程来更新该列中的行，其中的运单号= @consignmentnumber。

I'm using a stored procedure to update the rows in the column where the consignment number = @consignmentnumber.

下面是code的屏幕。
我想我失去了一些东西，但我不能工作了，我居然不见了，谁能帮助？

Here is a screen of the code. I think I'm missing something but I can't work out I'm actually missing, can anyone help?

protected void BtnReceived_Click(object sender, EventArgs e)
{
    IncrementStatusOfConsignment(sender);
}

private static void IncrementStatusOfConsignment(object sender)
{
    var button = (Button) sender;
    var gridviewrow = (GridViewRow) button.Parent.Parent;
    var consignmentnumber = gridviewrow.Cells[3].Text;

    using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["Test"].ConnectionString))
    {
        con.Open();
        using (var cmd = new SqlCommand("Test", con))
        {
            cmd.CommandType = CommandType.StoredProcedure;
            var sqlparam = cmd.Parameters.Add("@consignmentnumber", SqlDbType.VarChar);
            sqlparam.Value = consignmentnumber;
            cmd.ExecuteNonQuery();
        }
    }
}

谁能告诉我在哪里，我错了还是我缺少的是什么？

Can anyone tell me where I've gone wrong or what I'm missing?

我不断收到此错误：

I constantly get this error:

如果我设置参数去诠释它仍然无法正常工作。

If I set the param to Int it still doesn't work.

推荐答案

如果您已声明的列 consignmentnumber 如数字（18，0），则

If you have declared column consignmentnumber as Numeric(18, 0) then

var sqlparam = cmd.Parameters.Add("@consignmentnumber", SqlDbType.Decimal);
sqlparam.Value = consignmentnumber;

或这样的事情：

var sqlparam = cmd.Parameters.Add("@consignmentnumber", SqlDbType.NVarChar, 18);
sqlparam.Value = consignmentnumber;

这篇关于不能让我的更新工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！