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!

Help po, pano po ma access ang mySQL sever through network connection. . .


May Server aq, d2 naka intall un MySQL Server q... tapos may client PC aq kung san ko kelangan ma access yung MySQL server. . .

. . .please help po mga boss... TIAs
 
I made this thread for all programmers starting their adventure on VB.NET.

Please post relevant and sensible questions regarding VB.NET,
share your knowledge and expertise, share codes and techniques.

Post question on HOW TOs:
How to do this or that, ill supply bits of code to accomplish basic tasks.

Ill be posting series of samples leading to complete applications,
your suggestions are encouraged.
These samples will contain codes relevant to other tasks as well.

Platform = VS2003 to VS2010

i suggest learn and master the VB.NET IDE first before asking questions, so that we can talk on the same page.


Topics:
VB.NET Winforms (not Web Applications)
ADO.NET as applied in VB.NET
Crystal Reports on VB.NET
SQLServer as used in VB.NET
MSAccess as used in VB.NET
Classes
UserControls

Technologies:
Serial - like using SMS, Barcode and other hardware
TCP/IP - chat applications, sockets, internet applications
MSMQ - message queuing
Remoting - executing assemblies in other computer
WebServices - using webservices in windows forms
Multithreading - executing more than 1 process at the same time


Suggested Third Party Tools:
DevXPress 2009 Free Edition
SQLServer 2005 Express Edition

Suggested references:
http://www.homeandlearn.co.uk/net/vbnet.html
http://www.java2s.com/Tutorial/VB/CatalogVB.htm

I currently use Visual Studio 2008 only, but basic codes will apply to all versions

Please do not ask for a complete system,
instead use the codes and assistance that you will find here
to build your own system.


***Can somebody suggest to the moderators to make this thread sticky if you find it useful in your studies or work.

Lets share knowledge so that we can be a more flexible and well rounded programmer. Be it for school or work.

Links:

First Post: Populating DataGridView using MSAccess Database
Second Post : Basic VB.NET MSAccess Tutorial
SQLServer Sample



uhm. ...billing system po ang thesis namen..
vb.net po gamet ko...tanong ko lang po..pano po ba i-integrate ang barcode reader sa vb.net..
 
uhm. ...billing system po ang thesis namen..
vb.net po gamet ko...tanong ko lang po..pano po ba i-integrate ang barcode reader sa vb.net..

Meron pong tinatawag na SDK ang mga device. Dun niyo po kukunin ang mga function ng barcode. Kapag bumili po kayo ng new device, meron pong SDK yun at same time my mga samples po.
 
nahihirapan po ako i convert to sa vb.net itong php code na to:

ex:
<?php
for ($i = 'a'; $i != 'ako'; $i++)

{
echo "$i\n";
}

?>


ask ko lang po kung paano to sa .Net yun..:thanks: in advance!

