title: please fix "String or binary data would be truncated.\r\nThe statement has been terminated"
body: <p>I want to find the old co-ordinate and replace it with a new co-ordinate in my Database using C# WPF. I got this error </p>
  
  <blockquote>
    <p>String or binary data would be truncated.\r\nThe statement has been
    terminated</p>
  </blockquote>
  
  <p>and I couldn't find what's the problem. This is my method that I used: </p>
  
  <pre><code> public void updateEvent(string oldCord,string newCord, DateTime dropDate)
      {
  
          using (SqlCommand cmd = new SqlCommand())
          {
              cmd.CommandText = "UPDATE Event SET Date = @newDate ,Cordinate=@newCord  WHERE  Cordinate = @oldCord";
              cmd.Parameters.AddWithValue("@newDate", dropDate);
              cmd.Parameters.AddWithValue("@newCord", newCord);
              cmd.Parameters.AddWithValue("@oldCord", oldCord);             
              cmd.CommandType = System.Data.CommandType.Text;
              cmd.Connection = connection;
              cmd.ExecuteNonQuery();
          }
      }
  </code></pre>