sql错误 帮忙看看啊

[挨踢直男]

 string StrSQL = "UPDATE * FROM v_Company SET Company_Name = " +
                        "@Company_Name,Abbreviation = @Abbreviation ," +
                        " Company_Address = @Company_Address, Company_Tel = " +
                        "@Company_Tel,Company_Explain = @Company_Explain WHERE User_ID=@User_ID";
        SqlConnection DbConn = new DataBase().Open();
        SqlCommand thisCommand = DbConn.CreateCommand();
        thisCommand.CommandText = StrSQL;
        thisCommand.CommandType = CommandType.Text;
        thisCommand.Parameters.Add("@Company_Name", SqlDbType.NVarChar, 20).Value = Company_Name.Text;
        thisCommand.Parameters.Add("@Abbreviation", SqlDbType.NVarChar, 10).Value = Abbreviation.Text;
        thisCommand.Parameters.Add("@Company_Address", SqlDbType.NVarChar, 50).Value = Company_Address.Text;
        thisCommand.Parameters.Add("@Company_Tel", SqlDbType.VarChar, 20).Value = Company_Tel.Text;
        thisCommand.Parameters.Add("@Company_Explain", SqlDbType.NVarChar, 4000).Value = Company_Explain;
        thisCommand.Parameters.Add("@User_ID", SqlDbType.NVarChar, 20).Value = UserId;
        int Count = thisCommand.ExecuteNonQuery();
        DbConn.Close();

出现错误
System.InvalidCastException: 对象必须实现 IConvertible。

这是什么原因啊

[q107770540]

UPDATE * FROM v_Company SET Company_Name

============

UPDATE v_Company SET Company_Name

[Zhanlixin]

SQL语句改为:
string StrSQL = "UPDATE v_Company SET Company_Name = " +
"@Company_Name,Abbreviation = @Abbreviation ," +
" Company_Address = @Company_Address, Company_Tel = " +
"@Company_Tel,Company_Explain = @Company_Explain WHERE User_ID=@User_ID";

[porschev]

这个是绑定在哪个数据源上了吗？

出错的地方不应该在这里吧

[挨踢直男]

[Quote=引用 1 楼 q107770540 的回复:]

UPDATE * FROM v_Company SET Company_Name

============

UPDATE v_Company SET Company_Name
[/Quote]

不是这个 这个是写错的

[q107770540]

把你的参数转换到合适的类型去，譬如，如果一个参数的类似是int，你需要这么做

string s = "123 ";
SomeParam.Value = Convert.ToInt32(s);

[jointan]

Company_Explain和UserID的类型是什么?是string吗?

[Zhanlixin]

thisCommand.Parameters.Add("@Company_Explain", SqlDbType.NVarChar, 4000).Value = Company_Explain
改为:
thisCommand.Parameters.Add("@Company_Explain", SqlDbType.NVarChar, 4000).Value = Company_Explain.Text

[挨踢直男]

[Quote=引用 7 楼 zhanlixin 的回复:]

thisCommand.Parameters.Add("@Company_Explain", SqlDbType.NVarChar, 4000).Value = Company_Explain
改为:
thisCommand.Parameters.Add("@Company_Explain", SqlDbType.NVarChar, 4000).Value = Company_Explain……
[/Quote]

谢谢

[无涯大者]

7楼的 有点道理