合同以 hours 为计算单位select sum(hours) from order where ord_date>='2004/01/01'可以算出时间,但在哪里执行呢?
多谢两位指点,msdn 好像举例为 CS 的,我用VB 的,
you don't need to run a separate query, try Sub BindTheData()Dim strSql ="select orderid, emp_id, ord_date, hours from orders where ord_date>='2004/01/01'"Dim myDataSet As DataSet = New DataSet Dim myDataAdapter As SqlDataAdapter = New SqlDataAdapter(strSql, strConn)myDataAdapter.Fill(myDataSet, "order")if myDateSet.Tables("order").Rows.Count = 0 then Response.Write("对不起,记录未查到") Else dtgPM.DataSource = myDataSet.Tables(0) dtgPM.DataBind() YourTextBoxId.Text = myDateSet.Tables("order").Compute("SUM(hours)","").ToString() end ifEnd sub
2、或者使用单独的存储过程计算。
建议:你可以把合计信息放在页角这样更好看一些!
Sub BindTheData()Dim strSql ="select orderid, emp_id, ord_date, hours from orders where ord_date>='2004/01/01'"Dim myDataSet As DataSet = New DataSet
Dim myDataAdapter As SqlDataAdapter = New SqlDataAdapter(strSql, strConn)myDataAdapter.Fill(myDataSet, "order")if myDateSet.Tables("order").Rows.Count = 0 then
Response.Write("对不起,记录未查到")
Else
dtgPM.DataSource = myDataSet.Tables(0)
dtgPM.DataBind() YourTextBoxId.Text = myDateSet.Tables("order").Compute("SUM(hours)","").ToString()
end ifEnd sub