Problem with Data Insertion

Question

Hey Guys I am facing problem while inserting some data in database using asp .net but the data is not getting inserted nor i am getting any exception or error i have attached the file. please help me.

Manas Mohapatra · Answer

Firstly a comma missed between first two params(see yellow marked) command = new SqlCommand(insert into training_details values (@trainingid  @orgname@trainingname@trainername@trainingstart@trainingend) connection); Secondly ExecuteNonQuery () method always returns integer value that how many records affected in database. But in code you are converting it to boolean which not correct. Change your code like below: if ( (command.ExecuteNonQuery()) > 0 ) { Response.Write(  + Training Successfully scheduled
 Training Id is  + id); } else { Response.Write(  + Sorry
Records Could Not Be Inserted + id); }

Ankit Kumar · Answer

Dear Manas There is no problem with this line if(Convert.ToBoolean(command.ExecuteNonQuery())) as if will return rows more than 0 then according to my code it will return true. but yeah your first suggestion resolved my problem. Thank for your Help

Manas Mohapatra · Answer

Did you try my second suggestion instead of converting it to boolean?