VB.NET Programming Corner!

[reiner28]

sir eric ask lang po ng help

visual basic codes

ang problem ko kc eh ganito:

meron akong 2 table

per table merong 4 fields

like this:

table_1
<van_number> | <status> | <date> | location>

table_2
<van_number> | <status> | <date> | location>


ngayon ganito meron clang mga records...


table_1
<van_number> | <status> | <date> | location>
101 | out | 2011-06-20 | Manila
102 | in | 2011-06-10 | Davao
103 | transfer | 2011-06-12 | GenSan
104 | pickup | 2011-06-06 | Manila

table_2
<van_number> | <status> | <date> | location>
101 | fulls | 2011-06-25 | Cagayan
102 | empty | 2011-06-01 | Manila
103 | repair | 2011-06-15 | Davao
104 | transfer | 2011-06-09 | Manila

ngayon mag co-COPARE yung dalawang table mag jo-JOIN at mag fi-FILTER...

dapat lahat ng may status na 'empty' at 'out' ay di mag mag ddisplay sa records

then dapat lahat ng may location na 'manila' lang ang mag sshow ang records

then dapat yung may latest or updated na date ang mag show na records

yan po sir... sana matulungan nyo ako

TIA

 

[ericgmejia]

sir eric ask lang po ng help

visual basic codes

ang problem ko kc eh ganito:

meron akong 2 table

per table merong 4 fields

like this:

table_1
<van_number> | <status> | <date> | location>

table_2
<van_number> | <status> | <date> | location>


ngayon ganito meron clang mga records...


table_1
<van_number> | <status> | <date> | location>
101 | out | 2011-06-20 | Manila
102 | in | 2011-06-10 | Davao
103 | transfer | 2011-06-12 | GenSan
104 | pickup | 2011-06-06 | Manila

table_2
<van_number> | <status> | <date> | location>
101 | fulls | 2011-06-25 | Cagayan
102 | empty | 2011-06-01 | Manila
103 | repair | 2011-06-15 | Davao
104 | transfer | 2011-06-09 | Manila

ngayon mag co-COPARE yung dalawang table mag jo-JOIN at mag fi-FILTER...

dapat lahat ng may status na 'empty' at 'out' ay di mag mag ddisplay sa records

then dapat lahat ng may location na 'manila' lang ang mag sshow ang records

then dapat yung may latest or updated na date ang mag show na records

yan po sir... sana matulungan nyo ako

TIA

kelangan mo kasing intindihin ang mga JOIN at WHERE commands

kung nasa database yan lalo sa access, pwede mo na i type ang query mo at i test

no need to ask everytime na may ganyan na problem

 

[alquelt]

gagamit ka ng 3rd party DLL

http://www.codeproject.com/KB/vb/Inpout32_read.aspx
http://www.hytherion.com/beattidp/comput/pport.htm

salamat sa reply ser! try ko ngaun

 

[edrish08]

sir eric eh panu ko kukunin un databse ng stand alone na biometrics door access??

 

[doorbreaker]

sir eric eh panu ko kukunin un databse ng stand alone na biometrics door access??

may sdk yon dun nkalagay lahat ng kaylangan mo.

 

[ihatebugs]

Re: How to stay ALIVE ...

Pahingi ng tips on how to train your mind and body to mentally stay alive on the computer for a couple of hours longer while programming...

 

[ericgmejia]

Re: How to stay ALIVE ...

Pahingi ng tips on how to train your mind and body to mentally stay alive on the computer for a couple of hours longer while programming...

you dont need to stay longer sa computer
pag inaantok ka matulog ka na

dapat merong kang
DRIVE
INTEREST
ENTHUSIASM
sa ginagawa mo

 

[ericgmejia]

sir eric eh panu ko kukunin un databse ng stand alone na biometrics door access??

basahin mo yung manual

karamihan may web console yan kung saan pwede mo i download
ang time/attendance data

yung iba parang mapped drive lang tapos file yung data

 

[jycelien]

penge po aq compiler....VB .net papm po links

 

[bro_090579]

may example code po ba kayo dyan ng network graph para sa vb.net

yung katulad ng makikita sa mga graph ng globe usb broadband..

thanks

 

[ericgmejia]

penge po aq compiler....VB .net papm po links

pa search nalang po ang
'Visual Basic .NET Express Edition" sa microsoft site

 

[anshity]

patry.

 

[ericgmejia]

may example code po ba kayo dyan ng network graph para sa vb.net

yung katulad ng makikita sa mga graph ng globe usb broadband..

thanks

lines lang ang ginagamit dun
nasa System.Drawing na namespace yun lahat
http://www.java2s.com/Tutorial/VB/0280__GUI-Applications/GDILineChart.htm
http://devcity.net/Articles/229/1/article.aspx


o kaya yung chart control
http://www.linglom.com/2010/05/14/creating-graph-with-vb-net-part-2-customize-chart/

 

[uchihame]

OT
sir eric!!..mukhang browser-based at php..ang gagamitin namin sa thesis....sana po matulongan ninyo ako!!...
...

pero study mode pa rin ako sa vb.net dahil mukhang interesado to kesa sa mga online na php ang gamit..

thanks sa mga tutorials dito. and more powers on sharing

 

[tsunade]

sir guide mo naman ako about sa face recognition system ng .net if wala ka po sample code then tell me what i need to research thanks in advance

 

[bro_090579]

@ TS thanks sa links po

may tanong pa po ako sa mga nakakaalam po

pano ba ang codes for vb.net about network send and receive connectivity

 

[alundra120]

masters, pano po ba magconnect between 2 PCs?

balak po sana namin, yung user, magiinput ng text sa app sa PC1 tapos madidisplay sa app sa PC2. gagamit kami ng cross cable if that helps.

marunong na ako kahit papano sa VB.NET pero olats talaga sa networking eh..

 

[koykoys]

boss eric, nagdownload ako ng sap crystal report,,ng ininstall ko na,,kpag magnenew item ako taz piliin ko ung crystal report,,nalabas padin ung download from microsoft website,,meaning,,ndi niya maread ung ininstall kong crystal report,,tama??ano pong solution dun?

 

[gineanne]

sir eric.. good morning po.. gusto ko po kasi matuto gumawa ng sariling openvpn gui.. katulad ng sa pdproxy or wifree... patutor naman po.. salamat po ng marami.. bale mejo gamay ko po ung c#...

 

[mguzman]

marami ng post tungkol dyan dito
per best way is i practice mo muna kung papano makipag usap sa modem using hyperterminal

plug your modem, find out yung port nya sa device manager (COMxx)

then open hyperterminal on that port

then issue AT Commands and see how your modem responds to AT commands

bale AT commands ang gagamitin mo to make your modem do something like send SMS, read SMS, query info like signal, IMEI and so on

sa VB.NET naman meron namespace na "System.IO.Ports"
nandyan lahat ng commands to send and recieve AT Commands sa modem.


study these links
http://msdn.microsoft.com/en-us/library/system.io.ports.serialport.aspx
http://www.innovatic.dk/knowledg/SerialCOM/SerialCOM.htm

thank you thank you very much sir eric, /no1 pang aaralan ko op ung mga link na bngy nio.