Posted on: 11/11/2013 4:31:06 AM | Views : 821

SqlConnection connection = null; SqlCommand command = null; try { string connectionString = ConfigurationManager.ConnectionStrings["SurveyFdDBConnString"].ConnectionString; connection = new SqlConnection(connectionString); connection.Open(); string sql = "Insert into MCQ_Responses (SurveyID, SurveyQuestionNo, UserID, ResponseValue, DateResponse) Values " + "(@SurveyID, @SurveyQuestionNo, @UserID , @ResponseValue , '1/1/2013')"; //string sql = "Insert into MCQ_Responses (SurveyID , DateResponse) Values " + "(@SurveyID , @DateResponse)"; command = new SqlCommand(sql, connection); command.Parameters.AddWithValue("@SurveyID", (string)Request.QueryString["SurveyID"]); command.Parameters.AddWithValue("@Surve ...

Go to the complete details ...