VB.NET Programming Corner!

[kiLLeR-eyEd_14]

Guys, I just want to ask if anybody here knows how to integrate a coin slot to a computer..I don't need a timer, I just want the coin slot to be triggered and send a response to the computer so that the software would receive it and perform the rest..I am planning to propose a pay phone text messaging or without a phone, how do i call that? pay text messaging..Could someone give me a good name for it? Coin2SMS? I need your suggestions and help..I also want to ask what sms gateway do you recommend..I'm trying to make it myself with my two group mates without collaborating with CoE students in our school..Btw, I want to use VB.Net as the programming language..

 

[bob_frog]

mga sir, pwede po ba na mangyari na ilagay sa array ung checkboxes??
meron pong limang checkboxes.

tapos po eh kung ano ung selected or mga selected
ay magrerecord sa database po??

how??

 

[kiLLeR-eyEd_14]

mga sir, pwede po ba na mangyari na ilagay sa array ung checkboxes??
meron pong limang checkboxes.

tapos po eh kung ano ung selected or mga selected
ay magrerecord sa database po??

how??

post mu ung codes mo..sadya nmn talaga naka array ang checkboxes..kung hawak ko codes mo, bka maaayos ko yan..mdali lng yan..google mu lng dn yang vb.net checkboxes array..d ko lam pero parang nsa for each lng ang kasagutan nyan..

try mu kung merong For each urcheckbox as selectedcheckbox in checkbox.checked..tapos imessage box mu ung selectedcheckbox..d ko sure..kung hawak ko ung codes mo, bka mafix ko yn..

 

[dheorwyne]

mga sir pa help po..

ang problema error cya sa conversiion from strning to decimal..
example ung _sss = textbox.text error cya.. pero kpg ung na declare ko naman na value is 0.00 ay gumagana.. eh ung na declare ko na value ng text box is 0.00 same sa declare ko na 0.00 na value.. ang pagkakaiba lng is object at given value.. ayaw kc mag compute ng currency eh.. cdec() gamit ko.. pls help..


ty.. this code working naman pero kpg na uncomment ko ung mga textbox.. not working na.. at

ganto naman ginawa ko sample na given value..
_ph = "0.00" : _tax = "0.00" : _pf = "0.00"
_loan = "0.00" : _hdmf = "50.00" : _others = "0.00"
_cola = "0.00" : _allowance = "0.00"

Dim _Total, _Deduct, _Charges As String
Dim _sss, _tax, _pf, _ph, _loan, _others, _hdmf, _cola, _allowance As String

'_sss = txtSSS.text : _ph = txtPH.text : _tax = txtInTax.text : _pf = txtPF.text
'_loan = txtLoan.Text : _hdmf = txtHDMF.Text : _others = txtOther.Text
'_cola = txtCola.ToString : _allowance = txtAllowance.ToString

'
_ph = "0.00" : _tax = "0.00" : _pf = "0.00"
_loan = "0.00" : _hdmf = "50.00" : _others = "0.00"
_cola = "0.00" : _allowance = "0.00"

_Charges = CDec(_cola) + CDec(_allowance)
_Deduct = CDec(_sss) + CDec(_tax) + CDec(_pf) + CDec(_ph) + CDec(_loan) + CDec(_hdmf) + CDec(_others)

_Total = CDec(_Charges) - CDec(_Deduct)

lblDeduct.Text = Format((_Deduct), "currency")
lblTotal.Text = FormatCurrency((_Total), 2, TriState.True, TriState.False, TriState.True)

 

[bob_frog]

post mu ung codes mo..sadya nmn talaga naka array ang checkboxes..kung hawak ko codes mo, bka maaayos ko yan..mdali lng yan..google mu lng dn yang vb.net checkboxes array..d ko lam pero parang nsa for each lng ang kasagutan nyan..

try mu kung merong For each urcheckbox as selectedcheckbox in checkbox.checked..tapos imessage box mu ung selectedcheckbox..d ko sure..kung hawak ko ung codes mo, bka mafix ko yn..

un nga prob ko sir eh.. di ko alam kung pano sisimulan..
ung limang checkboxes my iba ibang pangalan po un..
felling ko hindi po un nakaarray kse nga diff names

 

[aaronjames03]

try mo yung mga links na nasa first post, basic yung mga yun.
pwede natin pagtulungan kung anon topic ang ituturo mo at kung ano ang laman,
para naman di mahuli yung mga students mo
madami ako pde i share ng coding techniques para sa kanila

ts patambay tnx sa pggwa ng thread na to ..

 

[natori]

salamat po dito

hope makakatulong at may maraming pang tulong na maibigay,,

