Esempio n. 1
0
        public static long GetIdOfQuestionText(string questionText)
        {
            var tableAdapter = new QuestionTableAdapter();
            var datatable = tableAdapter.GetIdFromQuestionText(questionText);
            foreach(var row in datatable){
                return row.QuestionId;
            }
            return -1;

            /*using (var connection = new SqlConnection(ConnectionString))
            {
                connection.Open();
                var questionCmd = new SqlCommand("SELECT QuestionId FROM Question WHERE Text = @Text",
                    connection);
                questionCmd.Parameters.Add(@"Text", SqlDbType.VarChar, 250).Value = questionText;
                questionCmd.Prepare();
                var reader = questionCmd.ExecuteReader();
                while (reader.Read())
                {
                    return (long) reader["QuestionId"];
                }
                return -1;
            }*/
        }