Output:
a b c d e f g h i j k l m n o p q r s t u v w x y z aa ab ac ad ae af ag ah ai aj ak al am an ao ap aq ar as at au av aw ax ay az ba bb bc bd be bf bg bh bi bj bk bl bm bn bo bp bq br bs bt bu bv bw bx by bz ca cb cc cd ce cf cg ch ci cj ck cl cm cn co cp cq cr cs ct cu cv cw cx cy cz da db dc dd de df dg dh di dj dk dl dm dn do dp dq dr ds dt du dv dw dx dy dz ea eb ec ed ee ef eg eh ei ej ek el em en eo ep eq er es et eu ev ew ex ey ez fa fb fc fd fe ff fg fh fi fj fk fl fm fn fo fp fq fr fs ft fu fv fw fx fy fz ga gb gc gd ge gf gg gh gi gj gk gl gm gn go gp gq gr gs gt gu gv gw gx gy gz ha hb hc hd he hf hg hh hi hj hk hl hm hn ho hp hq hr hs ht hu hv hw hx hy hz ia ib ic id ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy iz ja jb jc jd je jf jg jh ji jj jk jl jm jn jo jp jq jr js jt ju jv jw jx jy jz ka kb kc kd ke kf kg kh ki kj kk kl km kn ko kp kq kr ks kt ku kv kw kx ky kz la lb lc ld le lf lg lh li lj lk ll lm ln lo lp lq lr ls lt lu lv lw lx ly lz ma mb mc md me mf mg mh mi mj mk ml mm mn mo mp mq mr ms mt mu mv mw mx my mz na nb nc nd ne nf ng nh ni nj nk nl nm nn no np nq nr ns nt nu nv nw nx ny nz oa ob oc od oe of og oh oi oj ok ol om on oo op oq or os ot ou ov ow ox oy oz pa pb pc pd pe pf pg ph pi pj pk pl pm pn po pp pq pr ps pt pu pv pw px py pz qa qb qc qd qe qf qg qh qi qj qk ql qm qn qo qp qq qr qs qt qu qv qw qx qy qz ra rb rc rd re rf rg rh ri rj rk rl rm rn ro rp rq rr rs rt ru rv rw rx ry rz sa sb sc sd se sf sg sh si sj sk sl sm sn so sp sq sr ss st su sv sw sx sy sz ta tb tc td te tf tg th ti tj tk tl tm tn to tp tq tr ts tt tu tv tw tx ty tz ua ub uc ud ue uf ug uh ui uj uk ul um un uo up uq ur us ut uu uv uw ux uy uz va vb vc vd ve vf vg vh vi vj vk vl vm vn vo vp vq vr vs vt vu vv vw vx vy vz wa wb wc wd we wf wg wh wi wj wk wl wm wn wo wp wq wr ws wt wu wv ww wx wy wz xa xb xc xd xe xf xg xh xi xj xk xl xm xn xo xp xq xr xs xt xu xv xw xx xy xz ya yb yc yd ye yf yg yh yi yj yk yl ym yn yo yp yq yr ys yt yu yv yw yx yy yz za zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv zw zx zy zz aaa aab aac aad aae aaf aag aah aai aaj aak aal aam aan aao aap aaq aar aas aat aau aav aaw aax aay aaz aba abb abc abd abe abf abg abh abi abj abk abl abm abn abo abp abq abr abs abt abu abv abw abx aby abz aca acb acc acd ace acf acg ach aci acj ack acl acm acn aco acp acq acr acs act acu acv acw acx acy acz ada adb adc add ade adf adg adh adi adj adk adl adm adn ado adp adq adr ads adt adu adv adw adx ady adz aea aeb aec aed aee aef aeg aeh aei aej aek ael aem aen aeo aep aeq aer aes aet aeu aev aew aex aey aez afa afb afc afd afe aff afg afh afi afj afk afl afm afn afo afp afq afr afs aft afu afv afw afx afy afz aga agb agc agd age agf agg agh agi agj agk agl agm agn ago agp agq agr ags agt agu agv agw agx agy agz aha ahb ahc ahd ahe ahf ahg ahh ahi ahj ahk ahl ahm ahn aho ahp ahq ahr ahs aht ahu ahv ahw ahx ahy ahz aia aib aic aid aie aif aig aih aii aij aik ail aim ain aio aip aiq air ais ait aiu aiv aiw aix aiy aiz aja ajb ajc ajd aje ajf ajg ajh aji ajj ajk ajl ajm ajn ajo ajp ajq ajr ajs ajt aju ajv ajw ajx ajy ajz aka akb akc akd ake akf akg akh aki akj akk akl akm akn
 
nahihirapan po ako i convert to sa vb.net itong php code na to:

ex:
<?php
for ($i = 'a'; $i != 'ako'; $i++)

{
echo "$i\n";
}

?>


ask ko lang po kung paano to sa .Net yun..:thanks: in advance!

