Hello Geeks .. This post is one of our completely Free Projects .. It is a Pharmacy Project that can perform a lot of operations you can also find the (.dll) files for the working Barcode Reader Machines in your country and add it to the project .
Steps to get the project working :
- Create an SQLserver Database Then create two tables
- Phar_Item_Info Then add this fields :
- ID >> DataType : Int (Primary Key)
- Class >> DataType : nvarchar(50)
- Company >> nvarchar(50)
- Type >> nvarchar(50)
- Price >> money
- Notes >> nvarchar(150)
- LoginInfo With this fields :
- ID >> DataType : Int (Primary Key)
- Password >> nvarchar(50)
- Create a Stored Procedure and Implement this code inside it :
ALTER PROCEDURE insert_Data @ID int,@Class nvarchar(50),@Company nvarchar(50),@Type nvarchar(50),@Price Money,@Notes nvarchar(150)
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
insert into Phar_Item_Info (ID,Class,Company,Type,Price,Notes) values(@ID,@Class,@Company,@Type,@Price,@Notes)
/* SET NOCOUNT ON */
RETURN - Open The Project on Visual Studio then go to Class Connection.cs Then Edit the connection string to be the one suitable for your server.
- You can add a lot of improvements to this project such as the Barcode Reader , Charts for Inventory Level , Total Sales and much more ..
Download The Full Project For Free ( Media Fire)
You May Also Read :
- How To Create Chat Application Using C#
- Programming languages ranking | March 2015
- Programming languages ranking | Feb 2015
- Think outside of the box!
- WPF Text To Speech C# Application
- ASP.NET Web Service for Login/Register-Insert/Update/Delete Queries
- C# Tic Tac Toe Game With Source Code
- Listening! A Very Important skill for every computer technician
Comments
Post a Comment
We Care About Your Opinion !