Question

c#从数据类型 nvarchar 转换为 numeric 时出错.

float sc=Convert.ToSingle(scal);
string sql = "update " + str + " set score=@image0 where id=" + Login.idstr + " and imgName='" + als[pic_index].ToString() + "'";
SqlCommand cmd = new SqlCommand(sql, conn);

cmd.Parameters.Add("@image0",SqlDbType.Float);
cmd.Parameters["@image0"].Value = sc;
求解，谢谢。
换了，好几种输入格式，都不行。

Answer 1

但是在我继续往 表C后面追加条件时报错了

[sql] view plain copy
select * from (select
CONVERT(numeric,t2.ItemText) as BZA,
t1.* from t1
join dbo.CodeValue t2 on t1.N=t2.ItemValue
[sql] view plain copy
join Codes t3 on t2.CodeID=t3.CodeID and t3.CodeName='字典数据名' ) aa
where t1.SZ<BZA

最终加了这句，在第一个联表后面
[sql] view plain copy
and ISNUMERIC(t2.ItemText)>0

Answer 2

C#里面没有numetric吧？？？只有decimal吧

Answer 3

C#里面没有numetric吧？？？只有decimal吧