select sum(size) as 变量名 from box where .......后在dataset中取回就好
解决方案 »
- table宽度问题
- <pages validateRequest="false" />怎么没有效果在vs2010中
- 用datareader从数据库检索出后的数据怎么在页面上分页显示?是不是只能够用dataset才能够分页显示呢?
- 如何修復IIS---誰遇到過類似故障,請指點!
- dropdownlist 选值问题
- 水晶报表10中ReportClientDocument.ReportAppServer的意思是什么啊?
- 怎样将下边这样的时间格式化?
- 为什么是这样的呢
- 数组的问题!?
- 高分求救,有谁能告诉我在ASP。NET中可以使用WINDOWSFORM的控件吗?如何使用
- 如何postback后定位
- asp.net怎样让数据库的某字段值向后添加
{
@sum int output
}
asselect @sum=sum(size) from ...
if @sum is null
set @sum=0go
Session("USERID") = "s"
FIRST_ID = Left(Session("USERID"), 1)
Dim sqlConn As New SqlConnection(ConfigurationSettings.AppSettings("ConnStr"))
Dim strSel As String = "select sum(size) as total from mailbox_body_" & FIRST_ID & " where newcheck = '1'"
Dim cmd As SqlCommand = New SqlCommand(strSel, sqlConn)
Dim dreader As SqlDataReader
Dim i As Int16
Try
sqlConn.Open()
dreader = cmd.ExecuteReader()
While dreader.Read()
i = dreader("total")
End While
sqlConn.Close()
Catch ex As Exception
Page.RegisterStartupScript("alert", "<script language='javascript'> alert('网络不通或数据库连接错误') </script>")
Exit Sub
End Try
sqlConn = Nothing
cmd = Nothing
我试过,不行
to hawise(清風)
你能说得详细点吗?
String sqlstring= "select sum(size) as total from mailbox_body_" & FIRST_ID & " where newcheck = '1'"
SqlConnection conn=new SqlConnection(...);
SqlDataAdapter myAdapter=new SqlDataAdapter(sqlstring,conn);
DataSet myDataSet=new DataSet();
myAdapter.Fill(myDataSet,"tablename");
Response.Write(myDataSet.Tables["tablename"].rows[0][total]);我没有时间试,你试一下看看。
SqlConnection conn=new SqlConnection("....");
SqlDataAdapter myAdapter=new SqlDataAdapter(sqlstring,conn);
DataSet myDataSet=new DataSet();
myAdapter.Fill(myDataSet,"mailbox_body_s");
Response.Write(myDataSet.Tables["mailbox_body_s"].Rows[0]["total"]);
方法可以,
但要同时统计三列,该怎么写
to hawise(清風) and all
但要同时统计三列,如size,num,count三列的值,结果分别放入
total,Tnum,Tcount 中
该怎么写