Closed Project vb.net help

[xValk]

hi goodeve po pwde po magpatulong about sa vb.net and connecting data base.

here is my idea to my project.
gagawa sana ko game like who wants to be a millionaire ung gameplay.but ung questions nya is nakarandomize galing sa database.

if possible po .give me some tips or hint .baguhan lng po sa pag porprogram.saba po ay matulungan nyo ko.

 

[unknown3128]

I wish i can join but im not programmer, im just a fixer like formating computer,removing virus kinda etc like that.

 

[xValk]

I wish i can join but im not programmer, im just a fixer like formating computer,removing antivirus kinda like that.

still thanks .do you know how to fix external hd?

 

[damnpython]

Nakagawa rin ako ng ganitong game before, but in C# though hindi ko na alam saan ko nalagay haha.

Before the tips, ask yourself first: Para saan ba tong app na to, for deployment sa store or school project?
Another is, anong alam mong database na gamitin?

Most of the time, I would use ADO.NET since smaller and easy deployment compared to others.

Now, let's move on to the tips kung paano gawin yung randomization ng questions.

Ilagay mo yung questions mo sa database with this format.
QuestionID | Question | Choice 1 | Choice 2 | Choice 3 | Choice 4 | CorrectAns
1 | What does SQL stands for? | Structured Query Language | Simple Query Language | Saving Query Language | Stored Query Language | Structured Query Language

Then, sa code-behind mo. Gawa ka ng method na mag-gegenerate ng RANDOM numbers. Note: Ang range is the total number of your questions. For example, meron kang 50 questions in total so ofourse i-set mo to 50 yung range ng RANDOM variable mo. BUT WHY?
- The answer is, once nakagenerate ka na ng random number pwede mo ng i-retrieve yung data galing sa database mo then make a method para sa assigning of data into your respective textbox.

You get the idea.

 

[xValk]

Nakagawa rin ako ng ganitong game before, but in C# though hindi ko na alam saan ko nalagay haha.

Before the tips, ask yourself first: Para saan ba tong app na to, for deployment sa store or school project?
Another is, anong alam mong database na gamitin?

Most of the time, I would use ADO.NET since smaller and easy deployment compared to others.

Now, let's move on to the tips kung paano gawin yung randomization ng questions.

Ilagay mo yung questions mo sa database with this format.
QuestionID | Question | Choice 1 | Choice 2 | Choice 3 | Choice 4 | CorrectAns
1 | What does SQL stands for? | Structured Query Language | Simple Query Language | Saving Query Language | Stored Query Language | Structured Query Language

Then, sa code-behind mo. Gawa ka ng method na mag-gegenerate ng RANDOM numbers. Note: Ang range is the total number of your questions. For example, meron kang 50 questions in total so ofourse i-set mo to 50 yung range ng RANDOM variable mo. BUT WHY?
- The answer is, once nakagenerate ka na ng random number pwede mo ng i-retrieve yung data galing sa database mo then make a method para sa assigning of data into your respective textbox.

You get the idea.

salamat po sir.mejo na enlighten ako sa sinabi mo.and nadagdagan ung ideas ko kung pano ko sya magagawa.

 

[xValk]

ung sa pag generate ko ng random question.pano po kapag nag generate ulit dapat hindi nya na uulitin ung na generate. using if statement po ba?

 

[damnpython]

Using a storage called "List" po. Eto po po sample You do not have permission to view the full content of this post. Log in or register now.

 

[xValk]

Using a storage called "List" po. Eto po po sample You do not have permission to view the full content of this post. Log in or register now.

ahh salamat po .update ko po dito kapag nagsimula na kami mag code.still on lectures pa prof namin.

 

[Boylabo09]

satingin ko try mo gumamit ng random command, then ang i rarandom is ung index ng databases.