Dim cmd As New SQLCommand cmd.C Dim dst As WinForm.DataList = e.Form.Controls("DataList1") Dim day As date = date.today cmd.CommandText = "select * from [H_ZYXX] where 状态 = 3 and 结算日期 = '" & day & "'" dst.DataTable = cmd.ExecuteReader() dst.ColumnList = "住院号|姓名|结算日期|fa piao号|合计|记帐金额|个人缴费金额|收费员|审核员|西药|中成药|中草药|床位费|诊查|X光|B超|心电图|护理|治疗|手术|检验|其他|特需服务" dst.Build() dst.GrandTotal(AggregateEnum.Sum,"总计","合计","记帐金额","个人缴费金额","西药","中成药","中草药","床位费","诊查","X光","B超","心电图","护理","治疗","手术","检验","其他","特需服务")