VB.NET Programming Corner!

[spleken001]

hi can you help me in my problem sir please?
i want to make a system that can capture photo using webcam (a4tech Webcam)
but i dont know how to code it
can you please help

 

[ssedble15]

sa mga professional po jan hingi po ako ng help sa inyo baka po pwede po patulong sa search ng date using datetimepicker ito po code ko

Dim search As New SqlDataAdapter("select * from tbl_sales where daterecord like'" + DateTimePicker1.Value + "'", salesconn)
Dim dgv3load As New SqlDataAdapter("select * from tbl_sales", salesconn)
Dim table4 As New DataTable

If dgv3.Rows.Count > 0 Then
MessageBox.Show("Recordfound!")

dgv3load.Fill(table4)
dgv3.DataSource = table4
Else
MessageBox.Show("Record not found!")
End If

 

[tarun03]

salamat po sa kaalaman

 

[AkoSiReckah]

thanks po sa kaalaman

 

[Elruu]

mga sir baka may sample codes kayo dyan ng data from mysql to array. gusto ko lang sana ilagay ung lahat laman ng column ko sa array. thanks in advance!!

 

[jrwild99]

Pa help mga bossing ng free VB.net any version will do. thank you in advance.

 

[arkienz]

sa mga professional po jan hingi po ako ng help sa inyo baka po pwede po patulong sa search ng date using datetimepicker ito po code ko

Dim search As New SqlDataAdapter("select * from tbl_sales where daterecord like'" + DateTimePicker1.Value + "'", salesconn)
Dim dgv3load As New SqlDataAdapter("select * from tbl_sales", salesconn)
Dim table4 As New DataTable

If dgv3.Rows.Count > 0 Then
MessageBox.Show("Recordfound!")

dgv3load.Fill(table4)
dgv3.DataSource = table4
Else
MessageBox.Show("Record not found!")
End If

----

Dim SQLGrid As New SqlDataAdapter
Dim DS As New DataSet

SQLGrid = New SqlDataAdapter("select * from tbl_sales where daterecord = '" & FormatDateTime(DateTimePicker1.Value, DateFormat.ShortDate) & "'", salesconn)
SQLGrid.Fill(DS, "table1")
dgv3.DataSource = DS.Tables(0)
dgv3.Refresh()

If dgv3.Rows.Count > 0 Then
msgbox("Recordfound!")

try to organize code mo saka i minimize or ishorten para d ka po nalilito.. redundant kasi ung select statement mo kaya medyo nalilito ka na.. try mo ung code ko naka simplify na po yan check mo kung gagana :>

- - - Updated - - -

View attachment 1226408

patulong naman ako dito sa rent, pag click ko ng lend date today malalgay dun sa date borrowed then ung due date 1 day lang ung tagal nya
simula dun sa date borrowed. pero pag lumampas ng 1 day may penalty sya ng 10 pesos per day. salamat

-------
try mo po date diff

dim x as integer=0

x=DateDiff(DateInterval.Day,FirstDay,secondday)

if x>= then

'YOUR CODE HERE'

:>

 

[exmachina]

thank you! very informative post

 

[Hukbalahap]

Good day!

Actually may gusto akong gawing software since teacher ako.
I want to make a scantron.
Ang hirap kasi sa teacher dami chine-chekan.
Ang gusto ko sana low cost langpara makatulong sa mga kapwa ko guro.

I've already search for what featured techonlogies ang pwedeng gamitin.
And according to my research, I need OMR or optical markup recognition or OCR (optical character recognition)

Gusto ko lang malaman kung anong code ang dapat kong aralin to make this.
Kaya ba ito ng Visual Basic?
I'm willing to learn and all.
I know this is a BIG program and I want to make this program.

 

[lochinvar14]

Nice thread��������

Help for tutorial in vb.net 2015 web application
Beginerssss......basic sample with sqlserver connection.
Thank you��

3-tier architecture user here!

 

[kudeta21]

Good day!

Actually may gusto akong gawing software since teacher ako.
I want to make a scantron.
Ang hirap kasi sa teacher dami chine-chekan.
Ang gusto ko sana low cost langpara makatulong sa mga kapwa ko guro.

I've already search for what featured techonlogies ang pwedeng gamitin.
And according to my research, I need OMR or optical markup recognition or OCR (optical character recognition)

Gusto ko lang malaman kung anong code ang dapat kong aralin to make this.
Kaya ba ito ng Visual Basic?
I'm willing to learn and all.
I know this is a BIG program and I want to make this program.

mas maganda sir kung java or c ang gamitin mo sa pag program nito

 

[jhaps007]

