调试后更新语句的异常. [英] exception for update statement after debuging.

问题描述

嗨.

我在Asp.net中用以下代码编写了一个更新状态:

Hi.

I have written an update statemnt in Asp.net with the code below:

protected void UpdateButton(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection();

            conn.ConnectionString = ConfigurationManager.ConnectionStrings["PersonTest"].ConnectionString;
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "UPDATE Person SET (Name=@Name,Family=@Family) where (PersonId=@PersonId)";
            cmd.Parameters.AddWithValue("@Name", textbox1.Text);
            cmd.Parameters.AddWithValue("@Family", TextBox2.Text);
            cmd.Parameters.AddWithValue("@PersonId", txtId.Text);

            cmd.Connection = conn;
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
        }

但是在调试之后会发生此异常:
SqlException未由用户代码处理.
''(''附近的语法不正确.

是什么问题?

but after debuging this exception occures :
SqlException was unhandled by user code.
Incorrect syntax near ''(''.

what is the problem?

推荐答案

您能删除您的注释行并尝试下一次吗.........

并像
一样使用此代码 cmd.CommandText ="UPDATE Person SET Name = @ Name，Family = @ Family，其中PersonId = @ PersonId" ;;

Can u remove your commented line and try next time .........

and use this code as like
cmd.CommandText = "UPDATE Person SET Name=@Name,Family=@Family where PersonId=@PersonId ";

取消注释人员ID cmd.parameters行....

uncomment person id cmd.parameters line....

这篇关于调试后更新语句的异常.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！