Output:
a b c d e f g h i j k l m n o p q r s t u v w x y z aa ab ac ad ae af ag ah ai aj ak al am an ao ap aq ar as at au av aw ax ay az ba bb bc bd be bf bg bh bi bj bk bl bm bn bo bp bq br bs bt bu bv bw bx by bz ca cb cc cd ce cf cg ch ci cj ck cl cm cn co cp cq cr cs ct cu cv cw cx cy cz da db dc dd de df dg dh di dj dk dl dm dn do dp dq dr ds dt du dv dw dx dy dz ea eb ec ed ee ef eg eh ei ej ek el em en eo ep eq er es et eu ev ew ex ey ez fa fb fc fd fe ff fg fh fi fj fk fl fm fn fo fp fq fr fs ft fu fv fw fx fy fz ga gb gc gd ge gf gg gh gi gj gk gl gm gn go gp gq gr gs gt gu gv gw gx gy gz ha hb hc hd he hf hg hh hi hj hk hl hm hn ho hp hq hr hs ht hu hv hw hx hy hz ia ib ic id ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy iz ja jb jc jd je jf jg jh ji jj jk jl jm jn jo jp jq jr js jt ju jv jw jx jy jz ka kb kc kd ke kf kg kh ki kj kk kl km kn ko kp kq kr ks kt ku kv kw kx ky kz la lb lc ld le lf lg lh li lj lk ll lm ln lo lp lq lr ls lt lu lv lw lx ly lz ma mb mc md me mf mg mh mi mj mk ml mm mn mo mp mq mr ms mt mu mv mw mx my mz na nb nc nd ne nf ng nh ni nj nk nl nm nn no np nq nr ns nt nu nv nw nx ny nz oa ob oc od oe of og oh oi oj ok ol om on oo op oq or os ot ou ov ow ox oy oz pa pb pc pd pe pf pg ph pi pj pk pl pm pn po pp pq pr ps pt pu pv pw px py pz qa qb qc qd qe qf qg qh qi qj qk ql qm qn qo qp qq qr qs qt qu qv qw qx qy qz ra rb rc rd re rf rg rh ri rj rk rl rm rn ro rp rq rr rs rt ru rv rw rx ry rz sa sb sc sd se sf sg sh si sj sk sl sm sn so sp sq sr ss st su sv sw sx sy sz ta tb tc td te tf tg th ti tj tk tl tm tn to tp tq tr ts tt tu tv tw tx ty tz ua ub uc ud ue uf ug uh ui uj uk ul um un uo up uq ur us ut uu uv uw ux uy uz va vb vc vd ve vf vg vh vi vj vk vl vm vn vo vp vq vr vs vt vu vv vw vx vy vz wa wb wc wd we wf wg wh wi wj wk wl wm wn wo wp wq wr ws wt wu wv ww wx wy wz xa xb xc xd xe xf xg xh xi xj xk xl xm xn xo xp xq xr xs xt xu xv xw xx xy xz ya yb yc yd ye yf yg yh yi yj yk yl ym yn yo yp yq yr ys yt yu yv yw yx yy yz za zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv zw zx zy zz aaa aab aac aad aae aaf aag aah aai aaj aak aal aam aan aao aap aaq aar aas aat aau aav aaw aax aay aaz aba abb abc abd abe abf abg abh abi abj abk abl abm abn abo abp abq abr abs abt abu abv abw abx aby abz aca acb acc acd ace acf acg ach aci acj ack acl acm acn aco acp acq acr acs act acu acv acw acx acy acz ada adb adc add ade adf adg adh adi adj adk adl adm adn ado adp adq adr ads adt adu adv adw adx ady adz aea aeb aec aed aee aef aeg aeh aei aej aek ael aem aen aeo aep aeq aer aes aet aeu aev aew aex aey aez afa afb afc afd afe aff afg afh afi afj afk afl afm afn afo afp afq afr afs aft afu afv afw afx afy afz aga agb agc agd age agf agg agh agi agj agk agl agm agn ago agp agq agr ags agt agu agv agw agx agy agz aha ahb ahc ahd ahe ahf ahg ahh ahi ahj ahk ahl ahm ahn aho ahp ahq ahr ahs aht ahu ahv ahw ahx ahy ahz aia aib aic aid aie aif aig aih aii aij aik ail aim ain aio aip aiq air ais ait aiu aiv aiw aix aiy aiz aja ajb ajc ajd aje ajf ajg ajh aji ajj ajk ajl ajm ajn ajo ajp ajq ajr ajs ajt aju ajv ajw ajx ajy ajz aka akb akc akd ake akf akg akh aki akj akk akl akm akn



