我如何从Sql中减去？ [英] How Can I Minus From Sql?

问题描述

嗨。

我的数据库中有两个字段。代码和标记

我在我的程序中有标签它有号码。

i想要减去label.text这样的标记，像这样的mark-label1.text代码是1



我写了这段代码，但没有回答。

 Dim da As New SqlDataAdapter（< span class =code-string>  select mark  - ' + label1.text +  '来自Tbl_StudentMark，其中code =' +  1  +  '，con）

请帮助我。

解决方案

请写下面的方式

 Dim da As New SqlDataAdapter（  select（mark  -  + label1.text +  ）作为Tbl_StudentMark w的余额这里code =' +  1  +  '，con）

从Tbl_StudentMark中选择datediff（dd，'+ label.text +'，mark），其中code =' + 1 +'





如果我的查询对你有帮助。选择我的答案为接受答案

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.

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

please help me.

解决方案

Hi,

Please write in below way

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

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"

这篇关于我如何从Sql中减去？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！