VB.NET Programming Corner!

[maskio]

Pahelp naman po mga sir, ganito po sana gusto kong gawin:

EmployeeIDNo. | MonthPaid | PaymentAmount | TotalPaymentAmount
1 | 1 | 500 | 500
1 | 2 | 500 | 1000
1 | 3 | 500 | 1500

Yung totalpayment po kasi yan po yung kabuoan ng paymentamount(binabayad)
ng borrower per month, bale kada bayad po inaadd lang sa totalpayment..

Nagkakaproblema po ako pag kukunin ko na yung pangatlong totalpayment,
ang nakuha nya po kasing value ng totalpayment yung sa panguna(500) parin..
kaya 1000 parin po nalabas. Yung employeeid din po kasi yung ginagamit
kong pangretrieve ng value kaya po siguro nagkakaganun.. paano po ba mangyayari
na ang pipiliin nya ng value yung sa pangalawang(1000) payment? ano po bang
gagawin ko? ito po kasi gustong makita ng prof. namin.

Pahelp po please!

make TotalPaymentAmount a running total.

for mysql
for mssql

**EDiT**
WHERE monthPaid <= 2, you get 1000 here
WHERE monthPaid <=3, you get 1500 here
etc....

**EDiT 2**
WHERE monthPaid = 2 and empId = 1;

kasi kung empId lang, you are getting the 1st row, which is 500, or you could; ORDER BY monthPaid DESC;

sorry too many edits, di ko na gets kaagad ang question. lol

 

[maskio]

@khernie09

change this code

strngsql = "SELECT * FROM LoanAppForm where EmployeeIDNumber='" & txtEmployeeIDNumber.Text & "'"

to

strngsql = string.format("SELECT * FROM LoanAppForm where EmployeeIDNumber='{0}' AND monthPaid = '{1}';", txtEmployeeIDNumber.text, [COLOR="Red"]IdOfMonthPaidHere[/COLOR])

you might also want to add the transaction no.
what if nag loan sya ulit.

 

[Verio]

mag run ka lang ng AGGREGATE QUERY (yung may SUM) para makuha mo ang total

make TotalPaymentAmount a running total.

for mysql
for mssql

**EDiT**
WHERE monthPaid <= 2, you get 1000 here
WHERE monthPaid <=3, you get 1500 here
etc....

**EDiT 2**
WHERE monthPaid = 2 and empId = 1;

kasi kung empId lang, you are getting the 1st row, which is 500, or you could; ORDER BY monthPaid DESC;

sorry too many edits, di ko na gets kaagad ang question. lol

@khernie09

change this code

strngsql = "SELECT * FROM LoanAppForm where EmployeeIDNumber='" & txtEmployeeIDNumber.Text & "'"

to

strngsql = string.format("SELECT * FROM LoanAppForm where EmployeeIDNumber='{0}' AND monthPaid = '{1}';", txtEmployeeIDNumber.text, [COLOR="Red"]IdOfMonthPaidHere[/COLOR])

you might also want to add the transaction no.
what if nag loan sya ulit.

Sige po mga sir, try ko po mga suggestion nyo.. salamat po

 

[cyrilkun]

AS I SAID
ITS ALL IN THE SQL COMMANDS

ang sql ang hindi lang SELECT * FROM Table
meron din
WHERE
ORDER BY
INNER JOIN
SUM
etc

ahh.. so I need to use SELECT* ORDER BY?

 

[maskio]

ahh.. so I need to use SELECT* ORDER BY?

SELECT * FROM table1 ORDER BY fname DESC;

you would get a sorted result from z to a; or if number largest to smallest, ASC [smallest to largest];

limit your queries to only what you need, do not always use *, instead, specify the fields you need.

SELECT * FROM table1;

if you only need 2 columns, then specify the 2 columns to avoid network traffic. also for faster query result.

SELECT column1, column2 FROM table1;

 

[cyrilkun]

SELECT * FROM table1 ORDER BY fname DESC;

you would get a sorted result from z to a; or if number largest to smallest, ASC [smallest to largest];

limit your queries to only what you need, do not always use *, instead, specify the fields you need.

