如何在文本框中获取sql(求和)查询的值? [英] How to get the value of sql (sum) query in textbox?

问题描述

我正在尝试从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屋！