|
Private Sub Refresh_Layer()
Dim strSch As String
strSch = ""
If Len(Trim(dco_Bld.Text)) > 0 Then
strSch = " And BuildingNo='" + Trim(dco_Bld.BoundText()) + "'"
End If
'设置数据源
Adodc1.ConnectionString = Conn
Adodc1.RecordSource = "SELECT LayerId As 楼层编号,Roomnum As 房间数," _
+ "BuildingNo As 建筑物名称,LayerNo As 具体楼层" + strSch _
+ "Memos As 备注信息 FROM Layer ORDER BY LayerNo"
Adodc1.Refresh
Set DataGrid1.DataSource = Adodc1
DataGrid1.Columns(0).Width = 0 '编号
DataGrid1.Columns(1).Width = 1200 '房间数
DataGrid1.Columns(2).Width = 1200 '建筑物编号
DataGrid1.Columns(3).Width = 1000 '具体搂层
DataGrid1.Columns(4).Width = 1000 '备注信息
End Sub
提示:FROM语句出错 |
|