How Can I Minus From Sql?

Question

1.00/5 (2 votes)

See more:

hi.
i have two field in my database. code and mark
and i have label in my program that it has number.
i want minus mark from label.text like this "mark-label1.text" where code is 1

I wrote this code but it did not answer.

C#

Dim da As New SqlDataAdapter("select mark-'" + label1.text + "' from Tbl_StudentMark where code='" + 1 + "'", con)

please help me.

Posted 4-Jul-14 14:30pm

Mohammad Hasanpoor

Updated 4-Jul-14 16:35pm

DamithSL

v2

Add a Solution

Comments

DamithSL 4-Jul-14 22:33pm

what is the column data types of mark and code?
It Should Work Normally[^]

Atyant Srivastava 5-Jul-14 0:50am

Please check what is the final query getting generated from the above code through quick watch and copy that query to sql and see whether it is running. you will get the issue.
Also just want to know what value you label.text is having?

2 solutions

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)

Sarvesh Kumar Gupta · Answer 1 · 2014-07-04T20:13:00

Solution 2

Hi,

Please write in below way

C#

Dim da As New SqlDataAdapter("select (mark-" + label1.text + ") as Balance from Tbl_StudentMark where code='" + 1 + "'", con)

Posted 4-Jul-14 20:13pm

Sarvesh Kumar Gupta

sushil7350 · Answer 2 · 2014-07-04T19:12:00

Solution 1

select datediff(dd,'"+label.text+"',mark) from Tbl_StudentMark where code='" + 1 + "'"

if my query is helpful for u .select my answer as "Accept answer"

Posted 4-Jul-14 19:12pm

sushil7350

Updated 4-Jul-14 19:13pm

v2

Comments

Atyant Srivastava 5-Jul-14 2:16am

i suppose this will work for dates only not in the case of integer as mark could be a integer field not a date field.