Symbianize





Programming Discussions related to C++, HTML, PHP, ASP, ColdFusion, JavaScript, Perl, Phyton, Ruby, WML, SQL, XML, and other programming languages.

Reply
  #1  
Old 19th Jun 2010 Sat, 18:04
ericgmejia's Avatar
ericgmejia Male ericgmejia is offline
The Legend
 
Join Date: Dec 2007
Location: Makati City
Posts: 6,633
Reputation: ericgmejia will become famous soon enough
Arrow VB.NET Programming Corner!

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:

*Only fully-registered users can see this link.*

SQLServer 2005 Express Edition

Suggested references:

*Only fully-registered users can see this link.*


*Only fully-registered users can see this link.*


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



Give a man a computer program and you give him a headache,
but teach him to program computers and you give him the power to create headaches for others for the rest of his life..
VB.NET Programming Corner
VB6/MSAccess Using ADO with DataReport
Facebook, Other Threads
Join my shared folder in Dropbox get access to code samples, ebooks, tools and other usefull stuff

Last edited by ericgmejia; 30th Apr 2012 Mon at 13:42..
Reply With Quote
Other Resources
  #2  
Old 19th Jun 2010 Sat, 18:23
ericgmejia's Avatar
ericgmejia Male ericgmejia is offline
The Legend
 
Join Date: Dec 2007
Location: Makati City
Posts: 6,633
Reputation: ericgmejia will become famous soon enough
Default Re: VB.NET Programming Corner!

First Post:

Populating DataGridView using MSAccess Database



Shown in 3ways
-using Dataset
-using DataReader
-binding the DataGridView to a dataset



Important points to learn:
OleDBConnection
OleDBCommand
OleDBAdapter
Dataset
DataReader
DataTable
Using My.Settings to save the database path

Program will search for the database if not found;
Sample code has comments as to how it is done
Post further questions if necessary:

Basic Steps:

Create a project:
Add a form:
Add this to the forms top most code
"Imports System.Data.OleDb"
Add the DataGridView
For non databound grid,
add the necessary columns using the datagridview designer (when selected; click the [>] button on the top rigth of the grid)
Follow the code provided


the file
ericVBNETAccess.rar
contains the design for the application series i wanted to construct for this thread
you will notice, walang pop windows, nasa tab page lang ang forms.
stay tuned to know how it is done.

UPDATED! - loading data into listview.

Updated SQL Server Sample
http://www.symbianize.com/attachment...1&d=1310119089

check also thee links
http://www.symbianize.com/showpost.p...postcount=2560
http://www.symbianize.com/showpost.p...postcount=2561
http://www.symbianize.com/showpost.p...postcount=2562
Attached Images
File Type: png Capture2.PNG (53.2 KB, 27272 views)
Attached Files
File Type: rar ericVBNETAccess.rar (48.2 KB, 1927 views)
File Type: rar ericVBNETAccessBasicOLEDB.rar (896.0 KB, 3209 views)
File Type: rar AppSample.rar (144.3 KB, 5038 views)
File Type: rar AppSample1a.rar (148.2 KB, 1284 views)
File Type: rar MicroPOS-Access.rar (4.35 MB, 245 views)



Give a man a computer program and you give him a headache,
but teach him to program computers and you give him the power to create headaches for others for the rest of his life..
VB.NET Programming Corner
VB6/MSAccess Using ADO with DataReport
Facebook, Other Threads
Join my shared folder in Dropbox get access to code samples, ebooks, tools and other usefull stuff

Last edited by ericgmejia; 6th Apr 2013 Sat at 11:43..
Reply With Quote
  #3  
Old 19th Jun 2010 Sat, 21:16
NeRDz's Avatar
NeRDz Male NeRDz is offline
Expert
 
Join Date: Jan 2010
Location: SOME WHERE OUT THERE!..XP
Posts: 292
Reputation: NeRDz is an unknown quantity at this point
Default Re: VB.NET Programming Corner!

sir, thanks po sa thread na eto..eto hanap ko.. eto kasi programming namin ngayun..and i know nothing about it kasi java at c yung ginamit namin noon..
may i ask a noob question..
ano po ang kaibahan ng visual studio at visual basic??..



Reply With Quote
  #4  
Old 19th Jun 2010 Sat, 21:40
ericgmejia's Avatar
ericgmejia Male ericgmejia is offline
The Legend
 
Join Date: Dec 2007
Location: Makati City
Posts: 6,633
Reputation: ericgmejia will become famous soon enough
Default Re: VB.NET Programming Corner!

Quote:
Originally Posted by NeRDz View Post
sir, thanks po sa thread na eto..eto hanap ko.. eto kasi programming namin ngayun..and i know nothing about it kasi java at c yung ginamit namin noon..
may i ask a noob question..
ano po ang kaibahan ng visual studio at visual basic??..
malabo ang tanong mo,
i think ang ibig mo sabihin ay vb.net at vb6

Visual Studio is the IDE
like MSOFFICE na meron MSWORD at EXCEL

VB.NET is the language


*Only fully-registered users can see this link.*


eto yung versions


[IMG][/IMG]
WIN32
Visual Studio 97 (VB5, C++, etc)
Visual Studio 6.0 (1998) (
*Only fully-registered users can see this link.*
, C++, VFP)
NOT SUPPORTED BY Microsoft anymore