SELECT * FROM table1;

if you only need 2 columns, then specify the 2 columns to avoid network traffic. also for faster query result.

SELECT column1, column2 FROM table1;

what about largest to smallest?

 

[maskio]

logically, pag nag qquery kayo, gawin nyo na tagalog ang query,

example,

gusto kong kuning ang mga pangalan na nag sisimula sa "M" na ang gender ay "MALE" na ang edad ay 25 pataas at gusto ko ang resulta ay naka sort mula pinaka matanda hanggang pa bata galing sa tableName

the query would then be.

SELECT name, age, gender FROM tableName WHERE name LIKE 'M%' AND gender = "MALE" AND age >= 25 ORDER BY age DESC;

and so on and so forth...

 

[ericgmejia]

So it seems marami pala ang di pa familiar sa SQL
Part talaga ng programming yan na nakakalimutan ituro sa school
sa interviews isa sa unang tinanatanong yan e.

and i posted several ebooks on this subject sa dropbox ko

like this one

 

[gregforlife]

hi guys. tanung q lng po s mga experts kung pde makonek ang application n gawa s vb.net s isang web service, like cloud database, sms service at web site. gnun kc ang thesis nmin naun, can someone answer me... salamat guys

 

[ericgmejia]

hi guys. tanung q lng po s mga experts kung pde makonek ang application n gawa s vb.net s isang web service, like cloud database, sms service at web site. gnun kc ang thesis nmin naun, can someone answer me... salamat guys

sa project po meron syang
ADD SERVICE REFERENCE

indicate lang yung URL ng web service

then gagamitin nyo na kagaya din kung papano tumawag ng class or function

try mo basahin to
http://www.codeproject.com/Articles/3783/Using-a-Web-Service-in-VB-NET

 

[maskio]

what about largest to smallest?

you would get a sorted result from z to a; or if number largest to smallest, ASC [smallest to largest];

ASC = ascending
DESC = descending

 

[freebiemen]

Help
Paano po magpaandar ng progressbar s pamamagitan ng timer within 15 secs. dpat puno na yung progress bar. At paano rin po kumuha ng ip address habang ginagamit niya ung prog ng hindi alam ng gumagamit at isesend po sa email yung ip. Thanks po in advance.

 

[maskio]

Help
Paano po magpaandar ng progressbar s pamamagitan ng timer within 15 secs. dpat puno na yung progress bar. At paano rin po kumuha ng ip address habang ginagamit niya ung prog ng hindi alam ng gumagamit at isesend po sa email yung ip. Thanks po in advance.

sa login mo kunin ang ip nya, but anyway, aling ip ba? WAN or LAN?
si progressbar, divide mo by 15 ang 100 set mo sa timer every 1000ms progressbar.value + yung na divide.
or set mo max value ng progressbar to 15 tapos every 1000ms value + 1.

esesend via email, di ko pa to na try... hmmm... para san ba yung program? ano ang ginagawa ng program?

if program = "good intention" then 
  help
else
  ignore
end if

 

[gregforlife]

sa project po meron syang
ADD SERVICE REFERENCE

indicate lang yung URL ng web service

then gagamitin nyo na kagaya din kung papano tumawag ng class or function

try mo basahin to
http://www.codeproject.com/Articles/3783/Using-a-Web-Service-in-VB-NET

Thanks sa information sr, until now kc confuse pdn aq panu q mcconnect ung 2... slamat ulit

 

[freebiemen]

Hirap ng pagproprogram tungkol sa mga networks. Required po kc to para s comp project 4th year. Yung WAN po b yung Wide Area Network o Wireless Area Network, at yung LAN po Local Area Network po d b? LAN po. Salamat po uli

 

[ericgmejia]

Help
Paano po magpaandar ng progressbar s pamamagitan ng timer within 15 secs. dpat puno na yung progress bar. At paano rin po kumuha ng ip address habang ginagamit niya ung prog ng hindi alam ng gumagamit at isesend po sa email yung ip. Thanks po in advance.

progressbar is generally NOT used to mark time, kaya nga progressbar kasi para indicator kung ilan % na yung nagawa