need ko talaga for my VB major, gagawa kami ng programs

tnx ulit

 

[addictedderzthine42]

cnung mabait dito n mag upload ng install shield for vs2010
tagal ksi ma download ee..
nakikigamit lang ako ng pc di rin makadownload sa bahay.
salamat

 

[yahjla]

nice thread TS

 

[hmx_ryan]

mga sir, pwede po ba na mangyari na ilagay sa array ung checkboxes??
meron pong limang checkboxes.

tapos po eh kung ano ung selected or mga selected
ay magrerecord sa database po??

how??

You could use CheckListBox..

 

[eidecedie17]

ano po ba ibig sabihin ng nested relationship?

 

[Eye Switcher]

Mga sir panu po b ang proper ng pag update insert at delete sa ms access using oledb? . .

po in advance

 

[3xpl0r3r]

sr polens, Nagawa q n ung Threading n cnsv mo.. hnd n hang ung apps q,, eto nman prob q ngaun, nauuna matapos ung progress bar q kesa dun s sqlserver connection q. ang gusto q po sanang manyare eh sbay sila matapos. pwd po b un sir?
tnx

 

[polens]

sr polens, Nagawa q n ung Threading n cnsv mo.. hnd n hang ung apps q,, eto nman prob q ngaun, nauuna matapos ung progress bar q kesa dun s sqlserver connection q. ang gusto q po sanang manyare eh sbay sila matapos. pwd po b un sir?
tnx

i think mahirap na gawin un. .tansain mo lng ung time sa pagconnect tapos mag add ka lng para sure...

for example eto sa name generator ko..

System.Threading.Thread.Sleep(500)
                worker.ReportProgress(x / 1000 * 100)

ung x ko dyan eh asa loop

for x=0 to 1000
next

ex..
ung x=1
so(1/1000)=.001 * 100 = 0.1 so habang nag iinsert ako sumasabay sa progress bar...
thats the idea...

 

[3xpl0r3r]

i think mahirap na gawin un. .tansain mo lng ung time sa pagconnect tapos mag add ka lng para sure...

for example eto sa name generator ko..

System.Threading.Thread.Sleep(500)
                worker.ReportProgress(x / 1000 * 100)

ung x ko dyan eh asa loop

for x=0 to 1000
next

ex..
ung x=1
so(1/1000)=.001 * 100 = 0.1 so habang nag iinsert ako sumasabay sa progress bar...
thats the idea...

ah cge bossong aralin q yan.. salamat ulit..

 

[dheorwyne]

ayaw po gumana ng loop.. ung first record lng na dedetect nya kht may for loop naman.. sinu po may alam na way para mai add ang timevalue from db na naka loop.. pa revise na lang po ng code sa may nakakaalam.. salamat

i have 3 records from fieldname: dtr_grantotal:

= 10:41:00
= 01:11:00
= 03:30:10

sqlSTR = "select * from tblTImelog where dtr_datelog Between '" & DateTimePicker1.Text & "' AND '" & DateTimePicker2.Text & "'"
ExecuteSQLQuery(sqlSTR)

_totalDays = sqlDT.Rows.Count

If sqlDT.Rows.Count > 0 Then
Dim T1 As String = "00:00:00"
Dim myRow As DataRow = sqlDT.Rows(sqlDT.Rows.Count - 1)
Dim span1 As TimeSpan = TimeSpan.Parse(T1)

For i = 0 To sqlDT.Rows.Count - 1
Dim span2 As TimeSpan = TimeSpan.Parse(sqlDT.Rows(i)("dtr_grandtotal"))
t1 = span1.Add(span2).ToString
Next

MsgBox(t1)
End If

FIX:

For i = 0 To sqlDT.Rows.Count - 1
Dim span2 As TimeSpan = TimeSpan.Parse(sqlDT.Rows(i)("dtr_grandtotal"))
span1 = span1.Add(span2)
Next

t1 = span1.ToString
MsgBox(t1)

pinapakita lng ng msgbox ung fisrt.. at hnd cya nag aadd.. any help?


nasolve ko na po.. na edit ko narin ung fix code para sa mga need ng ganyan.. very use full pa yan kapag nag aadd ng time from db.. thank you..

 

[polens]

ayaw po gumana ng loop.. ung first record lng na dedetect nya kht may for loop naman.. sinu po may alam na way para mai add ang timevalue from db na naka loop.. pa revise na lang po ng code sa may nakakaalam.. salamat

i have 3 records from fieldname: dtr_grantotal:

= 10:41:00
= 01:11:00
= 03:30:10

