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; }*/ }