What's new
Symbianize Forum

Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.

All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!

VB.NET Programming Corner!

forbizdenz said:
sir patulong poh....kasi pag nag add ako ng unang data successful siya pero pangalawa na pataas ito po sinasabi nya " InvalidArgumen = 'Value of '4' is not 'valid for 'index'.
parameter name:index"..paano po ba ang tamang code sir???patulong naman po..ito po code ko..nkaatach na rin pix para sa detalye...

Code: 
 Sub savedata()
        Dim x As Integer
        Dim val As Integer
        Try


            If Not ListView1.Items.Count = 0 Then
                Do Until iloop = ListView1.Items.Count

                    Dim LvItem = ListView1.Items.Item(iloop)

                    With LvItem
                        If Me.Enabled = True Then


                            sqlQRY = "insert into LibTransaction(BorrowersID,BookNo,DateBorrow,DateDue,NoofCopy,Status)"
                            sqlQRY = sqlQRY & "values"
                            sqlQRY = sqlQRY & "('" & txtid1.Text & "','" & LvItem.SubItems(0).Text & "',#" & LvItem.SubItems(3).Text & "#,#" & LvItem.SubItems(4).Text & "#, '" & LvItem.SubItems(5).Text & "','" & a & "')"
                            cmd = New OleDbCommand(sqlQRY, conn)
                            cmd.ExecuteNonQuery()

                            sqlQRY = "select BookRemain from BookInfo where BookNo = '" & LvItem.SubItems(0).Text & "' "
                            cmd = New OleDbCommand(sqlQRY, conn)
                            cmd.ExecuteNonQuery()

                            dr = cmd.ExecuteReader
                            dr.Read()
                            x = dr("BookRemain")
                            dr.Close()


                            val = Integer.Parse(x)
                            Num = val - Integer.Parse(LvItem.SubItems(5).Text)
                            LvItem.SubItems(5).Text = Num

                            sqlQRY = "Update BookInfo Set BookRemain ='" & LvItem.SubItems(5).Text & "' where BookNo ='" & LvItem.SubItems(0).Text & "'"
                            cmd = New OleDbCommand(sqlQRY, conn)
                            cmd.ExecuteNonQuery()



                        Else

                        End If

                    End With

                    iloop = iloop + 1
                    LvItem = Nothing
                Loop
            End If
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
        End Try
    End Sub
Click to expand...

possible yung listview na nacacall mo is null or wala kaya mo nerereceive yang error na yan
 
Pano po ba ang codes nito? Sa Log In form may nilagay akong link label na forgot pw pag pinindot, dito sya punta (attachment) may security question akong table sa database tapos may sagot un may form din na para dun. Ang mangyayari pag nakalimutan pw dito punta sa secret question tapos sa combo box i loload ung mga tanong, sa answer dapat tugma dun sa sagot na nandun sa table para sa question, pag tugma may lalabas na msg box tapos nakalagay dun ung password pag mali, try again naman lalabas. :help:

e2 palang ung codes ko:

Imports MySql.Data.MySqlClient
Public Class ForgotPassword
Public cn As New MySqlConnection
Public da As New MySqlDataAdapter
Public cmd As New MySqlCommand
Public ds As New DataSet

Private Sub ForgotPassword_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cn = New MySqlConnection
cn.ConnectionString = "server=localhost;User Id=root;password=root;database=dbkk"
cn.Open()
Call lagayques()
End Sub
Sub lagayques()
da = New MySqlDataAdapter("select * from tbl_ques", cn)
ds = New DataSet
da.Fill(ds, 0)
For a As Integer = 0 To ds.Tables(0).Rows.Count - 1
ComboBox1.Items.Add(ds.Tables(0).Rows(a).Item(1).ToString)

Next
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
da = New MySqlDataAdapter("select * from tbl_ques", cn)
ds = New DataSet
da.Fill(ds, 0)
If TextBox2.Text = ds.Tables(0).Rows(0).Item(2).ToString Then

End If
End Sub
End Class
 

Attachments

  • Forgot pw.JPG
    Forgot pw.JPG
    25.5 KB · Views: 8