medyo messy tong ginawa ko tinatamad pa kasi ako magcode eh tsaka hanggang 2 digits palang to, ikaw na bahala magmodify ito. add ka ng textbox tapos paste mo tong code sa form load

Code:
                 for (char c = 'A'; c <= 'Z'; c++)
            {
                for (char d = 'A'; d <= 'Z'; d++)
                {

              
                        textBox1.Text = textBox1.Text + c + d ;
                 
                   
                }
            }
 
Last edited:
Hi mga kasymb !!

I am a 4thyear BSIT information technology student,
tanung ko lang po , regarding sa thesis namin, i am developing a desktop program (standalone) using vb.net and mysql as my backend.

Sa database ko po meron akong table named "Patients" every record n masasave within that table would acquire their own unique identification code, e.g. "P001, P002, ... etc"

ask ko lang po kung panu gawen yun ?? halimbawa po
the id number will start at A00001. . . A99999 tas po mgiging B000001 and so on .. panu po yun ?? Salamat po !!!


please help :)


:help::help::help::help:

nkagawa na ko nito puro using trim function ng string class lang maganda sana kung regex

ito

Code:
Using Command As New OleDb.OleDbCommand("Select last(IDnumber) as IDnumber from IDno", con) 'kukunin nito yung lastno. sa database
                con.Open()
                adapter.SelectCommand = Command
                adapter.Fill(setData)
                datagridBindings()
                currentString = setData.Tables(0).Rows(0).Item("IDnumber").ToString 'ito na yung last no. na nkuha natin sa database
                con.Close()
                newString = currentString.Substring(3, 4) 'tapos kinuha ko yung last 4 digit yung 0000
                genID = CInt((CDbl(newString) + 1).ToString)' tapos ginawa ko siyang int pra madagdagan ng 1 bale magiging 0001 na siya
                Dim newID As String = (genID.ToString("0000")) 'ito naman para maformat yung genid natin kasi nagiging 1 lang ang nlabas kaya pinormat ko siya sa 000
                newID = newID.Insert(0, "12-") ' then add ko lang yung 12 para maging 12-0001
                txtNumber.Text = newID
            End Using

intindihin mo na lang yung logic.
 
nahihirapan po ako i convert to sa vb.net itong php code na to:

ex:
<?php
for ($i = 'a'; $i != 'ako'; $i++)

{
echo "$i\n";
}

?>


ask ko lang po kung paano to sa .Net yun..:thanks: in advance!

