.: Stand Alone C# App for MCQ Quiz :.

argan

Well-known member
  • Jul 27, 2007
    16,100
    2,076
    113
    37
    <<< Benthara Gangen Eha >>>
    SE waddangen saha elakiri programmers lagen awasarai,

    Maa mey thread eka damanuye MCQ Quiz app ekak C# and MSSQL DB use karala hadaganna sup ekak ganeema pinisai...

    System eke registration paththa user accounts ewa hari awula thiyenne DB eke Quiz kiyana table eke thiyena Questions tikai Answers tikai ekin ekata form ekata load karana gaman answer ekath count karaganna eka...Meka stand alone app ekak widiyata echchara galapenne na kiyana eka passe thamai meter une eth dan me widiyenma goda daaganna kramayak hoyanne...

    mey thiyenne SQL table eka

    2dcd307.png


    Danata mehema eka form ekakata load karagatta eth meka digata yawaganna oni next button click ekata...hithaganna ba loop ekakin run karanna puluwan weida kiyala...

    53mfth.jpg


    Loop ekakin SQL Table eke questions and answers load karaganna kramayak danna kenek innawanm kiyanna....ehema nathnum wena mona hari suggestions thiyenawanm ewath meke daanna....Thanx a lot!!!

     
    • Like
    Reactions: saja

    saja

    Well-known member
  • Jan 8, 2007
    16,134
    2
    10,767
    113
    Home Sweet Home
    සරලව හිතුවොත් , ඔලුවට එන මුල්ම idea එක තමා ඔය question table එක Generic class type list එකකකට load කරලා එක මගින් dynamically, labels සහ radio button ලිස්ට් එකට load ක‍රන එක , no idea නම් google search කරන්න "sample quiz application in c #" කියල

    අපි නම් පොඩි:D research එක්කක් කොහොමත් කරන්නව develop කරන්න ඉස්සරලා
     
    Last edited:
    • Like
    Reactions: argan

    argan

    Well-known member
  • Jul 27, 2007
    16,100
    2,076
    113
    37
    <<< Benthara Gangen Eha >>>
    Digata yawanna ona kiyana kalla therenne na. Thawa poddak pahadili karanna.

    Oyata next button aka click karaddi mokadda wenna ona?

    Next button eka click karaama 2nd question eka and answers table eken load wenna oni...Loop ekakin database eke thiyena questions okkoma mey widiyata load karaganna bari weida kiyala hithanne form eken form ekata design karana eka lesi wadak newei ne Unit 10k thiyenawa Questions 250k wage ei Unit 10tama....
     

    argan

    Well-known member
  • Jul 27, 2007
    16,100
    2,076
    113
    37
    <<< Benthara Gangen Eha >>>
    සරලව හිතුවොත් , ඔලුවට එන මුල්ම idea එක තමා ඔය question table එක Generic class type list එකකකට load කරලා එක මගින් dynamically, labels සහ radio button ලිස්ට් එකට load ක‍රන එක , no idea නම් google search කරන්න "sample quiz application in c #" කියල

    අපි නම් පොඩි:D research එක්කක් කොහොමත් කරන්නව develop කරන්න ඉස්සරලා

    Anna hari dynamically thamai macho load wenna oni mata sample eke fredek dunna eke thiyenneth code eken labels and radio buttons hada hada yana ekak...mata oni meka loop ekakin wage load karaganna...oya kiyana kramen ehema loop ekak use karala table eken ganna puluwanda?
     

    testnew3

    Member
    Oct 13, 2016
    148
    13
    0
    api saralawa wede patan gamu, dan hadala thiyena eken.

    01. Common UI ekak one, dan hadala thiyena form ekath ok.
    02. Questions set eka List<Question> ekakata load karaganna one db eken.
    03. Next karama, api list eken ilaga question eka aran penwanawa.
    04. Finally Submit karama api u dipu answers set eka thawa table ekakata save karaganna one.
    05. Ube dan thiyena questions table ekata danna one correct answer column ekak, int ekak nam wada hodai, AnS1 nam, 1 anna ea wage.

    Help ekak one nam kiyapan
     
    • Like
    Reactions: JokerFan and argan

    argan

    Well-known member
  • Jul 27, 2007
    16,100
    2,076
    113
    37
    <<< Benthara Gangen Eha >>>
    api saralawa wede patan gamu, dan hadala thiyena eken.

    01. Common UI ekak one, dan hadala thiyena form ekath ok.
    02. Questions set eka List<Question> ekakata load karaganna one db eken.
    03. Next karama, api list eken ilaga question eka aran penwanawa.
    04. Finally Submit karama api u dipu answers set eka thawa table ekakata save karaganna one.
    05. Ube dan thiyena questions table ekata danna one correct answer column ekak, int ekak nam wada hodai, AnS1 nam, 1 anna ea wage.

    Help ekak one nam kiyapan

    Ade macho sample code ekak balanna link ekak hoyaganna bari weida? mama mey krame gana ahalama na...
     

    testnew3

    Member
    Oct 13, 2016
    148
    13
    0
    Ade macho sample code ekak balanna link ekak hoyaganna bari weida? mama mey krame gana ahalama na...

    ube code eke db eken data ganan part ekath karala neda thiyenne ?

    Apita one ekama sample code ne ban. Hari theory eka oluwata daganin sample ekakin, in passe creative wiyan.
     

    argan

    Well-known member
  • Jul 27, 2007
    16,100
    2,076
    113
    37
    <<< Benthara Gangen Eha >>>
    api saralawa wede patan gamu, dan hadala thiyena eken.

    01. Common UI ekak one, dan hadala thiyena form ekath ok.
    02. Questions set eka List<Question> ekakata load karaganna one db eken.
    03. Next karama, api list eken ilaga question eka aran penwanawa.
    04. Finally Submit karama api u dipu answers set eka thawa table ekakata save karaganna one.
    05. Ube dan thiyena questions table ekata danna one correct answer column ekak, int ekak nam wada hodai, AnS1 nam, 1 anna ea wage.

    Help ekak one nam kiyapan

    Hari macho net eken hoyaganna List eka haduwa mehema....

    public class Quiz
    {
    public int qid { get; set; }
    public string qtitle { get; set; }
    public string ans1 { get; set; }
    public string ans2 { get; set; }
    public string ans3 { get; set; }
    public string ans4 { get; set; }
    public int unitno { get; set; }

    }


    con.Open();
    cmd = new SqlCommand("SELECT * FROM Quiz WHERE UnitNo=1", con);
    SqlDataReader reader = cmd.ExecuteReader();
    List<Quiz> qui = new List<Quiz>();
    while (reader.Read())
    {
    Quiz q = new Quiz();
    q.qid = (int)reader["QID"];
    q.qtitle = (string)reader["Qtitle"];
    q.ans1 = (string)reader["Ans1"];
    q.ans2 = (string)reader["Ans2"];
    q.ans3 = (string)reader["Ans3"];
    q.ans4 = (string)reader["Ans4"];
    q.unitno = (int)reader["UnitNo"];
    qui.Add(q);
    }

    Database eke table eken list ekata load kara loop eken...dan mata podi help ekak denna mey tika form ekata dynamically load karaganna...next button eka click karama yannath oni...Questions 25k load karanna thiyenawa MCQ 4 answers ekka....

    mehema podi try ekak dunna....items load wei wage eth mata button eka click karama next form ekata load karaganna eka meter wennema naane :(


    int countLoop=1;
    con.Open();
    cmd = new SqlCommand("SELECT * FROM Quiz WHERE UnitNo=1", con);
    SqlDataReader reader = cmd.ExecuteReader();
    List<Quiz> qui = new List<Quiz>();
    while (reader.Read())
    {
    Quiz q = new Quiz();
    q.qid = (int)reader["QID"];
    q.qtitle = (string)reader["Qtitle"];
    q.ans1 = (string)reader["Ans1"];
    q.ans2 = (string)reader["Ans2"];
    q.ans3 = (string)reader["Ans3"];
    q.ans4 = (string)reader["Ans4"];
    q.unitno = (int)reader["UnitNo"];
    qui.Add(q);

    Label[] label = new Label[5];
    RadioButton[] radioButton = new RadioButton[3];

    panel2.Location = new Point(50, 60);
    panel2.Size = new Size(485, 320);
    panel2.BackColor = Color.Pink;
    this.Controls.Add(panel2);//newly created panel added to this Form

    label[countLoop] = new Label();
    label[countLoop].Text = q.qtitle;
    label[countLoop].Location = new Point(10, 20);
    label[countLoop].Size = new Size(425, 25);
    label[countLoop].Font = new Font("Verdana", 10, FontStyle.Bold);
    label[countLoop].ForeColor = Color.Red;

    panel2.Controls.Add(label[countLoop]);
    countLoop++;
    }