请大家帮我看看为什么不能显示????????
先连接数据库
temcon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\tem.mdb;Mode=Share Deny Read|Share Deny Write;Jet OLEDB:Database Password=123;"
然后
mysql = "select repairno as 维修号,OwnerName as 所有者,OwnerTelNo as 联系电话,LogNo as 车牌,DeliveredDate as 交车日 from dms_rt_contact where DeliveredDate='" & Format(ytoday - 3, "YYYYMMDD") & "' and ((left(OwnerTelNo,2)='13') or (left(OwnerTelNo,3)='013'))"
rsdms.Open mysql, temcon, adOpenKeyset, adLockReadOnly
AA = rsdms.RecordCount
Set DataGrid1.DataSource = rsdms
其中 AA 已经返回15 了 也就是查询有结果啊
但为什么DATAGRID1没有显示东西呢??
我是新手 大家多多帮忙啊!!