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 ...