DataGrid显示数据问题!
HZCNC 2003-08-18 04:13:04
rs.Open "SELECT a,b,c From t_img Where a like '%" & KeyWord.Text & "%' or b like '%" & KeyWord & "%'", cnt, adOpenKeyset, adLockReadOnly
Set result.DataSource = rs
当数据源指定为SQL Server2000数据库时,没有问题!
(cnt.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & txtUsername & " ;PASSWORD = " & txtPassword & " ;Initial Catalog=" & txtdatabaseImg & ";Data Source=" & txtserver
)
但指定为ACCESS数据库时不能显示!
(cnt.Open "data source=abc.mdb;provider =microsoft.jet.oledb.4.0;")
但是这时我用msgbox rs!a测试时有数据返回!
在线等……