can't insert records into database

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?

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