need help! panu po gumawa ng costing ng isang system?
hinge po ng examples

 

[Hukbalahap]

mas maganda sir kung java or c ang gamitin mo sa pag program nito

why sir? ano pong pagkakaiba nila sir?

 

[migs1424]

mga sir pwede po ba magtanung about programming?

 

[jskhulitz]

Good day!

Actually may gusto akong gawing software since teacher ako.
I want to make a scantron.
Ang hirap kasi sa teacher dami chine-chekan.
Ang gusto ko sana low cost langpara makatulong sa mga kapwa ko guro.

I've already search for what featured techonlogies ang pwedeng gamitin.
And according to my research, I need OMR or optical markup recognition or OCR (optical character recognition)

Gusto ko lang malaman kung anong code ang dapat kong aralin to make this.
Kaya ba ito ng Visual Basic?
I'm willing to learn and all.
I know this is a BIG program and I want to make this program.

When you said SCANTRON, you mean yung parang sa mga entrance test na shade the circle of your answer? Kung iyan, medyo madami dami ka kailangan aralin?

Kailangan mo matutunan ang OMR, mas madugo ang OCR. Ang OMR kasi will just base on the markings you made on specific parts of the answer sheets. Whereas OCR, you have to instruct your hardware to recognize a marking and translate what the marking says. To make it easier, OMR = will just check the corresponding value for the markings you made, OCR = have to translate what you wrote, eh iba iba pa naman tayo ng handwriting. Kailangan mo madetermine kung o, or O, or 0 ang isinulat.

^
Yan ang aaralin mo KUNG ang plano mo gawin ay yung program + HARDWARE. Remember, HARDWARE part pa lang yan nasa taas. Also, nakalimutan ko pa pala i-include na yung mga answer sheets ay ibang usapin pa, even though they are just papers, hindi yan basta basta printing lang. I'll assume na nakakita ka naman na ng mga scannable answer sheets. Bukod dun sa mga may bilog na kailangan mo i-shade, you'll see sa attached image dito na may mga block markings pa sa sides yung mga sheets. It tells the machine where to stop (temporarily) to check for any markings. Yung mga marks na yan ay kailangan pa muna i-feed sa machine para marecognize at mai-set mo kung aling mga marks ang for INFO (personal info / tracking number) at kung alin ang for evaluation (answers).

On a cost-benefit analysis, lugi ka sa ganitong scenario, dahil madami ka na kailangan aralin, madami ka pa kailangan buuin. Remember, pati hardware at answer sheets ay kailangan mo idesign at gawin.

Now, may mga companies that lets schools rent (at a minimal fee) their OMR devices. What's the catch? Sila ang magpprovide ng mga answer sheets, at siyempre, for a fee. Last time na nag-implement kami ng ganito sa school, ginagamit ang OMR devices namin every major exams (PRELIM MIDTERM PREFINALS FINALS). The office passes the cost of the answer sheets to the students (parang 5 pesos per sheet ang benta nila sa students), hindi ko lang alam kung magkano talaga per sheet. So for example, I'm a first year college student with 8 subjects, that's already 40 pesos per major exam (8 subjects * 5 pesos per sheet), kapag nagkaroon ka ng madaming erasures, you have to scrap that answer sheet and get another one. So approximately 10 answer sheets per exam. Times 4 major exams, 200 pesos. If this is not a big issue, better. Sa mga private schools, they may add this cost sa miscellaneous. Pero big problem ito kapag public schools.

Anyway, if you decided to adapt the said proposal from the OMR provider, mas madali na ang trabaho mo pagdating sa programming. Wala ka na iisipin sa hardware at pati sa answer sheets. Ang kailangan mo na lang iprogram ay yung kung paano mo ittranslate yung export file na nire-release ng device into something meaningful. Once na dumaan ang answer sheets sa OMR, iba iba pa ang mga export results nyan. Yung iba, raw scores na (sya na mismo magccheck based from the answer sheet compared to an answer key). Yung iba naman, ang ie-export nya ay yung mga actual answers ang ibibigay sayo, at yung program mo na ang magccheck kung tama or mali (based from an answer key from your question data bank). Dito sa part na ito, madali na ito, kasi kahit anong programming language na pwede makabasa ng .txt / .dat / .csv files ay pwede mo gamitin to translate any files generated by the device.

We implemented 2 types of this nung time na nasa academe pa ako. Yung isa nga ay yung para sa major exams, at yung isa ay para sa scannable report cards. Instead na class cards ang ipapasa nila at the start of the sem, scannable sheets ang ibibigay nila sa instructors nila. For every term, maggrade kami, so siyempre after the last term (Finals), mare-release agad yung scores from the scanned finals exam sheets. Shading naman agad ng grades ng mga students. Scan uli, once scanned diretso na sa program then sa PC ng mga registrars. Mas mabilis ang process.

 

