can't insert records into database

Question

My published application does not insert (write) records into database

Biswa Pujarini Mohapatra · Answer

First can you throw the error to see what is the exact exception, It might not be sqlexception which you are using in your catch so just simply throw the error, also if you post the error what you are getting then I can help you further. catch{throw;}

Jon Sambo · Answer

No difference. Older IIS on target server. Taking a break

Hanook · Answer

Why do you have two ExecuteNonQuery(). I can see inside as well as outside of foreach loop you have ExecuteNonQuery() with no other statements in try... catch try { foreach () { //stored procedure code cmd.Parameters.Add("@currentDate", SqlDbType.VarChar).Value = DateTime.Now; // cmd.ExecuteNonQuery(); // j = j + 1; } cmdComm.ExecuteNonQuery(); } check whether that is causing any issue?

Jignesh Trivedi · Answer

do one thing remove try catch block from here and deploy your appliation.

Jon Sambo · Answer

No. Application run OK in IDE

Jignesh Trivedi · Answer

you code and SP looks ok Here you write Try catch block to catch the error check, Is any Error generated in SqlException catch block?

Jon Sambo · Answer

CONNECTION STRING: "data source=10.1.26.237;Initial Catalog=securitySurvey;Integrated Security=True;Trusted_Connection=True;Persist Security Info=True;User ID = csg; Password = csg"; // providerName="System.Data.SqlClient" /> XXXXXXXXXX Code XXXXXXXXXX try { foreach (DataRow row in dt.Rows) { // cmd.Parameters.Add("@questionId", SqlDbType.VarChar).Value = Convert.ToByte(dt.Rows[j]["questionsId"].ToString()); cmd.Parameters.Add("@categoryID", SqlDbType.VarChar).Value = Convert.ToByte(dt.Rows[j]["categoryId"].ToString()); cmd.Parameters.Add("@categoryDescr", SqlDbType.VarChar).Value = dt.Rows[j]["categoryDescr"].ToString(); cmd.Parameters.Add("@questionDescr", SqlDbType.VarChar).Value = dt.Rows[j]["questionDescr"].ToString(); // cmd.Parameters.Add("@inAdequate", SqlDbType.VarChar).Value = answerArray[j, 0]; cmd.Parameters.Add("@marginal", SqlDbType.VarChar).Value = answerArray[j, 1]; cmd.Parameters.Add("@satisfactory", SqlDbType.VarChar).Value = answerArray[j, 2]; cmd.Parameters.Add("@veryGood", SqlDbType.VarChar).Value = answerArray[j, 3]; cmd.Parameters.Add("@excellent", SqlDbType.VarChar).Value = answerArray[j, 4]; cmd.Parameters.Add("@currentDate", SqlDbType.VarChar).Value = DateTime.Now; // cmd.ExecuteNonQuery(); // j = j + 1; } cmdComm.ExecuteNonQuery(); } // Catch the exception as e and pass it to the ShowErrors routine. catch (SqlException e) { } XXXXXXXXXXXXXXXXXXXXXXXXXXX STORED PROCEDURE BELOW XXXXXXXXXXXXXXXXXXXXXXX set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: -- Create date: -- Description: -- ============================================= ALTER PROCEDURE [dbo].[pSurvey] ( @questionID int, @categoryID int, @categoryDescr varchar (50), @questionDescr varchar (150), @inAdequate int, @marginal int, @satisfactory int, @veryGood int, @excellent int, @currentDate dateTime ) AS BEGIN INSERT INTO Answers ( questionId, categoryId, categoryDescr, QuestionDescr, inAdequate, marginal, satisfactory, veryGood, excellent, currentDate ) VALUES ( @questionID, @categoryID, @categoryDescr, @questionDescr, @inAdequate, @marginal, @satisfactory, @veryGood, @excellent, @currentDate ) END

Jignesh Trivedi · Answer

can you please share your code which used to insert the record?

Jon Sambo · Answer

there is no error generated

Jon Sambo · Answer

Yes it is pointing to the same database as before publishing and running on the internet

Jignesh Trivedi · Answer

is it give any error? do one thing register Application_Error() event in Global.asax and write notepad file or window event log on error. it help to know error. hope this will help you.

Hanook · Answer

Check the database connection.. Are you pointing to correct(production/development/testing) database or not?

can't insert records into database

Answers (12)