Important alert: (current site time 7/16/2013 9:59:20 AM EDT)
 

winzip icon

Sales and Inventory using Barcode Reader Lan Base ( V2 )

Email
Submitted on: 4/22/2011 9:01:40 AM
By: Angelito Tan  
Level: Advanced
User Rating: By 38 Users
Compatibility: VB.NET
Views: 20877
author picture
 
     Sales and Inventory, can be use either in LAN or STANDALONE, written in VB.NET 2008 PRO along with SQL_SERVER 2005 / 2008, can also be use with or without barcode reader.. Some of the work are been modify by me in my previous upload, i hope you like some major changes i've made, i've created major modification specially when inputting special character and many more.. HOPE YOU ENJOY IT =)).. DON'T FORGET TO VOTE !!! Thanks a lot..

 
winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come out every day, so no prevention program can catch 100% of them. For your own safety, please:
  1. Re-scan downloaded files using your personal virus checker before using it.
  2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
  1. You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
  2. You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
  3. You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
  4. You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 2 submission(s) by this author

 


Report Bad Submission
Use this form to tell us if this entry should be deleted (i.e contains no code, is a virus, etc.).
This submission should be removed because:

Your Vote

What do you think of this code (in the Advanced category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor (See voting log ...)
 

Other User Comments

4/20/2011 4:33:41 AM

cannot download:
"The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. "
(If this comment was disrespectful, please report it.)

 
4/20/2011 5:05:42 AMMahmoud mohamed

i click om Download Code and it doesn't work.
could you please send it to my email
eng_rabie85@yahoo.com
(If this comment was disrespectful, please report it.)

 
4/20/2011 10:12:28 PMAdrian

i can't download the file, please resubmit
(If this comment was disrespectful, please report it.)

 
4/22/2011 10:55:25 AMAngelito Tan

guys sorry for the late reply, yep, i resubmit the source code, hope it works now, tnx for the comment =)) god bless.
(If this comment was disrespectful, please report it.)

 
4/25/2011 3:36:28 AMrolan

sir good day..nice work..
(If this comment was disrespectful, please report it.)

 
4/26/2011 4:31:16 PM

My wife has a clothes shop, the only thing I'm mising in your application is that a product can have different colors and sizes and the retail / cost price can be different for each each matrix item.

A little bit like the following website:
http://help.kcsi.ca/simms/default.aspx?pageid=apparel_cost_price

(If this comment was disrespectful, please report it.)

 
4/29/2011 1:44:28 AMAngelito Tan

good day sir, the system is intended for Supplies like, grocery item, car parts and etc.. feel free to use the system, for the concern i can say that you really need to edit the source code, just the source code, because the flow is already there, you just need to put the additional criteria for the use of the system... thanks for the reply, godbless..
(If this comment was disrespectful, please report it.)

 
4/30/2011 8:51:08 AMNavdeep

can this project convert to vs2010 ?
(If this comment was disrespectful, please report it.)

 
5/5/2011 2:05:24 AMRishi Saxena

Very nice coded and good interface
(If this comment was disrespectful, please report it.)

 
5/9/2011 12:23:03 PMVeli KAYA

Interface nice, code best nice. Thanks to sharing.
(If this comment was disrespectful, please report it.)

 
5/22/2011 6:32:02 PMTegwin

This is very nice code.. thanks for sharing.. IT works really very well

(If this comment was disrespectful, please report it.)

 
5/24/2011 5:19:29 AMMohamed Nagah

very good my frind
but i can't find database
(If this comment was disrespectful, please report it.)

 
6/13/2011 12:47:38 PMTamene

i am down load first and second version, it is a good interface and easy understand for end user. i am appreciate your system. but i have a ?. this system done on physical printer. which physical printer is done by this system. pls inform by email... tamenetamrat@gmail.com
(If this comment was disrespectful, please report it.)

 
6/21/2011 3:03:38 AMThuan Than

Very nice. Thanks for sharing
(If this comment was disrespectful, please report it.)

 
6/21/2011 3:21:58 AM10

Hi,
Nice work ! Do you have a print routine for Epson TM-L60 Bar code printer?
(If this comment was disrespectful, please report it.)

 
6/21/2011 6:05:31 AMMasood H. Virk

good work
(If this comment was disrespectful, please report it.)

 
6/27/2011 2:50:16 PMTamene

Hi i am seen your system it's v.good, but it's done on physical printer?
thank u
tamenetamrat@gmail.com
(If this comment was disrespectful, please report it.)

 
7/15/2011 4:43:51 PMpawan

could you please tel me your crystal report version u are using in your application and from where i can get it .i am using VS 2010.
thanks
(If this comment was disrespectful, please report it.)

 
7/27/2011 9:48:17 PMMarvin Glenn Lacuna