[romerson22]

I made this thread for all programmers starting their adventure in 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 VS2012

i suggest learn and get the feel of VB.NET/VISUAL STUDIO IDE first before posting 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.


***Thanks to moderators, STICKY na ang thread!

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

Salamat po ng marami dito

 

[PlugzDG0489]

Hello boss/paps patulong naman kung pwede pinapagawa kasi kami ng file sender for pc any language gusto sana namin yung wireless, lan lang kasi nakikita namin sa youtube newbie pa lang kami. Thanks .

Ps. Kung pwede lang naman
Pps. Kahit anong language. Thanks again

 

[patrickkillua]

Hi.. question lng guys.. Newbie lng sa mysql.
may stored procedure na kasi akong ganito pag build ng statement
SET @sql=CONCAT("select ", _Columns,",RecordID,FileCount,FileName,FilePath,Comment,UpdateDate,FileType,CreateDate,fn_getAudioFilename2(JobID,",v_ProjectID,") as AudioFileName FROM ",_tableName , " ", _filter,v_Sort );
SET @sql=CONCAT("select JobID,MRNumber,LastName,FirstName,DOB,DOS,Dictator,WT,Status,Priority,Dictation_Date,Concat(MRNumber,',',JobID,',',FirstName,',',LastName) AS RecordTittle,RecordID,FileCount,FileName,
FilePath,Comment,UpdateDate,FileType,CreateDate,COALESCE(Nullif(B.AudioFileName,''),'NOAUDIO') as AudioFileName FROM " ,_tableName,
" A,(select PrimaryJobID,AudioFileName,ProjectID,mp3flag from tbl_audiofiles) B ", _filter ," and substring_index(A.jobID,'-',1) = B.PrimaryJobID and ProjectID=47 and mp3flag=1 " , v_Sort);
Tanong ko lng dito kung working po ba ung mga joing inside Sp ni mysql??
working naman but once na nag karoon na ko ng Joining ayaw na nya gumana .. Gamit ko po ngaun mysql workbench 5.2.44CE

 

[junex13]

Hi.. question lng guys.. Newbie lng sa mysql.
may stored procedure na kasi akong ganito pag build ng statement
SET @sql=CONCAT("select ", _Columns,",RecordID,FileCount,FileName,FilePath,Comment,UpdateDate,FileType,CreateDate,fn_getAudioFilename2(JobID,",v_ProjectID,") as AudioFileName FROM ",_tableName , " ", _filter,v_Sort );
SET @sql=CONCAT("select JobID,MRNumber,LastName,FirstName,DOB,DOS,Dictator,WT,Status,Priority,Dictation_Date,Concat(MRNumber,',',JobID,',',FirstName,',',LastName) AS RecordTittle,RecordID,FileCount,FileName,
FilePath,Comment,UpdateDate,FileType,CreateDate,COALESCE(Nullif(B.AudioFileName,''),'NOAUDIO') as AudioFileName FROM " ,_tableName,
" A,(select PrimaryJobID,AudioFileName,ProjectID,mp3flag from tbl_audiofiles) B ", _filter ," and substring_index(A.jobID,'-',1) = B.PrimaryJobID and ProjectID=47 and mp3flag=1 " , v_Sort);
Tanong ko lng dito kung working po ba ung mga joing inside Sp ni mysql??
working naman but once na nag karoon na ko ng Joining ayaw na nya gumana .. Gamit ko po ngaun mysql workbench 5.2.44CE

Sir bka nman ung table na joinan mo is empty or hnd ka nka PK or FK kaya hnd gumagana

 

[kudeta21]

Good day!

Actually may gusto akong gawing software since teacher ako.
I want to make a scantron.
Ang hirap kasi sa teacher dami chine-chekan.
Ang gusto ko sana low cost langpara makatulong sa mga kapwa ko guro.

I've already search for what featured techonlogies ang pwedeng gamitin.
And according to my research, I need OMR or optical markup recognition or OCR (optical character recognition)

Gusto ko lang malaman kung anong code ang dapat kong aralin to make this.
Kaya ba ito ng Visual Basic?
I'm willing to learn and all.
I know this is a BIG program and I want to make this program.

Well, limited lang kasi resources kapag vb .net. sa java tsaka c naman, since existing na yang ganyang system, marami ka nang makikitang pwede mong gamitin. marami ding open source kung matyaga ka lang maghanap