操作给出错误的结果 [英] operation gives incorrect result

问题描述

大家好，

操作提供的结果不正确， 真相是什么？

Operation gives incorrect result, what is the truth?

你能帮助我。

 SqlDataSource1.SelectCommand = "select s1.marka,s1.renkkodu,s1.renkadi, " +
                "SUM(case when s1.yontem = 'g' then s1.kilo else 0 end) - SUM(case when s1.yontem = 'c' then s1.kilo else 0 end) as kilo" +
                " from byh_boya_kalan_tbl s1" +
                " group by s1.marka,s1.renkkodu,s1.renkadi order by s1.renkadi";

推荐答案

这就是你所谓的"操作"什么都不做。 

This, what you call an operation" does nothing. 

它可以是dataadapter的一部分，但是正常，因为DataAdapter需要一个select，以及一个无法制作的Update，Insert和Delete operationg字符串使用这种SQL语句。

It can be a part of a dataadapter, but normal for that because a DataAdapter needs beside a select as well an Update,Insert and Delete operationg string that cannot be made with this kind of SQL statements.

这篇关于操作给出错误的结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！