如何在文本框中获取sql(求和)查询的值? [英] How to get the value of sql (sum) query in textbox?
本文介绍了如何在文本框中获取sql(求和)查询的值?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试从sql查询中获取值,该值获取特定列的总和.我希望它显示在文本框/标签上,以便可以将其插入到另一个表中.我怎样才能做到这一点?我正在使用Oracle.DataAccess.我正在尝试ExecuteScalar,但它给了我一个错误.该怎么办?谢谢!这是我的代码:
Hi, I am trying to get the value from sql query which getting the sum of an specific column. I want it to display on textbox/label so that I could insert it to another table. How can I do this? I am using Oracle.DataAccess. I am trying that ExecuteScalar but it gives me an error. What to do? Thanks! Here is my code:
eSQl = "SELECT sum(inttotal) FROM tbltrans where prj_code='"+txtPrjCod.Text+"' group by prj_code";
SQLdr = DBCon.show(eSQl);
while (SQLdr.Read())
{
tot = Convert.ToInt32(SQLdr.GetOracleValue(30).ToString());
textBox1.Text = tot.ToString();
}
SQLdr.Close();
推荐答案
请按以下方式更新您的查询.
Hi,
Please update your query as below.
eSQl = "SELECT sum(inttotal)as TOTAL FROM tbltrans where prj_code='"+txtPrjCod.Text+"'";
然后从dr读取值
Then read value from dr as
while (SQLdr.Read())
{
tot = Convert.ToInt32(SQLdr.GetOracleValue(0).ToString());
textBox1.Text = tot.ToString();
}
这篇关于如何在文本框中获取sql(求和)查询的值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文