Problem with Data Insertion

Ankit Kumar

11y784.NET

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra11y ago
Accepted 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\n Training Id is " + id);
}
else
{
Response.Write("" + "Sorry\nRecords Could Not Be Inserted" + id);
}
Manas Mohapatra11y ago
Did you try my second suggestion instead of converting it to boolean?
Ankit Kumar11y ago
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