Home
Hey yah guys, Visual Basic Problem? YOU ARE FREE TO ASK ANY QUESTION REGARDING VB6 OR VB.NET,its my Pleasure to share my knowledge and serve my co-student :-)
4 posters
VB-MASTER Q:A
![[Mod]javest](https://2img.net/u/3311/12/05/48/avatars/13-21.jpg)
[Mod]javest- Moderator
- Posts : 28
Points : 49
Reputation : 2
Join date : 2009-12-09
Age : 34
Location : Antipolo
jamism- Admin
- Posts : 68
Points : 99
Reputation : 0
Join date : 2009-12-08
Location : City of Pasig
-=VB6=-
how can i save data to sql from listview? pwede ba un? sakit sa bangs eh... >_<
how can i save data to sql from listview? pwede ba un? sakit sa bangs eh... >_<
sub71- Posts : 3
Points : 3
Reputation : 0
Join date : 2009-12-09
Age : 34
Location : Underground
@pirate-javest27
pano po ba yung codes sa vb.net para hindi maghang yung application ko pag nagpprocess ako ng matagal. eto po yung sample ng codes na naghahang ang application:
for i as integer = 1 to 10000
'dito yung process
next
sana po masagot nyo agad. need ko lang po asap. tnx
pano po ba yung codes sa vb.net para hindi maghang yung application ko pag nagpprocess ako ng matagal. eto po yung sample ng codes na naghahang ang application:
for i as integer = 1 to 10000
'dito yung process
next
sana po masagot nyo agad. need ko lang po asap. tnx
Admin- Admin
- Posts : 58
Points : 88
Reputation : 0
Join date : 2009-12-08
Age : 35
Location : San Mateo, Rizal
Thanks private-javest27 for opening this topic.
[Mod]javest- Moderator
- Posts : 28
Points : 49
Reputation : 2
Join date : 2009-12-09
Age : 34
Location : Antipolo
@jam-
actually,marming praan pra makasave k nyan to sql database.. but to give an easy way out, kung ang problem mo is each item na iclick mo mpupunta sa database,pde k mag lagay ng isang textbox kung saan pde nya ibato ang nsa listbox
listbox1_ click()
listbox1.text=textbox1.text
end sub
tpoz ung nsa textbox ang ibato mu sa dbase using sql code.
kung gusto mu nmn lhat ng nsa listbox babato sa database ., u may use for loop statement =) getz mu ba ung logic ko? haha.. ask lng for more clarification .
actually,marming praan pra makasave k nyan to sql database.. but to give an easy way out, kung ang problem mo is each item na iclick mo mpupunta sa database,pde k mag lagay ng isang textbox kung saan pde nya ibato ang nsa listbox
listbox1_ click()
listbox1.text=textbox1.text
end sub
tpoz ung nsa textbox ang ibato mu sa dbase using sql code.
kung gusto mu nmn lhat ng nsa listbox babato sa database ., u may use for loop statement =) getz mu ba ung logic ko? haha.. ask lng for more clarification .
[Mod]javest- Moderator
- Posts : 28
Points : 49
Reputation : 2
Join date : 2009-12-09
Age : 34
Location : Antipolo
@sub71
- kung hindi nman po nag eeror ung statement mu, mining wlang mali sa codings, bka hindi kaya ng pc i log ung looping statement mu, kia xa nag ha.hang, f ever nmn, try mu mag error handler pra maiskip nya ung buggings, pero di ko sinasuggest na lage ka gumamit nun, bad programming ethic'et un =)
'sample of err handler code
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles Button1.Click
On Error GoTo nextstep
Dim result As Integer
Dim num As Integer
num = 100
result = num / 0
nextstep:
MsgBox("msg here")
End Sub
End Class
'or you can simly state
on error resume next
- kung hindi nman po nag eeror ung statement mu, mining wlang mali sa codings, bka hindi kaya ng pc i log ung looping statement mu, kia xa nag ha.hang, f ever nmn, try mu mag error handler pra maiskip nya ung buggings, pero di ko sinasuggest na lage ka gumamit nun, bad programming ethic'et un =)
'sample of err handler code
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles Button1.Click
On Error GoTo nextstep
Dim result As Integer
Dim num As Integer
num = 100
result = num / 0
nextstep:
MsgBox("msg here")
End Sub
End Class
'or you can simly state
on error resume next
jamism- Admin
- Posts : 68
Points : 99
Reputation : 0
Join date : 2009-12-08
Location : City of Pasig
hehe... okay na nagawa q na... yeah tama looping nga... thanks nadin at nag reply ka.. hehe
[Mod]javest- Moderator
- Posts : 28
Points : 49
Reputation : 2
Join date : 2009-12-09
Age : 34
Location : Antipolo
@jamism haha sowee late eply ala load e sloww haha!
ge lng.. :p
ge lng.. :p
sub71- Posts : 3
Points : 3
Reputation : 0
Join date : 2009-12-09
Age : 34
Location : Underground
pirate javest,
wala naman problema yung codes. ang ibig ko sabihin eh maghahang yung application hanggat hindi natatapos yung loop try mo gawin yung codes to find out what i really mean.
wala naman problema yung codes. ang ibig ko sabihin eh maghahang yung application hanggat hindi natatapos yung loop try mo gawin yung codes to find out what i really mean.
jamism- Admin
- Posts : 68
Points : 99
Reputation : 0
Join date : 2009-12-08
Location : City of Pasig
yan lumalabas sa code na to...
nag gaganyan lng sa 2nd log-in q... pero sa una okay nmn... after lng mag save ganyan nanyayari... >_< nka set nmn lahat sa module...
help me help me...
thanks
[Mod]javest- Moderator
- Posts : 28
Points : 49
Reputation : 2
Join date : 2009-12-09
Age : 34
Location : Antipolo
chek mo tong mga toh..
1. rs1 kung naka register sa module?
2.dapat sa combo properties wlang field name / datasourse
3. try this format
.Open "SELECT * FROM candidate WHERE positiondes LIKE '" & Trim(combo.text) & "%'ORDER BY field name mo d2", con, adOpenStatic, adLockOptimistic
or
rs.Open "SELECT candname FROM candname WHERE positiondes LIKE '" & Trim(combo.text) & "%'ORDER BY field name mo d2", con, adOpenStatic, adLockOptimistic
-lagay k ng field name na kung pnu mu i order by ung list. pde mu rin tanggalin nlng un.
1. rs1 kung naka register sa module?
2.dapat sa combo properties wlang field name / datasourse
3. try this format
.Open "SELECT * FROM candidate WHERE positiondes LIKE '" & Trim(combo.text) & "%'ORDER BY field name mo d2", con, adOpenStatic, adLockOptimistic
or
rs.Open "SELECT candname FROM candname WHERE positiondes LIKE '" & Trim(combo.text) & "%'ORDER BY field name mo d2", con, adOpenStatic, adLockOptimistic
-lagay k ng field name na kung pnu mu i order by ung list. pde mu rin tanggalin nlng un.
Last edited by [Mod]javest on Thu Dec 17, 2009 12:19 pm; edited 3 times in total (Reason for editing : .typo error)
|
|
|