I think you this is pretty much good but i cant connect to sql even i have the SQL SERVER r2 developer kit. what do i need to for this :(
(If this comment was disrespectful, please report it.)

 
7/28/2011 10:59:28 AMAngelito Tan

@pawan, i use cyrstal report thats in vb.net 2008 Pro..
(If this comment was disrespectful, please report it.)

 
8/1/2011 4:20:33 AMjav

Plz. send database SaleInv_DB.mdf
E-mail. jav17@rediffmail.com
thank u
(If this comment was disrespectful, please report it.)

 
8/1/2011 4:23:50 AMjav

Plz. send database SaleInv_DB.mdf
E-mail. jav17@rediffmail.com
thanks
(If this comment was disrespectful, please report it.)

 
8/5/2011 10:14:29 PMAngelito Tan

@jav, please do search on the folder that says "_SCRIPTS_SQL_DATABASE" and do google on how to execute a script, you will soon see SaleInv_Db.mdf, tnx :D
(If this comment was disrespectful, please report it.)

 
8/6/2011 2:19:22 AMarie354

Tank's alot sir,,,,

:)
(If this comment was disrespectful, please report it.)

 
8/25/2011 11:49:36 AMjav

Tank's alot
(If this comment was disrespectful, please report it.)

 
8/25/2011 12:31:00 PMoko

First of all thank you sr.
I was wondering if you could provide a script of the data base compatible with sql server 2000? if you can please do, and thanks again.
(If this comment was disrespectful, please report it.)

 
8/29/2011 3:16:22 PMArpan

how to vote??
(If this comment was disrespectful, please report it.)

 
9/16/2011 10:00:22 PMczarina

this system will help me a lot in my thesis thanks...
(If this comment was disrespectful, please report it.)

 
11/4/2011 9:45:23 AMexception

good

(If this comment was disrespectful, please report it.)

 
12/3/2011 10:53:42 AMmennen

i need some help please. i 've chosen standalone connection on the server settings, placed the server name that shows on my sql server 2008 express management studio, logged-in with the username and password found on the notepad, then the server setting window went back. did i got the server name wrong?help please?
(If this comment was disrespectful, please report it.)

 
12/3/2011 11:00:12 AMmennen

i need help please. i can't log-in. i keep going back and forth with serving settings and the log-in form. i chose standalone connection and placed the server name that shows on my sql server management studio.which is DARKTHUNDER-PC\SQLEXPRESS. the log in form shows, i entered the username and password from the notepad, clicked log-in and the server settings showed up again. help please? i really need this project.
(If this comment was disrespectful, please report it.)

 
12/7/2011 6:29:02 AMmennen

Sir! The buttons are invisible on the form during design but visible during design. how did you do that? i've tried tinkering with it and even googling it.
(If this comment was disrespectful, please report it.)

 
12/19/2011 6:58:35 AMAngelito Tan

@mennen - it should work fine, if you choose stand-alone, and put your sql servername and without entering a username and password it will work, if it doesn't work may be there's something wrong that blocking the connection of your SQL SERVER maybe the settings, firewall etc.. THATS ONLY MY WILD GUESS, but try it maybe it will work, or choose stand-alone and in the sql server name, put the IP ADDRESS of your PC/Laptop, Just IP ADDRESS only, then try running the system.... thank you, if you doesn't make it right, feel free to message me at my fb accnt: angelito.tan23@yahoo.com, thank you.. have a nice day..
(If this comment was disrespectful, please report it.)

 
12/27/2011 2:59:57 PMiqy

hay Mr.tan why the bar code generator dont print the bar code image... just print the numbers with blank bar code image ?
thks BTW it really cool...
(If this comment was disrespectful, please report it.)

 
1/9/2012 12:54:32 PMAngelito Tan

to iqy, dude i think i put that note in the Common Problem TO encounter (READ ME).doc, if i'm not mistaken i mentioned it there, anyway just download the code39 font, if your lucky you will find a installer that will automaticaly put in on the system -> font if not put it in your system -> font where all FONTS is located, and the next time you will try to print the barcode "tarranrrnnn", it has an images.. :D tnx :D
(If this comment was disrespectful, please report it.)

 
1/28/2012 11:39:10 PMAsep

Thank's
(If this comment was disrespectful, please report it.)

 
2/1/2012 11:18:29 PMAndy

Tnx a lot. plz send to my email the SaleInv_Db.mdf. and log file. (pakol27@yahoo.com)
(If this comment was disrespectful, please report it.)

 
2/4/2012 4:20:02 AMAngelito Tan

to andy.. dude it's already on the download file :D
(If this comment was disrespectful, please report it.)

 
2/15/2012 1:28:02 AMiqy

mr. Tan... the data base is uneditable except
i mean i can insert new data or edit but it can't read in the program....
(If this comment was disrespectful, please report it.)

 
2/15/2012 1:50:05 AMiqy

mr.tan what is the function of acces file in data base? could the connection and the database just use the acces database ???
(If this comment was disrespectful, please report it.)

 
2/21/2012 12:38:14 PMShajil Thottungal

Angelito Tan, Excellent work..! Thank you for sharing...
(If this comment was disrespectful, please report it.)

 
2/28/2012 7:24:54 AMdwi

