Insertion query C# sql server

Question

I have an insertion query in this function :

public string Insert_Piece(List<Piece> liste)
        {
            this.Connect();
            using (connexion)
            {

                using (SqlCommand sqlCmd = new SqlCommand("INSERT INTO Piece (IDPiece, IDSuperlot, Url) VALUES (@idpiece, @idsuperlot, @url)", connexion))
                {
                    foreach (Piece p in liste)
                    {
                        sqlCmd.Parameters.AddWithValue("@idpiece", p.Id_piece);
                        sqlCmd.Parameters.AddWithValue("@idsuperlot", p.Id_super_lot);
                        sqlCmd.Parameters.AddWithValue("@url", p.Url_piece);
                        try
                        {
                            sqlCmd.ExecuteNonQuery();
                        }
                        catch (Exception e) { return e.ToString(); }

                    }
                    return "cava";
                }
            }
        }

But always an exception appears: error

I don't know what is the problem and how can i fix it . The 3 attributs are string (varchar) and the selection queries works fine without problem.

What is the matter?
How can i fix it?

can you please translate the error in English, that will be very helpful. — Sachin
– Sachin, Commented May 8, 2013 at 23:17
So, one of your strings is too long for the column you are trying to insert it into (URL, probably) — Blorgbeard
– Blorgbeard, Commented May 8, 2013 at 23:19

bigcakes · Accepted Answer · 2013-05-08 23:19:40Z

3

It looks like the issue is you are trying to insert too long of a string into the varchar column, try making the varchar column larger or changing it to be a text column.

answered May 8, 2013 at 23:19

bigcakes

2162 silver badges9 bronze badges

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

2 Comments

Lamloumi Afif Over a year ago

how can i change th type of the field url to text

bigcakes Over a year ago

Well @Lamloumi , open up whatever you used to initially create the database, I assume SQL Server Management Studio and on the dropdown just change varchar to text, or just change the number in the parentheses on the varchar to MAX and see if that fixes it.

Collectives™ on Stack Overflow

Insertion query C# sql server

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related