c# Demo database project - Product and subparts

A simple database application for products and subparts composing the product

project must be done in Visual Studio 2013 c#, database SQL server.

Full source code and database must be provided.

The purpose is to have a small application that stores information about a product and its composing parts (which are products as well).

To give you an idea let’s start with a sample product: a car.

Product: CAR

PN: 11220

Description: Ferrari

Serial No: 1

Composing parts

Product: Engine

PN: 11230

Description: The best Engine

Serial No: 1123

Composing parts

Product: chassis

PN: 12230

Description: Aluminum die

Serial No: 1323


Product: piston block

PN: 1234

Description: complete piston section

Serial No: 1343


Product: chassis

PN: 143530

Description: Red Ferrari chassis

Serial No: 145


Product: front wheel block

PN: 1434230

Description: front wheel block complete

Serial No: 14345


Product: rear wheel block

PN: 1434430

Description: rear wheel block complete

Serial No: 1433345

Database structure

The database shall follow the following structure or if you have a better alternative you can propose it before bidding.

Main table

Field type

PARTID text 30

Father like partID

Description text 60

Field 2 text 60

Field 3 text 60

Notes table

Field Type

PARTID text 30 used to link to the main table

Date date

Description text 60

Who text 30

The field Father contains the PARTID of the container product if any.

Application behavior

By entering a PARTID, the application shall search in the database and if there is already a record whith that PARTID it shall simply retrieve all the related information and display them or edit.

If it is not present, after a confirmation it shall create a new record and allow the user to fill in its information.

In the subparts section it shall always display all the matching subparts, this means all the other records which Father field matches the current PARTID.

It shall be possible to add subparts at any time by simply entering the PARTID in the subpart section. If the PARTID is found it shall simply update (after a confirmation) its father field to the current PARTID.

If it is not found for the moment it shall simply do nothing.

Notes Section

Just contains notes related to the current product.

Notes are stored in a different table of the database. It shall be possible to add notes.

I forgot the following behaviour...

by double-clicking on one of the subparts and no changes have been made, the application shall switch to the record of that subparts which shall become the current product.

One more requirement that I forgot...
of course it must work with windows 64bit and 32bit

Skills: C# Programmering, Programmering af database

See more: studio 1234, structure stores, red engine, database programming sql, container programming, container in c, red die, product a, new father, ferrari, database sql, database project, database application, chassis, C# database, c programming notes, simple notes database, sql update text, sql update field text, project aluminum, sample description product, sql server front, sample product, code block project, sql retrieve table

About the Employer:
( 4 reviews ) quintano, Italy

Project ID: #6018611

Awarded to:


Hello, I am very much interested to do this work as i am experienced a lot in C# and ms sql server. I understand your requirements and i think i can do this work efficiently. Looking forward to have a positive respons More

$96 USD in 2 days
(6 Reviews)

11 freelancers are bidding on average $130 for this job


hi i have 5 + years of exp n .net development please visit my profile once to know about my past project and reviews. i can handle this project and deliver it on time thanks arpit

$144 USD in 5 days
(12 Reviews)

Hello sir. I have great experience with c# programming. I can do your job very fast and very good. if you are interested, we can discuss more about price and time. regards vladang

$105 USD in 3 days
(18 Reviews)

Dear Sir! Please see some sites i have design and developed: ASP/ASP.NET site: [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] More

$133 USD in 3 days
(9 Reviews)

hi immediately ready to start work please message me back then i can show you our work . you really love our work. regards shabirkssol

$127 USD in 2 days
(2 Reviews)

I'm a fulltime freelancer. I have experience in Winform using visualstudio 2013 and sqlserver 2012 But can you use SQLCE 3.5 replace for sqlserver ?. It simple to install

$100 USD in 3 days
(2 Reviews)

A proposal has not yet been provided

$87 USD in 3 days
(1 Review)

Dear sir we are professional in c# and sql server we will provide you fast and accurate results with in no time. thanks

$222 USD in 3 days
(0 Reviews)

Hello, I'm a professional Microsoft .NET Developer with more than 2.5 years of commercial experience. I can get your task done within 2 days ( will be working on evenings part-time) + couple of hours to test it. More

$166 USD in 2 days
(0 Reviews)

Hello, Owasqa is a leading independent provider of IT services, Owasqa came into existence in 2011 to expand its operations in the worldwide Software Engineering Industry. We have checked your database project de More

$100 USD in 10 days
(0 Reviews)

I have been implementing code in C# , Python,Java, C++, C for last 4 year and as this needs good knowledge of C# language, I have good experience in these. I have developed many software in Java and more than 1000 code More

$120 USD in 3 days
(0 Reviews)

our main purpose is many client are connect with us and wide network. we are developed by accounting base software and web developing so your concept are cover with our work so our employee are accepted your work. i More

$155 USD in 3 days
(0 Reviews)