Sql Stored Proc fail.

[Solarion]

Two hours now staring at this while it stares back at me stubbornly like an annoying creature. The Insert is not happening. I get the Record Inserted message, yet nothing. What can you see wrong

 

[reactor_sa]

Insert -> insert into?

 

[Solarion]

Insert -> insert into?

Can you elaborate? Afaik I only need to specify the stored proc name in SQLCommand.

 

[Pho3nix]

Can you elaborate? Afaik I only need to specify the stored proc name in SQLCommand.

The SQL in the stores proc should be Insert Into not just Insert

 

[Solarion]

That did it!!!!!

Muchas gracias señora

 

[freddster]

Its always something small...

 

[Sinbad]

Its always something small...

That's what she said

 

[freddster]

That's what she said

as long its not about "that thing"

 

[halfmoonforever]

You also need to consider putting in some validation in your stored procedure and code. This could have been avoided if you actually output an error or success which would have shown the issue immediately.

 

[Necropolis]

You also need to consider putting in some validation in your stored procedure and code. This could have been avoided if you actually output an error or success which would have shown the issue immediately.

Well, no.

He stated that no exception was thrown...

 

[SykomantiS]

Well, no.

He stated that no exception was thrown...

Well, he could have checked for the returned value, to know if the insert was successful. SQL insert may fail, doesn't mean there will be an exception thrown, but you can still check for it.

 

[Necropolis]

Well, he could have checked for the returned value, to know if the insert was successful. SQL insert may fail, doesn't mean there will be an exception thrown, but you can still check for it.

I've never experienced an insert statement quietly failing before.

 

[SykomantiS]

Correct me if I'm wrong, but ExecuteNonQuery will return the number of rows affected, in this case 0, with no error in code?

 

[Pho3nix]

Well, no.

He stated that no exception was thrown...

He could have checked from SQL by testing the stored proc.

 

[zippy]

I've never experienced an insert statement quietly failing before.

when others then
null;

 

[Solarion]

Going to modify the code above to return the SCOPE_IDENTITY() field on insert. I'll post it here when done