angelito,i can't edit your report label in crystal reports..
i'm using visual basic 2008 pro and i had edited some label in reports but if im execute the report,the report has no change.. help me :(
thanks before
(If this comment was disrespectful, please report it.)

 
3/7/2012 6:21:21 AMAngelito Tan

@dwi : dude, for the design the file path is prjSalesInventory/reportX <-- this folder contains all the design, if you edit the report and you want to see the changes, copy the prjSalesInventory/reportX to prjSalesInventory/bin/debug/reportX..
(If this comment was disrespectful, please report it.)

 
3/13/2012 3:30:08 PMdwi

thank you very much tan! it's work perfectly :)

I think this program pretty interesting and I will learn to develop it for me personally, may I contact you personally through your email?

thanks before tan! :)
(If this comment was disrespectful, please report it.)

 
3/24/2012 1:17:46 PMwong sinau

it's great coding..
(If this comment was disrespectful, please report it.)

 
4/17/2012 6:13:13 AMDaryl

Hi.. Your program looks awsome :D... But, when I tried to look at barcode system : System File -> Inventory File -> Barcode Form and try for generate barcode, it only gives me 1312131 like that but no barcode image .. How to make it works actually? is this need some software first ? or what? Thanks :D
(If this comment was disrespectful, please report it.)

 
4/26/2012 8:59:34 AMRishi Saxena

Gr8 coding. Angelito, I need your help. I am trying to add new report, I created the SQL Query and designed the report. But my problem is I want to get the record for a particular ID but it showing me all the records from the table, its just behaving like the report couldn't find the new datasource from FrmReports file. Please help
(If this comment was disrespectful, please report it.)

 
5/21/2012 8:48:44 AMsandy

I have visual basic 2008 express version. How can I use this code. It is showing error for crystal report. Help.
(If this comment was disrespectful, please report it.)

 
9/6/2012 4:24:42 PMAngelito Tan

@Rishi Saxena, on the code where report is genarated, make changes on it then the report will generated the records base on the code you put, don't do it on the crystal report it will ask you for a datasource, but it you want you can make some temporary datasource if you just want to try to test..

@sandy, visual basic 2008 express, doesn't have a crystal report, my vb.net 2008 Pro has it already on the installation, so meaning to say you have to download a crystal report for that...

Hope it helps, for the future Comments, please i do advise that all common problem has been written on the ( .doc ) file included on the download...Thank you
(If this comment was disrespectful, please report it.)

 
9/8/2012 10:38:00 AMmhack

pare musta? A couple of questions lang....

A. Pag gagamit ako ng POS drawer or drawer at pag tender ko ng cash bubukas ba ang drawer or POS drawer?

B. What printer and gagamitin dito or compatible? pwede ba ang POS printer? compatible din ba to sa thermal printer?

Yung lang pare. Thanks.....
(If this comment was disrespectful, please report it.)

 
9/20/2012 11:07:12 PMH K

Thanks for the amazing codes, which sort of barcode readers should i use with it?
(If this comment was disrespectful, please report it.)

 
9/25/2012 3:33:57 PMAngelito Tan

@mhack, tol
Answer A: d pa yan connected sa machine na drawer, d ko pa na test yun dun, barcode lng yung machine na tested dyan e

Answer B: Actually tol, compatible naman lahat ng printer, ang tanong yung printer na gagamitin is compatible sa pc/os?? pero tingin ko naman now a days halos lahat compatible at supported na..not sure sa linux..pero usually pag nag iinstall lng printer sa machine, driver lang kelangan, it depends n lng cguro kung saang OS mo to iinstall baka mamaya yung driver is for Windows (95,2000,xp,vista,7,8) lang pala available, tapos yung machine mo running ng linux...

@H K, all barcode readers can be use on that :D it's a plug and play..

tnx godbless..
(If this comment was disrespectful, please report it.)

 
9/26/2012 8:04:12 PMRodgie Jalamana

Mr. Tan, Thank you...
may idea na ako sa POS...
(If this comment was disrespectful, please report it.)

 
10/10/2012 7:37:56 AMAdel

Very nice job
(If this comment was disrespectful, please report it.)

 
12/6/2012 2:36:42 AMMarwan

thank you very much tan! it's work perfectly .Thanks again for sharing use this great code
(If this comment was disrespectful, please report it.)

 
6/9/2013 1:29:01 PMCalistoh Owino

Nice code but now how do l make tax exempted sales?
(If this comment was disrespectful, please report it.)

 
6/11/2013 6:56:41 PMPaul Robert Martinez

Great code sir Angelito, but im still figuring out how to configure the database... hahaha
(If this comment was disrespectful, please report it.)

 

Add Your Feedback
Your feedback will be posted below and an email sent to the author. Please remember that the author was kind enough to share this with you, so any criticisms must be stated politely, or they will be deleted. (For feedback not related to this particular code, please click here instead.)
 

To post feedback, first please login.