类别编码 类别名称 财产编码 财产套数 单位01 a 000004 1 套
''''''''''''''''''''''''''''''''''''''''''
合计 1 套
''''''''''''''''''''''''''''''''''''''''
0101 aaa 000005 1 套
'''''''''''''''''''''''''''''''''''''''''
合计 1 套
'''''''''''''''''''''''''''''''''''''''''''''
02 b 000003 1 套
'''''''''''''''''''''''''''''''''''''''''''
02 b 000006 1 套
''''''''''''''''''''''''''''''''''''''''''
合计 2 套
'''''''''''''''''''''''''''''''''''''''''
总计 4
''''''''''''''''''''''''''''''''''''''''''
合计 1 套
''''''''''''''''''''''''''''''''''''''''
0101 aaa 000005 1 套
'''''''''''''''''''''''''''''''''''''''''
合计 1 套
'''''''''''''''''''''''''''''''''''''''''''''
02 b 000003 1 套
'''''''''''''''''''''''''''''''''''''''''''
02 b 000006 1 套
''''''''''''''''''''''''''''''''''''''''''
合计 2 套
'''''''''''''''''''''''''''''''''''''''''
总计 4
http://search.csdn.net/Expert/topic/393/393457.xml?temp=.1814081
SELECT captype.type_code, captype.type_name,capdata.cap_code, capdata.cap_sets, capdata.cap_name, capdata.cap_spec, LTRIM(SUBSTRING(CAST(dbo.capdata.cap_quan AS varchar), 0, CHARINDEX('.', CAST(dbo.capdata.cap_quan AS varchar)))) + RTRIM(dbo.captype.type_unit) AS dd,capdata.ori_curr, capdata.ori_money, capdata.cap_money, capdata.buy_money, capdata.buy_date, capdata.cap_date, capdata.cap_flag, deptment.dept_name, capdata.duty_man, capdata.user_man,capdata.address,capdata.re,附件=case when capadjunct.adju_flag is not null then '有' else '' end ,capimage.id,capdata.cap_id FROM capdata INNER JOIN captype ON capdata.type_id = captype.type_id INNER JOIN deptment ON capdata.dept_id = deptment.dept_id LEFT OUTER JOIN capadjunct ON capdata.cap_id = capadjunct.cap_id left outer join capimage on capdata.cap_id=capimage.cap_id WHERE (capdata.type_id IN ('100744180000000001','100744180000000002','100744180000000018')) AND (capdata.dept_id IN ('100744180000000003','100744180000000004','100744180000000019')) and capdata.
cap_flag in ('不存在','闲置','在用') order by captype.type_code
sqlty="
SELECT captype.type_code, captype.type_name,capdata.cap_code, capdata.cap_sets, capdata.cap_name, capdata.cap_spec, LTRIM(SUBSTRING(CAST(dbo.capdata.cap_quan AS varchar), 0, CHARINDEX('.', CAST(dbo.capdata.cap_quan AS varchar)))) + RTRIM(dbo.captype.type_unit) AS dd,capdata.ori_curr FROM capdata INNER JOIN captype ON capdata.type_id = captype.type_id INNER JOIN deptment ON capdata.dept_id = deptment.dept_id LEFT OUTER JOIN capadjunct ON capdata.cap_id = capadjunct.cap_id left outer join capimage on capdata.cap_id=capimage.cap_id WHERE (capdata.type_id IN ('100744180000000001','100744180000000002','100744180000000018')) AND (capdata.dept_id IN ('100744180000000003','100744180000000004','100744180000000019')) and capdata.
cap_flag in ('不存在','闲置','在用') order by captype.type_code"'就是多个表组合在一起的
sqlcon = New SqlConnection(ConfigurationSettings.AppSettings("Conn"))
adapter = New SqlDataAdapter(sqlty, sqlcon)
我现在把多个表的数据放在DataSet里
Dim data As New DataSet
adapter.Fill(data, "capdata")
现在我想把DataSet当做一个表,然后用"select sum(cap_sets) from " + (表)data + " where type_code=" + s.Trim()"
求出cap_sets字段的总和,(表)data这个应该什么写,请高手指点
dataset应该当作一个数据库
datatable可以当作一个表
如果要用sql语句对他们进行操作,
要用dataview