SQL Server 更新数据库时必须声明标量变量

kr98yfug 于 2023-01-04 发布在其他

关注(0)|答案(1)|浏览(272)

我的代码：

SqlConnection con = new SqlConnection(@"DATA;");
            SqlDataAdapter cmd = new SqlDataAdapter();
            cmd.InsertCommand = new SqlCommand(" UPDATE TIME set TimeOut = @TimeOut Where TimeOut = @textBox1.Text", con);
            cmd.InsertCommand.Parameters.Add("@timeOut", DateTime.Now);
            con.Open();
            cmd.InsertCommand.ExecuteNonQuery();
            con.Close();

错误：必须声明标量变量"@textBox1"

I tried declaring a variable with textBox1.Text but it didn't work

sql-server

来源：https://stackoverflow.com/questions/74976465/must-declare-the-scalar-variable-when-updating-my-database

1条答案

按热度按时间

vltsax251#

SqlConnection con = new SqlConnection(@"DATA;");
SqlDataAdapter cmd = new SqlDataAdapter();
cmd.InsertCommand = new SqlCommand(@"UPDATE `TIME` 
                                     SET TimeOut = @NewTimeOut 
                                     WHERE TimeOut = @OldTimeOut", con);
cmd.InsertCommand.Parameters.Add("@NewTimeOut", DateTime.Now);
cmd.InsertCommand.Parameters.Add("@OldTimeOut", DateTime.Parse(textBox1.Text));
con.Open();
cmd.InsertCommand.ExecuteNonQuery();
con.Close();

赞(0）回复(0）举报 2023-01-04

我来回答

SQL Server 更新数据库时必须声明标量变量

1条答案

相关问题

热门标签

最新问答