pinapakita lng ng msgbox ung fisrt.. at hnd cya nag aadd.. any help?

sqlSTR = "select * from tblTImelog where dtr_datelog Between '" & DateTimePicker1.Text & "' AND '" & DateTimePicker2.Text & "'"
ExecuteSQLQuery(sqlSTR)

_totalDays = sqlDT.Rows.Count

If sqlDT.Rows.Count > 0 Then
Dim T1 As String = "00:00:00"
Dim myRow As DataRow = sqlDT.Rows(sqlDT.Rows.Count - 1)
Dim span1 As TimeSpan = TimeSpan.Parse(T1)

For i = 0 To sqlDT.Rows.Count - 1
Dim span2 As TimeSpan = TimeSpan.Parse(sqlDT.Rows(i)("dtr_grandtotal"))
t1 = span1.Add(span2).ToString
Next 

MsgBox(t1)
End If

direct to the point sir...
medyo magulo kasi..

ang ngyayari kasi sa code mo eh ung last record ang pumupunta sa T1 mo...
loop 0:T1=first record
loop 1:T1=second record
loop 2:T1=last record

declare mo kasi as string lng ung T1
kaya ang nagyayari eh wala laging new data ang pumupunta sa T1 mo..

lagay mo ung messagebox sa loob ng loop

anyway anong purpose? pinapaikot mo lng ung code

 

[rijolo012593]

Mga ka symb, pa naman po.

Sa pagsisave po ng record, ok naman po siya kaya lang tinatanggap nea lahat ng gusto kong ilagay.
Ang gusto ko po sana mangyari is kapag nag'input ako ng username na meron na sa database ko, may lalabas po na msgbox na nagsasabing may nagmamay'ari na ng ganong account. Ung txtUsername lang po ang di pwede maduplicate, pero ung password tsaka mga email, pwede po maduplicate.

Sana po matulungan neu ako.

Ito po yung code ko.

Private Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click
Dim sqlconn As New SqlConnection("data source=.\SQLEXPRESS;Initial Catalog=EmailSender;Integrated Security=True")
Dim sqlda As New SqlDataAdapter
Dim sqlcmd As New SqlCommand
Dim dt As New DataTable

Try
sqlconn.Open()
Dim sqlstr As String = "insert into tblLogIn (Username,Password,GmailEmail,GmailPassword,YahooEmail,YahooPassword,HotmailEmail,HotmailPassword) values ('" _
& txtUsername.Text & "','" _
& txtPassword.Text & "','" _
& txtGmailEmail.Text & "','" _
& txtGmailPassword.Text & "','" _
& txtYahooEmail.Text & "','" _
& txtYahooPassword.Text & "','" _
& txtHotmailEmail.Text & "','" _
& txtHotmailPassword.Text & "') where not exists (select Username from tblLogIn where Username='Username')"
sqlcmd = New SqlCommand(sqlstr, sqlconn)
Dim icount = sqlcmd.ExecuteNonQuery
sqlconn.Close()
MessageBox.Show("Accout has been saved!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information)
Catch ex As Exception
MsgBox("This account has an owner", MsgBoxStyle.Exclamation + vbYesNo, "Error")

End Try


End Sub

All help will be appreciated. mga ka Symb.

 

[Eye Switcher]

padaan po. .. heheh

 

[dheorwyne]

Mga ka symb, pa naman po.

Sa pagsisave po ng record, ok naman po siya kaya lang tinatanggap nea lahat ng gusto kong ilagay.
Ang gusto ko po sana mangyari is kapag nag'input ako ng username na meron na sa database ko, may lalabas po na msgbox na nagsasabing may nagmamay'ari na ng ganong account. Ung txtUsername lang po ang di pwede maduplicate, pero ung password tsaka mga email, pwede po maduplicate.

Sana po matulungan neu ako.

Ito po yung code ko.




All help will be appreciated. mga ka Symb.

sir gamit ka muna ng selct statement na may where na nag eequal dun sa ini input mo.. then kpg nag recordcount > 0 then dun mo lagay ang warning u na bawal ma save kc meron ng ganun.. then if recordcount is 0 then save u ang insert query mo..
mas maganda kng gawa ka ng function na boolean sir.. na ilalagay mo dun ang select where query mo na true or false.. para tawagin u na lang.. bigyan lng kta idea.. pero kaya u yan sir.. recorcount sa vb6.. rows.count naman sa vb.net..

bigyan kita idea.. ung login d b.. kpg mali ang input which is wrong and connat process.. same din ang method jan sir.. na kpg worng login means save.. hehe.. bsta ganun lng.. laruin u lng ang idea sir..