Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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;
        }