kung parating 15sec ang papalipasin mo, just place "pls wait" na banner.

meron services ang .NET framework para sa network so generally di na mahirap sa networks, i suggest familiarize mo sarili mo sa System.Net na namespace, nandun din yung sa emails
mahirap kung di familiar

just use your knowledge sa maayos na paraan
getting IP address na di nalalaman or anything na gagawin mo na di alam ng user ay isang PANLOLOKO,
be a programmer with integrity at may dangal, di porket kaya mo gawin e gagawin mo na.

btw, knowing IP address of a pc is not very usefull din unless meron ka ng process doon in the first place

 

[maskio]

Hirap ng pagproprogram tungkol sa mga networks. Required po kc to para s comp project 4th year. Yung WAN po b yung Wide Area Network o Wireless Area Network, at yung LAN po Local Area Network po d b? LAN po. Salamat po uli

tama yung wide area network, at local area network. magkaiba kasi ang ip addresses nyan. may sarili silang ip range, tsaka ipv4 ba o ipv6 ang kukunin?

 

[freebiemen]

IPv4 po

 

[jyxae19]

Mga Sir. Ano po bang problema sa SQL syntax ko? Sa tingin ko naman kasi po tama ang sql'syntax na ginamit ku. haysss..


ito po yung code ko.
chi-neck ku naman ku lahat. yung data type ng mga fields. ang mga column names. tama naman po lahat eh..

 Private Sub btnSubmit1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit1.Click
        If CONNECTION.State = ConnectionState.Closed Then
            CONNECTION.ConnectionString = "server=localhost;user=root;password=admin;database=cgs"
            CONNECTION.Open()
        End If

        strSQL = "INSERT INTO tbl_gradepercentages(t_id,subj_id,term_exam,projects,quizzes,oral,character,attendance) VALUES ('" & teachID & "','" & cmbSub.SelectedValue & "','" & txtTerm.Text & "','" & txtProj.Text & "','" & txtQuiz.Text & "','" & txtOral.Text & "','" & txtCharac.Text & "','" & txtAttend.Text & "')"

        With cmd
            .CommandText = strSQL
            .Connection = CONNECTION
            .ExecuteNonQuery()
        End With

        MsgBox("Added new record!")
  
    End Sub

Everytime po mag eeror..dun sa may .ExecuteNonQuery pinu-point out yung mali. tapus yung message ay ganito.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character,attendance) VALUES ('1','25','30','10','20','20','10','10')' at line 1


Hayyyss..

 

[ericgmejia]

Mga Sir. Ano po bang problema sa SQL syntax ko? Sa tingin ko naman kasi po tama ang sql'syntax na ginamit ku. haysss..


ito po yung code ko.
chi-neck ku naman ku lahat. yung data type ng mga fields. ang mga column names. tama naman po lahat eh..

 Private Sub btnSubmit1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit1.Click
        If CONNECTION.State = ConnectionState.Closed Then
            CONNECTION.ConnectionString = "server=localhost;user=root;password=admin;database=cgs"
            CONNECTION.Open()
        End If

        strSQL = "INSERT INTO tbl_gradepercentages(t_id,subj_id,term_exam,projects,quizzes,oral,character,attendance) VALUES ('" & teachID & "','" & cmbSub.SelectedValue & "','" & txtTerm.Text & "','" & txtProj.Text & "','" & txtQuiz.Text & "','" & txtOral.Text & "','" & txtCharac.Text & "','" & txtAttend.Text & "')"

        With cmd
            .CommandText = strSQL
            .Connection = CONNECTION
            .ExecuteNonQuery()
        End With

        MsgBox("Added new record!")
  
    End Sub

Everytime po mag eeror..dun sa may .ExecuteNonQuery pinu-point out yung mali. tapus yung message ay ganito.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character,attendance) VALUES ('1','25','30','10','20','20','10','10')' at line 1


Hayyyss..

hmmmn...
check mo nga baka reserved word yung 'character'
try mo palitan ng field name.
ganyan nangyari sakin dati, isang araw ko inaayos, reserved word pala

si @maskio ang expert pagdating sa mySQL, wait natin sagot nya