How Can I Add The Integers Of 2 Columns And Display It In A Textbox?

Question

0.00/5 (No votes)

See more:

I have a table named tbproduct (P_id,P_price,P_interest,P_barcode) i want to add the values from P_price and P_interest and display it in a textbox for example if P_price is 100 and P_interest is 20 then the textbox should display 120
i have no idea how to do that
thank you!

Posted 29-Aug-15 19:42pm

Sahand_B

Add a Solution

2 solutions

Solution 2

That is 4 different questions:
- How to do a request to my SQL base.
- How to get the result of the request.
- How to add 2 value from the result.
- How to put a value in TextBox.

Which one is a problem for you ?
What have you done ?

If done nothing, do you have a problem with your analyse method ?

Posted 29-Aug-15 20:27pm

Patrice T

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)

DamithSL · Accepted Answer · 2015-08-29T20:12:00

Solution 1

SQL

SELECT P_id,P_price,P_interest,P_barcode, ( P_price+ P_interest) as T_price  tbproduct

then you can set T_price value as textbox text

Posted 29-Aug-15 20:12pm

DamithSL

v2

Comments

Sahand_B 30-Aug-15 2:42am

thanks it works perfect