private ArrayList GetAnswersOfPoll(string nPollID) { ArrayList answerList = new ArrayList(); string [] answerInformation = new string[2]; try { string sql = "Select A.q_answer_mid,A.q_answer_ans,C.company_member_fname,C.company_member_lname from ctool_q_answer A, ctool_company_member C where A.q_answer_mid = C.company_member_id AND A.q_answer_qid =" + nPollID; ArrayList recordset = dbCon.Execute(sql); if (recordset.Count > 0) { foreach (ArrayList record in recordset) { WebPollAnswer answer = new WebPollAnswer((string)record[1], (string)record[2] + ' ' + ((string)record[3])); answerList.Add(answer); } } } catch (Exception ee) { MessageBox.Show(ee.Message); } return(answerList); }
private ArrayList GetAnswersOfPoll(string nPollID) { ArrayList answerList = new ArrayList(); string []answerInformation = new string[2]; try { string sql = "Select A.q_answer_mid,A.q_answer_ans,C.company_member_fname,C.company_member_lname from ctool_q_answer A, ctool_company_member C where A.q_answer_mid = C.company_member_id AND A.q_answer_qid =" + nPollID; ArrayList recordset = dbCon.Execute(sql); if(recordset.Count > 0) { foreach(ArrayList record in recordset) { WebPollAnswer answer = new WebPollAnswer((string)record[1],(string)record[2] + ' ' + ((string)record[3])); answerList.Add(answer); } } } catch(Exception ee) { // MessageBox.Show(ee.Message); } return answerList; }