Output:
a b c d e f g h i j k l m n o p q r s t u v w x y z aa ab ac ad ae af ag ah ai aj ak al am an ao ap aq ar as at au av aw ax ay az ba bb bc bd be bf bg bh bi bj bk bl bm bn bo bp bq br bs bt bu bv bw bx by bz ca cb cc cd ce cf cg ch ci cj ck cl cm cn co cp cq cr cs ct cu cv cw cx cy cz da db dc dd de df dg dh di dj dk dl dm dn do dp dq dr ds dt du dv dw dx dy dz ea eb ec ed ee ef eg eh ei ej ek el em en eo ep eq er es et eu ev ew ex ey ez fa fb fc fd fe ff fg fh fi fj fk fl fm fn fo fp fq fr fs ft fu fv fw fx fy fz ga gb gc gd ge gf gg gh gi gj gk gl gm gn go gp gq gr gs gt gu gv gw gx gy gz ha hb hc hd he hf hg hh hi hj hk hl hm hn ho hp hq hr hs ht hu hv hw hx hy hz ia ib ic id ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy iz ja jb jc jd je jf jg jh ji jj jk jl jm jn jo jp jq jr js jt ju jv jw jx jy jz ka kb kc kd ke kf kg kh ki kj kk kl km kn ko kp kq kr ks kt ku kv kw kx ky kz la lb lc ld le lf lg lh li lj lk ll lm ln lo lp lq lr ls lt lu lv lw lx ly lz ma mb mc md me mf mg mh mi mj mk ml mm mn mo mp mq mr ms mt mu mv mw mx my mz na nb nc nd ne nf ng nh ni nj nk nl nm nn no np nq nr ns nt nu nv nw nx ny nz oa ob oc od oe of og oh oi oj ok ol om on oo op oq or os ot ou ov ow ox oy oz pa pb pc pd pe pf pg ph pi pj pk pl pm pn po pp pq pr ps pt pu pv pw px py pz qa qb qc qd qe qf qg qh qi qj qk ql qm qn qo qp qq qr qs qt qu qv qw qx qy qz ra rb rc rd re rf rg rh ri rj rk rl rm rn ro rp rq rr rs rt ru rv rw rx ry rz sa sb sc sd se sf sg sh si sj sk sl sm sn so sp sq sr ss st su sv sw sx sy sz ta tb tc td te tf tg th ti tj tk tl tm tn to tp tq tr ts tt tu tv tw tx ty tz ua ub uc ud ue uf ug uh ui uj uk ul um un uo up uq ur us ut uu uv uw ux uy uz va vb vc vd ve vf vg vh vi vj vk vl vm vn vo vp vq vr vs vt vu vv vw vx vy vz wa wb wc wd we wf wg wh wi wj wk wl wm wn wo wp wq wr ws wt wu wv ww wx wy wz xa xb xc xd xe xf xg xh xi xj xk xl xm xn xo xp xq xr xs xt xu xv xw xx xy xz ya yb yc yd ye yf yg yh yi yj yk yl ym yn yo yp yq yr ys yt yu yv yw yx yy yz za zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv zw zx zy zz aaa aab aac aad aae aaf aag aah aai aaj aak aal aam aan aao aap aaq aar aas aat aau aav aaw aax aay aaz aba abb abc abd abe abf abg abh abi abj abk abl abm abn abo abp abq abr abs abt abu abv abw abx aby abz aca acb acc acd ace acf acg ach aci acj ack acl acm acn aco acp acq acr acs act acu acv acw acx acy acz ada adb adc add ade adf adg adh adi adj adk adl adm adn ado adp adq adr ads adt adu adv adw adx ady adz aea aeb aec aed aee aef aeg aeh aei aej aek ael aem aen aeo aep aeq aer aes aet aeu aev aew aex aey aez afa afb afc afd afe aff afg afh afi afj afk afl afm afn afo afp afq afr afs aft afu afv afw afx afy afz aga agb agc agd age agf agg agh agi agj agk agl agm agn ago agp agq agr ags agt agu agv agw agx agy agz aha ahb ahc ahd ahe ahf ahg ahh ahi ahj ahk ahl ahm ahn aho ahp ahq ahr ahs aht ahu ahv ahw ahx ahy ahz aia aib aic aid aie aif aig aih aii aij aik ail aim ain aio aip aiq air ais ait aiu aiv aiw aix aiy aiz aja ajb ajc ajd aje ajf ajg ajh aji ajj ajk ajl ajm ajn ajo ajp ajq ajr ajs ajt aju ajv ajw ajx ajy ajz aka akb akc akd ake akf akg akh aki akj akk akl akm akn


Ito function na ng'gegenerate ng string based sa index. prang excel. 0 is A, 3 is D, 27 is AB, 28 is AC, and ...

Code:
private static string CharSet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";

public static string IndexToExcelColumn(int index)
        {
            string columnString = "";
            int cn = index;
            while (cn >=  0)
            {
                int cln = cn % 26;
                char currentLetter = CharSet[cln];
                columnString = currentLetter + columnString;
                cn = (cn - (cln + 1)) / 26;
             }
            return columnString;
        }