.NET FRAMEWORK
Visual Studio .NET (2002) (VB.NET 2002, C#, etc)
Visual Studio .NET 2003 (VB.NET 2003, C#, etc)
Visual Studio 2005 (VB 2005, C#, etc)
Visual Studio 2008 (VB 2008, C#, etc)
Visual Studio 2010 (VB 2010, C#, etc)


VB6 is a WIN32 development tool
meaning ginagamit to create applications in the Windows32bit platform using native windows library.


*Only fully-registered users can see this link.*
is a development tool to create applications running under the
*Only fully-registered users can see this link.*



sana malinaw yan so that we know na IISA lang ang tinutukoy nating bagay.



Give a man a computer program and you give him a headache,
but teach him to program computers and you give him the power to create headaches for others for the rest of his life..
VB.NET Programming Corner
VB6/MSAccess Using ADO with DataReport
Facebook, Other Threads
Join my shared folder in Dropbox get access to code samples, ebooks, tools and other usefull stuff

Last edited by ericgmejia; 19th Jun 2010 Sat at 21:54..
Reply With Quote
  #5  
Old 19th Jun 2010 Sat, 23:21
NeRDz's Avatar
NeRDz Male NeRDz is offline
Expert
 
Join Date: Jan 2010
Location: SOME WHERE OUT THERE!..XP
Posts: 292
Reputation: NeRDz is an unknown quantity at this point
Default Re: VB.NET Programming Corner!

wow!..thanks for the info sir!..sana marami akong matutunan sa thread mong ito..newbie pa kasi ako eh..
salamat din sa paglagay ng link para dun sa mga terms..
thanks!..
tambay ako d2 ts kung pwd!..



Reply With Quote
  #6  
Old 19th Jun 2010 Sat, 23:28
elmovan Male elmovan is offline
Newcomer
 
Join Date: Jun 2010
Posts: 2
Reputation: elmovan is an unknown quantity at this point
Default Re: VB.NET Programming Corner!

I want to learn more bout vbs...as a newbie what should i do?

sa otor, thanks for making this thread......


Reply With Quote
  #7  
Old 20th Jun 2010 Sun, 02:32
ericgmejia's Avatar
ericgmejia Male ericgmejia is offline
The Legend
 
Join Date: Dec 2007
Location: Makati City
Posts: 6,633
Reputation: ericgmejia will become famous soon enough
Default Re: VB.NET Programming Corner!

Quote:
Originally Posted by elmovan View Post
I want to learn more bout vbs...as a newbie what should i do?

sa otor, thanks for making this thread......
Download mo maski yung Express Edition and start using it,
type the codes you see here,
do not just copy,
understand what you are typing
and why you are typing it.

Refer to Google or MSDN for any keywords that you dont know.

See it run, admire your work.

You have all the resources at your disposal to learn this.



Give a man a computer program and you give him a headache,
but teach him to program computers and you give him the power to create headaches for others for the rest of his life..
VB.NET Programming Corner
VB6/MSAccess Using ADO with DataReport
Facebook, Other Threads
Join my shared folder in Dropbox get access to code samples, ebooks, tools and other usefull stuff
Reply With Quote
  #8  
Old 20th Jun 2010 Sun, 13:40
aj_chichi's Avatar
aj_chichi Male aj_chichi is offline
Forum Consultant
 
Join Date: Jan 2008
Posts: 1,852
Reputation: aj_chichi has a spectacular aura aboutaj_chichi has a spectacular aura aboutaj_chichi has a spectacular aura about
Total Awards: 1
Symbianizers' Choice Award in Graphics  

» view all
Default Re: VB.NET Programming Corner!

Yun! na-decide na pala na ihiwalay ang VB.net sa VB Thread

ok nga po kasi mahirap rin kasi lalo na dun sa nag uumpisa palang baka akalain nila ung discussion na iba dun sa vb thread is vb lang talaga..





Reply With Quote
  #9  
Old 20th Jun 2010 Sun, 13:58
monski1122's Avatar
monski1122 Male monski1122 is offline
Forum Advisor
 
Join Date: Jun 2009
Location: Angry bird paradise
Posts: 550
Reputation: monski1122 is an unknown quantity at this point
Default Re: VB.NET Programming Corner!

TS pa tambay po dito. Nagtuturo po me ng Visual Basic sa school kaso ung VB 6.0 ang alam ko eh sbi sakin ng boss ko ung VB 2008 edition na ang ituro ko kaya medyo nangangapa pako iba kasi ung coding nya hehehe.
Thanks for creating this threads MABUHAY KA!!!



Reply With Quote
  #10  
Old 20th Jun 2010 Sun, 14:09
ericgmejia's Avatar
ericgmejia Male ericgmejia is offline
The Legend
 
Join Date: Dec 2007
Location: Makati City
Posts: 6,633
Reputation: ericgmejia will become famous soon enough
Default Re: VB.NET Programming Corner!

Quote:
Originally Posted by monski1122 View Post
TS pa tambay po dito. Nagtuturo po me ng Visual Basic sa school kaso ung VB 6.0 ang alam ko eh sbi sakin ng boss ko ung VB 2008 edition na ang ituro ko kaya medyo nangangapa pako iba kasi ung coding nya hehehe.
Thanks for creating this threads MABUHAY KA!!!
try mo yung mga links na nasa first post, basic yung mga yun.
pwede natin pagtulungan kung anon topic ang ituturo mo at kung ano ang laman,
para naman di mahuli yung mga students mo
madami ako pde i share ng coding techniques para sa kanila



Give a man a computer program and you give him a headache,
but teach him to program computers and you give him the power to create headaches for others for the rest of his life..
VB.NET Programming Corner
VB6/MSAccess Using ADO with DataReport
Facebook, Other Threads
Join my shared folder in Dropbox get access to code samples, ebooks, tools and other usefull stuff

Last edited by ericgmejia; 20th Jun 2010 Sun at 14:25..
Reply With Quote
Reply

Thread Tools

Forum Jump


All times are GMT +8. The time now is 22:47.