i have values i want to execute it in table in SqlDatabase and i use stored procedures , parameters

Question

when i try this code

 public void ExcuteCommand(string stored_procedure, SqlParameter[] param)
    {
        SqlCommand sqlcmd = new SqlCommand();
        sqlcmd.CommandType = CommandType.StoredProcedure;
        sqlcmd.CommandText = stored_procedure;
        sqlcmd.Connection = sqlconnection;

        if (param != null)
        {
            sqlcmd.Parameters.AddRange(param);
        }
        sqlcmd.ExecuteNonQuery();

to execute it , it give me something went wrong like in this pic i use for this Datatables and parameters and stored procedure this is what show when i try to run the code

You can just post the error msg instead of upload a screenshot just to display it. — Circle Hsiao, Jan 14 '17 at 13:00

score 1 · Accepted Answer · answered Jan 14 '17 at 12:55

1

In your SP you are trying to insert in table ID which has Identity Specification (Autoincrement) property. Remove ID from insert statement and it should work.

answered Jan 14 '17 at 12:55

Vasyl Zvarydchuk

3,789
26
37

i try to do this but i can't resolve it , can you explain it more , please – khaled hosny Jan 14 '17 at 13:04

score 1 · Answer 2 · answered Jan 14 '17 at 12:59

1

You are trying to insert the value of identity column(ID).

you can turn off this by appending this to your query statement.

SET IDENTITY_INSERT Table_Name OFF

answered Jan 14 '17 at 12:59

Mahesh Gareja

1,652
2
12
23

i try it it give me the same result – khaled hosny Jan 14 '17 at 13:04
Can you show me your query statement? – Mahesh Gareja Jan 14 '17 at 13:06
try this SET IDENTITY_INSERT Table_name ON " your query statement" SET IDENTITY_INSERT Table_Name OFF – Mahesh Gareja Jan 14 '17 at 13:09
IS this good for stored procedure ?? – khaled hosny Jan 14 '17 at 13:26
This is not good practice but it solves your problem.By default, it's auto increment. – Mahesh Gareja Jan 14 '17 at 13:40
Also, please upvote and accept my answer if it solves your problem. – Mahesh Gareja Jan 14 '17 at 13:44

i have values i want to execute it in table in SqlDatabase and i use stored procedures , parameters

2 Answers2