How to rectify the error in datagrid view calculation for quantity column

Question

0.00/5 (No votes)

See more:

sir,

This is the query I have used for linking two Datagridview for qty calculation.
There is an error showing that " the variable insert is assigned but its value is never been used".

What I have tried:

This is the code given below.

string insert = ("SELECT dbo.tblSubAssyCreation.Qty, dbo.tblDetailedPlan.Qty FROM dbo.tblSubAssyCreation INNER JOIN dbo.tblDetailedPlan ON dbo.tblSubAssyCreation.ID = dbo.tblDetailedPlan.ID where tblDetailedPlan.Qty = tblSubAssyCreation.Qty*tblDetailedPlan.Qty");

Kindly help me.

With Regards

(T.E. SRINIVASARAGHAVAN).

Posted 18-Sep-16 0:43am

tesraghavan

Updated 18-Sep-16 1:09am

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)

OriginalGriff · Answer 1 · 2016-09-18T01:09:00

We can't: the error means exactly what is says.

The variable insert is assigned but its value is never been used

You have declared insert, you have given it an initial value, but you do not use it in your code again.
We can't fix that: we have no idea what the rest of your code does, or where the variable is supposed to fit in!