How Do I Show A Single Item's Details Profit With It's Details Too?

Question

1.00/5 (2 votes)

See more:

Greetings All, I am working on a POS System in VB.NET 2010. i need to display the profit of a single item using barcode which is working but i need also to retrieve all the item's details as well. I can only pull the profit but not with the item's details too.

[Code added from answer/comment]

VB

'Adapter query:

SELECT        SUM((ItemSellPrice - ItemBuyPrice) * ItemCount) AS ItemTotalProfit
FROM            ReceiptDetails
WHERE        (Barcode = ?)

'button Code:
If ComboBox1.Text = "Item Total Profit" Then
            txtRptBarcode.Show()

            Me.ItemTotalProfitTableAdapter.FillByItemTotalProfit(Me.POSDS.ItemTotalProfit, txtRptBarcode.Text)

            ITPRV.Show()

Posted 19-Sep-14 2:00am

TechVille

Updated 19-Sep-14 3:56am

Pheonyx

v2

Add a Solution

Comments

Pheonyx 19-Sep-14 8:08am

Then you need to write some code to do so... especially as you have told us nothing here about your issue. What code you are using and where it is failing. Also it would be useful to know a bit about your item objects and how they are stored in what ever database you are using.......

TechVille 19-Sep-14 8:22am

Sorry for Posting my question that shallow....
I am using a TableAdapter in which i have added this query:

SELECT SUM((ItemSellPrice - ItemBuyPrice) * ItemCount) AS ItemTotalProfit
FROM ReceiptDetails
WHERE (Barcode = ?)
On the Form I have a button in which i have the following code which displays the "Item's Profit" in a Report (ITPRV):
If ComboBox1.Text = "Item Total Profit" Then
txtRptBarcode.Show()

Me.ItemTotalProfitTableAdapter.FillByItemTotalProfit(Me.POSDS.ItemTotalProfit, txtRptBarcode.Text)

ITPRV.Show()
The other item's details which i need to display are: Barcode, ItemName, ItemSellPrice

Pheonyx 19-Sep-14 9:58am

You need to tell us how your "ReceiptDetails" table links to your Item/Stock details table and the field names.

TechVille 19-Sep-14 10:06am

Both ReceiptDetails table and Items table are in a relationship with the barcode as the primary key.
i have not used complex connections as i am a begginner, just added the db to my application and used tableadapter queries for nearly all my queries.
Please excuse my poor terminology.... am still a beginner in vb.net

1 solution

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)

Pheonyx · Accepted Answer · 2014-09-19T04:16:00

Based on what you have said, I believe this sql query should pull all the information:

SQL

SELECT SUM((rd.ItemSellPrice - rd.ItemBuyPrice) * rd.ItemCount) AS ItemTotalProfit, i.Barcode, i.ItemName, i.ItemSellPrice
FROM ReceiptDetails as rd join Items as i on rd.Barcode = i.Barcode
WHERE (rd.Barcode = ?)

I've assumed that Barcode, ItemName and ItemSellPrice are all fields in the Item table.
You need to extend your dataset to be able to hold these additional fields.

Let me know how that goes for you.