用于SUM（字段）的ExecuteScaler [英] ExecuteScaler for SUM(field)

问题描述

大家好吧



我想在表中的Sum字段如下：

Hi all

I wanna Sum field in table as bellow :

DataTable dt = new DataTable();
string query_arr = "SELECT Item_factor, SUM(number_item_factor) AS EX1 FROM Detail_factor_sell GROUP BY Item_factor"; 
db.Query_Select_ExecuteScaler(query_arr);   

在查询设计器中进行测试时查询是正确的，但我想返回两个字段（Item_factor，SUM（number_item_factor））。我怎么做？



非常感谢。

the query is correct when test in query designer but I want to return two field ( Item_factor , SUM(number_item_factor) ). how do i it??

thanks a lot.

推荐答案

你可以使用SqlDataReader，示例代码

you can use SqlDataReader, sample code

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (SqlCommand command = new SqlCommand("SELECT top 1 Item_factor, SUM(number_item_factor) AS EX1 FROM Detail_factor_sell GROUP BY Item_factor", connection))
    {
    SqlDataReader reader = command.ExecuteReader();
    if (reader.Read())
    {
        string Item_factor= reader.GetString(0);
        int sumNumber_item_factor= reader.GetInt32(1);
    }
    }
}

这篇关于用于SUM（字段）的ExecuteScaler的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！