please fix "String or binary data would be truncated.\r\nThe statement has been terminated"

Question

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

String or binary data would be truncated.\r\nThe statement has been terminated

and I couldn't find what's the problem. This is my method that I used:

 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();
        }
    }

This exception is thrown because you're trying to write more data into a field of a table than would fit into it. Like a string with 100 characters into a varchar(50) field. So the question is, how exactly is the field Cordinate (should probably be named Coordinate) defined and how long exactly is the newCord you try to write into it? — Corak
– Corak, Commented Apr 24, 2016 at 6:24
You should check out Can we stop using AddWithValue() already? and stop using .AddWithValue() - it can lead to unexpected and surprising results... — marc_s
– marc_s, Commented Apr 24, 2016 at 6:30
How about this post 'stackoverflow.com/questions/17312558/…'? — GSP
– GSP, Commented Apr 24, 2016 at 6:32
We need to see the table declaration in order to know the length of the column values. — Mark Schultheiss
– Mark Schultheiss, Commented Apr 24, 2016 at 6:51

Chathuranga Ranasinghe · Accepted Answer · 2016-04-24 08:37:27Z

1

Generally the cause for this issue is that the length of the parameter you send to the stored procedure is bigger than the size of the field in the actual table in the database.

answered Apr 24, 2016 at 8:37

Chathuranga Ranasinghe

5471 gold badge5 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

please fix "String or binary data would be truncated.\r\nThe statement has been terminated"

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related