nk'ubuntu ako so try mo nalang yung gnawa ko to confirm

*edit: C# pala yan. convert mo nalang sa VB.Net
 
Last edited:
VB.net

Paano po i-validate kung ang inputted value ay nasa database po?

For example;
studentid po.
Paano po mavavalidate kung yung ininput na student id ay nasa database po?
 
Mga senpai baka po puwede niyo akong tulungang gumawa nang game like boulder dash in vb.net.
 
VB.net

Paano po i-validate kung ang inputted value ay nasa database po?

For example;
studentid po.
Paano po mavavalidate kung yung ininput na student id ay nasa database po?

just run a msgbox after mong mag insert sa database.
pag hindi naman kasi pumasok sa database yan mag eeror yan eh
 
VB.net

Paano po i-validate kung ang inputted value ay nasa database po?

For example;
studentid po.
Paano po mavavalidate kung yung ininput na student id ay nasa database po?

based sa understanding ko.. just use

"select * from urTable where studentID='" & texboxt,text & "'"

then kapag
rows.count > 0 then the student id na identify mo as where statement mo.. means nandun na un..
kapag rows.count = 0 then walang sa records.. i guess ganyan ung concern mo sir..
 
is anybody try importing a 3ds max object,animation and effects in VB.net?

thesis kasi namin..my problem is on how to import a 3ds max object and animation into vb.net?
is it possible or not?

what software im am going to use?
kasi our thesis is A Standard Motorcycle Virtual Customization

help me please sa mga nakatry na in this situation..

sana may magrply..salamat po
 
is anybody try importing a 3ds max object,animation and effects in VB.net?

thesis kasi namin..my problem is on how to import a 3ds max object and animation into vb.net?
is it possible or not?

what software im am going to use?
kasi our thesis is A Standard Motorcycle Virtual Customization

help me please sa mga nakatry na in this situation..

sana may magrply..salamat po

mas ok kung wpf ang gagamitin niyo .net din

pm niyo si sir sephiroth about dyan..
 
medyo messy tong ginawa ko tinatamad pa kasi ako magcode eh tsaka hanggang 2 digits palang to, ikaw na bahala magmodify ito. add ka ng textbox tapos paste mo tong code sa form load

Code:
                 for (char c = 'A'; c <= 'Z'; c++)
            {
                for (char d = 'A'; d <= 'Z'; d++)
                {

              
                        textBox1.Text = textBox1.Text + c + d ;
                 
                   
                }
            }

:thanks: po.. :)
 
buti nalang nakita ko to...

may tanong po ako sa inyo...

paano po ba gumawa ng editable and password protected program gamit ang VB6 ng di ginagamitan ng vb project at frm files? yun kasi ang requirement samin...

yung project po namin kasi ay Directory ng university namin...para kapag may nagbago sa university namin, pwedeng i-edit yung app na yun kahit stand-alone .exe na sya...
 
help naman jan mga masters, nahihirapan kasi akong iconnect yung mysql database sa vs2012 kahit complete na yun ginawa ko wala pa rin, working fine naman yung components ng mysql standalone, sa connector wala talaga, refer here

Code:
http://stackoverflow.com/questions/4235291/how-to-connect-to-a-mysql-data-source-in-visual-studio

sana may makatulong
 
just run a msgbox after mong mag insert sa database.
pag hindi naman kasi pumasok sa database yan mag eeror yan eh

Hindi po kaya masyadong Risky kung ganyan ang gagawin? kumbaga hihintayin muna nating magthrow ng exception para lang malaman natin na may Student id na ?
 
Hindi po kaya masyadong Risky kung ganyan ang gagawin? kumbaga hihintayin muna nating magthrow ng exception para lang malaman natin na may Student id na ?

yup tama...
wag po nating abusuhin ang gamit ng try catch sa mga predictable na situations na pwede namang i-handle...
 
uhm..tanong ko lang po ano po ba ang mysql version ng EXECUTENONQUERY().....me project po xe kame na vb.net na ikokonect sa mysql database.....
 
Back
Top Bottom