kennethlaurence029 said:
Pano po ba ang codes nito? Sa Log In form may nilagay akong link label na forgot pw pag pinindot, dito sya punta (attachment) may security question akong table sa database tapos may sagot un may form din na para dun. Ang mangyayari pag nakalimutan pw dito punta sa secret question tapos sa combo box i loload ung mga tanong, sa answer dapat tugma dun sa sagot na nandun sa table para sa question, pag tugma may lalabas na msg box tapos nakalagay dun ung password pag mali, try again naman lalabas. :help:

e2 palang ung codes ko:

Imports MySql.Data.MySqlClient
Public Class ForgotPassword
Public cn As New MySqlConnection
Public da As New MySqlDataAdapter
Public cmd As New MySqlCommand
Public ds As New DataSet

Private Sub ForgotPassword_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cn = New MySqlConnection
cn.ConnectionString = "server=localhost;User Id=root;password=root;database=dbkk"
cn.Open()
Call lagayques()
End Sub
Sub lagayques()
da = New MySqlDataAdapter("select * from tbl_ques", cn)
ds = New DataSet
da.Fill(ds, 0)
For a As Integer = 0 To ds.Tables(0).Rows.Count - 1
ComboBox1.Items.Add(ds.Tables(0).Rows(a).Item(1).ToString)

Next
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
da = New MySqlDataAdapter("select * from tbl_ques", cn)
ds = New DataSet
da.Fill(ds, 0)
If TextBox2.Text = ds.Tables(0).Rows(0).Item(2).ToString Then

End If
End Sub
End Class
Click to expand...

mag generate ka ng third table mo na ang laman table_id,userid,secret_question,answer
dyan mo ivavalidate para makuha mo ang password..
 
Last edited:
sorry po if re-post po ang question ko....:noidea:

ask lang po ako master kung anong korso ang compatible sa mga na share nyu pong program...kasi base lang sa aking observation more on sya sa software application...

sorry hindi ko na binasaha lahat ang post dito kasi ung pages ay sobrang haba na...hehehe

kakagraduate ko lang nung 2011 im ece not license...

plano ko kumuha another course Computer Science kasi mas comfortable ako pag dating sa software kaysa hardware..pero advisable ba kumuha ng master kaysa pang undergraduate ung may 4 yrs..?:noidea:
 
hello sir! pwede patulong sa system na ginagawa ko?
i need to make a system for our barangay. system printing. records. etc. pano po ba magkaron ng office viewer ang VS10 ko. para po kasi sa printing of permits etc. mdami na po ako nabasa, and na try like EDRAW office viewer pero may bayad po yung full version nun para magamit ko.. sana po matulungan nyo ko sir. thanks!!! :)))
 
winzmar said:
hello sir! pwede patulong sa system na ginagawa ko?
i need to make a system for our barangay. system printing. records. etc. pano po ba magkaron ng office viewer ang VS10 ko. para po kasi sa printing of permits etc. mdami na po ako nabasa, and na try like EDRAW office viewer pero may bayad po yung full version nun para magamit ko.. sana po matulungan nyo ko sir. thanks!!! :)))
Click to expand...

di ko magets kung anong office viewer ang tinutukoy mo?
 
MGA SIR PENGE PO LINK NG FREE DOWNLOAD NG EBOOK FOR VISUAL BASIC.NET and LINK po kng san makakadownload ng installer ng vb.net.. Maraming salamat po sa tutulong
 
hello po mga sir.. :)

maari nyo po ba akong 2lungan kung pno ko po pdeng plabasin ung info ng specific element sa label in another form... ung system po kc nmin is prang interactive periodic table po tpos pgclinick ung isang element may bbukas na another form tpos isshow nya po ung info about sa element na un.. bale nsa database po ung info ng lht ng element tpos sa isang form lng po cla lhat mgsshow depende lng po sa icclick na element.. slmat po sa 22long :)
 
mga sir possible po ba na makagawa ng Internet Cafe server using VB? kasi po thesis namin eh... pa help namn po............:praise:
 
