SQL ASP.NET [Sql Command error]

Question

SqlCommand cmd = new SqlCommand("FlowClientHardQ 0, 10, 1, 1, 364, Null", conn);

works with no error

SqlCommand cmd = new SqlCommand("FlowClientHardQ @ID_User, @ID_ListGroupParIzm, 1, 1, @CIzmer, Null", conn);
            cmd.Parameters.AddWithValue("@ID_User", user);
            cmd.Parameters.AddWithValue("@ID_ListGroupParIzm", ID_ListGroupParIzm);
            cmd.Parameters.AddWithValue("@CIzmer", izmer);

Incorrect syntax near the construction "FlowClientHardQ"

its id , but problem is solved , except I have no idea how to send NULL value — cnd
– cnd, Commented Jan 28, 2010 at 7:05

womp · Accepted Answer · 2010-01-28 06:34:53Z

5

Just do this:

    SqlCommand cmd = new SqlCommand("FlowClientHardQ", conn);
    cmd.Parameters.AddWithValue("@ID_User", user);
    cmd.Parameters.AddWithValue("@ID_ListGroupParIzm", ID_ListGroupParIzm);
    cmd.Parameters.AddWithValue("@CIzmer", izmer);

If you're calling a stored procedure, just set the command text to be the stored procedure name, and add the parameters like you're doing. Set the command type to StoredProcedure before you execute it.

answered Jan 28, 2010 at 6:34

womp

117k27 gold badges240 silver badges271 bronze badges

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

Comments

gbn · Accepted Answer · 2010-01-28 06:34:22Z

1

Need to set CommandType to be StoredProcedure?

answered Jan 28, 2010 at 6:34

gbn

434k84 gold badges602 silver badges690 bronze badges

1 Comment

cnd Over a year ago

StoredProcedure, you helped me to wrote it ^_^

Collectives™ on Stack Overflow

SQL ASP.NET [Sql Command error]

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related