更新不更新

Question

我正在尝试通过我的代码更新Server中的表。我已经通过了代码，所有准确和正确的值似乎都在传递。有人能看看这个然后告诉我如果我在什么地方犯了什么错误吗？提前谢谢。

public static string Update()
{
   string connectionString = null;
   SqlConnection connection;
   SqlDataAdapter adapter = new SqlDataAdapter();
   string sql = null;
   connectionString = Connection.MyConnectionString.ConnectionStrings[0];
   connection = new SqlConnection(connectionString);
   sql = "UPDATE tbl_Onsite SET Onsite = 'Yes' WHERE BoxNum = GlobalVariable.Variables.BoxNumber";
   try{
       connection.Open();
       adapter.UpdateCommand = connection.CreateCommand();
       adapter.UpdateCommand.CommandText = sql;
       adapter.UpdateCommand.ExecuteNonQuery();
  } 
  catch(Exception ex){
       MessageBox.Show(ex.ToString());
  }
  return null;
  }

Answer 1

尝尝这个

sql = "UPDATE tbl_Onsite SET Onsite = 'Yes' WHERE BoxNum = " + GlobalVariable.Variables.BoxNumber;