How can be get value from it's value_ID in windows C#

Question

0.00/5 (No votes)

See more:

There is one Datagridview. It has three columns like

FruitId | FruitPrice | FruitName
1 | 100 |
2 | 200 |
3 | 300 |

these value comes from table_FruitPrice
Now finally I want to display in third column FruitName by its FruitId that is presenting in column one and FruitName will come from Table_FruitName.

Please help anyone....

What I have tried:

......................................

Posted 2-Aug-16 19:53pm

Member 12245539

Updated 2-Aug-16 20:16pm

Add a Solution

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)

Animesh Datta · Answer 1 · 2016-08-02T20:16:00

Solution 1

Hello ,
(Assuming that you are fetching records by Store Procedure or Sql Command and then showing records in DataGridView).

Before display the records in DataGridView , first join two tables named as 'table_FruitPrice' and 'table_FruitName' by FruitId and then show the record in DataGridView.

Sql Query will be

Select a.FruitId,  a.FruitPrice ,  b.FruitName from table_FruitPrice a inner join table_FruitName b on a.FruitId=b.FruitId

Thanks

Posted 2-Aug-16 20:16pm

Animesh Datta

Comments

Member 12245539 3-Aug-16 2:42am

Yes exactly

But I want a different this values work form laod event

FruitId | FruitPrice | FruitName
1 | 100 |
2 | 200 |
3 | 300 |

And I want to display by hitting on button

FruitId | FruitPrice | FruitName
1 | 100 | Banana
2 | 200 | Tomato
3 | 300 | Orange

Animesh Datta 3-Aug-16 4:10am

why you want this type of approach ?

Member 12245539 3-Aug-16 4:38am

because
Two more table are there in name of Storate_Table & Sale_Table. Storage_table has a fixed quantity. And Sale_table is containing only the products have been sold out.

Datagridview showing the remaining quantities and for this I have fixed a subtract formula to subtract.

Animesh Datta 3-Aug-16 7:10am

but where is the problem with "FruitName" column ?