在你确定你的存储过程有返回值的前提下把
Dim dr As SqlDataReader
dr = cmd.ExecuteReader()
If dr.Read() Then
Dim sum As String = dr("RPT_YARN2(olddate,nowdate,sqls)")
Response.Write("sum")
End If
dr.Close()
oh.Close()
————————————————>>>>>>>>替换为
dim adapter as new dataadapter()
adapter.selectcommand = cmd
dim data as dataset
adapter.fill(data)
Dim dr As SqlDataReader
dr = cmd.ExecuteReader()
If dr.Read() Then
Dim sum As String = dr("RPT_YARN2(olddate,nowdate,sqls)")
Response.Write("sum")
End If
dr.Close()
oh.Close()
————————————————>>>>>>>>替换为
dim adapter as new dataadapter()
adapter.selectcommand = cmd
dim data as dataset
adapter.fill(data)
这是什么东西?怎么可以用这样的字符串做字段名呢???如果这个字段名是通过在程序的方法中计算出来的,那么就不应该放在引号中。