How to add or remove the quantity in stock display on a product table

Question

0.00/5 (No votes)

See more:

how to add stock-in product in product table?
example: If I add an additional product, it adds number of product in products table. I'm working an Inventory.

thanks.

Posted 22-Jul-12 14:50pm

ianshack

Updated 24-Jul-12 16:05pm

v5

Add a Solution

Comments

ianshack 22-Jul-12 21:29pm

yes sir on how to insert it, but I want to know on how to add an additional number of quantity in my quantity column in my table. I'm working with inventorying products.

Kenneth Haugland 22-Jul-12 21:32pm

You have to tell me what you want. Do you really want to add a new column in the SQL sercer? Or do you want to just add one column in the datatable?

Im a bit confused...

ianshack 22-Jul-12 21:44pm

sir, I have already my sample products table(prod_id, prod_name, quantity) and I want to update the products table to add an addtional number of products. If I click the update button the number of quantity didn't update.

[no name] 22-Jul-12 21:55pm

Well then you seriously need to update your question with what you have tried to do and what happened that you did not expect to happen.

Kenneth Haugland 22-Jul-12 21:51pm

This is normally done through adding a row, not a column... If you want more help, you should proivide us with a code snipplet were you add the data to the database.

ianshack 22-Jul-12 22:02pm

okay sir, thanks for your reply.

[no name] 24-Jul-12 22:51pm

Well since you are unable or unwilling to provide the information that would be needed to answer your question and your update is meaningless, I am afraid that the only answer that I could possibly give you is that you would update the quantity in your products table by using an SQL UPDATE statement. http://w3schools.com/sql/sql_update.asp

3 solutions

Solution 1

Something like this perhaps?

ALTER TABLE table_name
ADD column_name datatype

Posted 22-Jul-12 15:22pm

Kenneth Haugland

Comments

[no name] 22-Jul-12 21:26pm

I don't think that is what he is after.

Kenneth Haugland 22-Jul-12 21:30pm

I notist now... but imn not so sure....

Solution 2

CHeck out this link It might help:
http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/d11ed406-d9bf-4363-84b6-99f4e9ee4631/[^]

Posted 22-Jul-12 16:09pm

Kenneth Haugland

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Christian Graus · Accepted Answer · 2012-07-29T14:25:00

Solution 3

update mytable set mycolumn = mycolumn + 1

Posted 29-Jul-12 14:25pm

Christian Graus

Comments

ianshack 29-Jul-12 21:46pm

thanks for the idea sir, I really appreciate it.

Christian Graus 29-Jul-12 21:49pm

Sorry for the wait, I typed this and the site did not post it, then I just found it sitting here when I came back to this computer :-)

ianshack 29-Jul-12 21:52pm

I only change the + 1 into the value of my textbox control.
Here is my query:
"update product set prodName ='" & prodNameTextBox.Text & "', Quantity = Quantity + '" & (qtyTextBox.Text) & "' where prodId ='" & prodIdTextBox.Text & "'"

Christian Graus 29-Jul-12 22:01pm

This is really bad. You should not build SQL this way, it means anyone can erase your entire DB, just by changing those text box values. You should read up on SQL Injection attacks.

ianshack 31-Jul-12 0:35am

sir, can you give me example of update statement or revise my query statement to protect from SQL Injection attacks.

Christian Graus 31-Jul-12 0:36am

Replace prodNameTextBox.Text with @Product ( for example ) then add a parameter called @Product with the value. Then the class will protect you. Google 'paramaterized queries C#' for examples.