Sales and Inventory using barcode reader can be use in LAN Base or Standalone, i use VB.NET 2008 PRO along with SQL SERVER 2008, the idea of this is to show how simple barcode reader is running on every machine, even on the store or malls, i also use 39Code ( just download this on the net, its available and FREE, it came with an installer ) for the font, to generate the picture of the barcode, hope you enjoy my simple idea =), gudluck and have fun..
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:
Re-scan downloaded files using your personal virus checker before using it.
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
Terms of Agreement:
By using this code, you agree to the following terms...
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.
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.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
sir, i downloaded your codes, but i'm having difficulties on running it. it always says that the database is invalid, but i already attached the database. i'm using sql server 2008. but this code is really helpful , i just want to see how it works. thanks :) (If this comment was disrespectful, please report it.)
just change the connection strings and set it directly to the database path. i already run the system, however when i'm trying to view the reports it also prompts to login to the database. (If this comment was disrespectful, please report it.)
OK, mr.tan database problem has been solved and for those who'd trouble with database connection try to change the connection string with something like this : CnString = "Provider=SQLOLEDB;Data Source=IT\SQLSERVER2008;Initial Catalog=MTM_BevandaDB;User Id=sa;Password=okedeh;" but another problem came up with the report (always ask for password and user id) any solution myfriend ???? (If this comment was disrespectful, please report it.)
@ apullica - i already found out the solution regarding reports, just open the reports from solution explorer then under crystal reports menu, click verify database and change the CPAT server name to your server name, you have to do this for all of the .rpt files so that you can view all of the reports. thanks. (If this comment was disrespectful, please report it.)
Ok this is how it works, change the set datasource location, create new connection, "ODBC(RDO)" then find the SQLCONNECT3.dsn under SQL_DATABASE.. after you do that, click the update button, and change the INFORMATION of your SQLCONNECT3.dsn.. and the last you will do is Copy all the in the reportX, to \bin\Debug\ReportX, and thats it.. hope you find it usefull.. i will re-upload this so that the report will run.. just take in mind that you only NEED to PUT the File on C:\, i will fix this.. tnks so much =) (If this comment was disrespectful, please report it.)
in the cashiering module you can select the dropdown list and choose "barcode", then if you already have an item with a barcode in the stocks, just get the barcode and it will work, anyway barcode reader is just a PLUG and PLAY, if you have one then just punch anybrand of item with a barcode in it, and it will work by the way item with a barcode should be available first in the stocks monitoring, to have a stocks you will need to purchased from a supplier... tnx i hope that it helps , godbless. (If this comment was disrespectful, please report it.)
sir. i understand now :) thank you, but do you have a manual way of inputing products in cart specially if the company doesn't want to use barcode device ? (If this comment was disrespectful, please report it.)
@ delta.. yes it can, but i din't put that, i have a few changes in my latest system and i put the fast and slow moving product i didn't add any fields or table, it already exist in there :D tnx for asking
@ marco, i never tried to convert it on 2005 :D just search it on google perhpas :D tnx for the comment
@Umisha.. Perhaps you forgot to attach the database on the sql server 2008.. Tnx (If this comment was disrespectful, please report it.)
@Mohsen Majnouni, at the solution explorer click the show all files, and you will see what's missing, after that, go to Project tab > add reference, then there you go add all the missing reference, there's a posibility that in will produce same error, just remove the reference that has an exclamation point and add it again on the add reference .. tnx hope it helps =)) godbless. (If this comment was disrespectful, please report it.)
adding to my question, how can i edit the font for the "Products Barcode" that only print numbers , where can i change the font for the item's barcode number in that section sir? (If this comment was disrespectful, please report it.)
Mr Tan, Can you assist me as I cant configure the database. There is no SQLConnect3.dsn. I am thinking on how could I attach the mdf file you provided. can you please help me. thanks (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.)