VB.Net Badly need help March 30 na po i dedefend

[rocketpuncher]

Pa tulong po sa mga expert sa vb I created a voting system po
and im almost done pwera nalang po on how to count votes po please patulong po kung pano dun nalang po talaga ako nahihirapan salamat po
View attachment 208708
ganyan po sya pag kinclik yung 2ne1 party list lahat ng member ng 2ne1
View attachment 208706
then yan po yung sa database ko pano po makukuha yung value ng Id_no kung nasa ibang table na po sya
and yung pong halimbawa President yung po dapat malagay 1 or 2 lang po means 1 for partylist 1(2NE1) and 2 for party list 2(SNSD)

 

[takeyourfreedom]

Ano database mo ts?

 

[rocketpuncher]

My Sql po kuya

 

[kizzbonez]

use INNER JOIN

 

[akosiken23]

Pa tulong po sa mga expert sa vb I created a voting system po
and im almost done pwera nalang po on how to count votes po please patulong po kung pano dun nalang po talaga ako nahihirapan salamat po
View attachment 1017974
ganyan po sya pag kinclik yung 2ne1 party list lahat ng member ng 2ne1
View attachment 1017972
then yan po yung sa database ko pano po makukuha yung value ng Id_no kung nasa ibang table na po sya
and yung pong halimbawa President yung po dapat malagay 1 or 2 lang po means 1 for partylist 1(2NE1) and 2 for party list 2(SNSD)

kulang ka sa diskarte TS eh
sama mo sa database mo kung sinu ung mag vote
para mas madaling ma total dba ^_^

tsaka sa database mag kakatalo yan eh

 

[maskio]

Pa tulong po sa mga expert sa vb I created a voting system po
and im almost done pwera nalang po on how to count votes po please patulong po kung pano dun nalang po talaga ako nahihirapan salamat po
View attachment 1017974
ganyan po sya pag kinclik yung 2ne1 party list lahat ng member ng 2ne1
View attachment 1017972
then yan po yung sa database ko pano po makukuha yung value ng Id_no kung nasa ibang table na po sya
and yung pong halimbawa President yung po dapat malagay 1 or 2 lang po means 1 for partylist 1(2NE1) and 2 for party list 2(SNSD)

ok considering ng structure ng database. please add column kung sino ang nag vote, name or id, ikaw na bahala.

regarding sa pag count.

select count(president) `votes` FROM tblvotes GROUP by president;
select count(vice_pres) `votes` FROM tblvotes GROUP by vice_pres;
so on and so forth

 

[rocketpuncher]

kulang ka sa diskarte TS eh
sama mo sa database mo kung sinu ung mag vote
para mas madaling ma total dba ^_^

tsaka sa database mag kakatalo yan eh

Yung pong Id_No yun po yung Id_No ng student na boboto sir. nasa ibang table na po sya

- - - Updated - - -

kulang ka sa diskarte TS eh
sama mo sa database mo kung sinu ung mag vote
para mas madaling ma total dba ^_^

tsaka sa database mag kakatalo yan eh

ok considering ng structure ng database. please add column kung sino ang nag vote, name or id, ikaw na bahala.

regarding sa pag count.

select count(president) `votes` FROM tblvotes GROUP by president;
select count(vice_pres) `votes` FROM tblvotes GROUP by vice_pres;
so on and so forth

sir yung pung Id_No yun na po yung kung sino student na nag vote View attachment 208833

bale yung Id_No na po sana mag sisilbeng batayan na pag nag vote na sya d na ulit makaka pag vote

 

[maskio]

Yung pong Id_No yun po yung Id_No ng student na boboto sir. nasa ibang table na po sya

- - - Updated - - -





sir yung pung Id_No yun na po yung kung sino student na nag vote View attachment 1018246

bale yung Id_No na po sana mag sisilbeng batayan na pag nag vote na sya d na ulit makaka pag vote

here you go:

 

[maskio]

and your query: