能不能在DATASET裡面執行SQL語句的,如我要加總什麼的,
如在數據庫中可以這樣寫的:
select w_day,sum(qty) from lot
group by w_day
现在我将 lot 这张表里的数据全部FILL到DATASET里,
那我在DATASET裡面要达到上面SQL语句应该怎麼寫呢
...全文
49517打赏收藏
怎样在DATASET里面执行SQL语句
能不能在DATASET裡面執行SQL語句的,如我要加總什麼的, 如在數據庫中可以這樣寫的: select w_day,sum(qty) from lot group by w_day 现在我将 lot 这张表里的数据全部FILL到DATASET里, 那我在DATASET裡面要达到上面SQL语句应该怎麼寫呢
TO: 回复人: syeerzy(快乐永远*先天下之乐而乐*后天下之忧而忧*) ( ) 信誉:100
謝謝,我現在要做的是水晶報表,DATASET裡的數據是用戶處理過的,那麼我現在要用到
select w_day,sum(qty) from lot group by w_day
這種功能拿出數據給水晶報表用,是不是只能先將這個DATASET裡的數據填充到數據庫裡,
然後再用
select w_day,sum(qty) from lot group by w_day
去數據庫查詢出來呢
//c#
private void ComputeBySalesSalesID(DataSet myDataSet){
// Presumes a DataTable named "Orders" that has a column named "Total."
DataTable myTable;
myTable = myDataSet.Tables["Orders"];
// Declare an object variable.
object objSum;
objSum = myTable.Compute("Sum(Total)", "EmpID = 5");
}
//vb.ent
Private Sub ComputeBySalesSalesID(ByVal myDataSet As DataSet)
' Presumes a DataTable named "Orders" that has a column named "Total."
Dim myTable As DataTable
myTable = myDataSet.Tables("Orders")
' Declare an object variable.
Dim objSum As Object
objSum = myTable.Compute("Sum(Total)", "EmpID = 5")
End Sub