操作给出错误的结果

本文介绍了操作给出错误的结果的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

大家好，

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

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.