Mga Sirs pwede pa tulong need help lang.....
paano ba mag open ng cash drawer with rj11 ang port in visual studio 2005.... thnx in advance pohh mga sir :pray:
 
mjoy12 said:
hello po mga sir.. :)

maari nyo po ba akong 2lungan kung pno ko po pdeng plabasin ung info ng specific element sa label in another form... ung system po kc nmin is prang interactive periodic table po tpos pgclinick ung isang element may bbukas na another form tpos isshow nya po ung info about sa element na un.. bale nsa database po ung info ng lht ng element tpos sa isang form lng po cla lhat mgsshow depende lng po sa icclick na element.. slmat po sa 22long :)
Click to expand...

oo, pwede yan.. at madali lang.... pag-aralan nyo muna ang database design, -data normalization... swerte at meron na kayo resources.. ang periodic table.
 
Mga bossing sino ba may code ng pag read ng sms using AT command with vb or c#(be displayed sa list box or other win form),salamat..
 
Guys ask ko lang , about sa c#.net, kasi gumagawa ako ng parang gantt chart module ba.

Meron akong gridview na ganito ang headers:

[Project Name][Details] [1][2][3][4][5][6]

Ngayon ang gusto ko mangyari is, ganito:

[Project Name][Details] [1][2][3][4][5][6]
Name One Test 2
Name Two Test Uli 3

Where in yung values "2" at "3", e sa database galing.
Any ideas kung paano at saan ako magsisimula para maachieve itong goal na ito?
 
sir baka pwd tulungan nyo kami need q sir ung sample system sir n nag add ung id sa database using biometric digital persona po ung brand ng biometric nmin puro template lng kc sample code n n saamin sir plllssss help sir..:pray::pray::pray::pray:
 
ykheenL said:
sir baka pwd tulungan nyo kami need q sir ung sample system sir n nag add ung id sa database using biometric digital persona po ung brand ng biometric nmin puro template lng kc sample code n n saamin sir plllssss help sir..:pray::pray::pray::pray:
Click to expand...

try to explore the codes on those sample system by digitalPersona, that's what i did and i create my own technique which is to save the fingerprint template name in database
 
fuzzy06 said:
try to explore the codes on those sample system by digitalPersona, that's what i did and i create my own technique which is to save the fingerprint template name in database
Click to expand...


meron po kmi codes pero puro template lng then verify pero di po nmin magawa magsave sa database nung template gusto kc nmin gawin ung fingerprint gawing primary key as id
 
knives645 said:
oo, pwede yan.. at madali lang.... pag-aralan nyo muna ang database design, -data normalization... swerte at meron na kayo resources.. ang periodic table.
Click to expand...

gud eve po sir, sa tingin ko po nagawa ko na po sya :), ittanong ko lang po kung wala po bng issue regarding sa normalization if ilalagay ko po lhat ng info sa isang table?? msyado po kc syang marami tulad po nung element name, symbol, group number, classification, etc.. microsoft SQL server management studio po ang gamit namin na DB

slamat po :salute:
 
boss, ask lang po, pagkatapos ko i'install ung visual studio 2005 ang lumalabas
"the application data folder for visual studio could not be created".
pero ung visual studio 2008, ok naman.
 
You must log in or register to reply here.

Similar threads

raven2709
Android (Kotlin & Java) Programming Corner!
Replies
1
Views
481
manlors
manlors
TambayBlues
Visual Studio 2023 - The Most Concise and Detailed Guide to Mastering all the Features and the Use of Visual Studio
Replies
0
Views
288
TambayBlues
TambayBlues
TambayBlues
Hands-On Visual Studio 2022: A Developer's Guide to New Features and Best Practices with .NET 8 and VS 2022 for Maximum Productivity, 2nd Edition
Replies
0
Views
304
TambayBlues
TambayBlues
Aimershin
[Udemy Course] PHP Registration Form, Email Verification & Responsive Email | Direct Download | Requested
Replies
7
Views
636
poiqwe
P
mythos
Cybersecurity Monitoring & Detection Lab
Replies
16
Views
2K
linuxspecialist
L
Back
Top Bottom