转换 varchar 值时转换失败

Question

我计划从另一个表向我的文本框插入一个特定值。这样做后，它给了我一个错误" 将 varchar 值 '5,000 转换为数据类型 int 时转换失败。在我的数据库中，信用请求列 （5000） 是 char，目标列是 int。有什么技巧吗？

这是我的代码：

protected void Button2_Click(object sender, EventArgs e)
    {
        using (SqlConnection scn = new SqlConnection("Data Source = 'PAULO'; Initial Catalog=ShoppingCartDB;Integrated Security =True"))
        {
            scn.Open();
            SqlCommand cmd = new SqlCommand("INSERT INTO UserData(CreditRequest) Select CreditRequest FROM CreditRequests Where Username=@Username", scn);
            cmd.Parameters.Add("@Username", SqlDbType.NVarChar).Value = Session["New"];
            object value = cmd.ExecuteScalar();
            if (value != null)
                txtCredit.Text = value.ToString();
        }

错误是

object value = cmd.ExecuteScalar();

Answer 1

INSERT INTO UserData(CreditRequest)  SELECT CAST(REPLACE(CreditRequest, ',', '') as int) FROM CreditRequests Where Username=@Username