98系统,access200数据库
用adodc1.find()函数只能查询到满足条件的一条纪录,所以用sql语句实现
我想检索到数据库中的满足查询条件的所有纪录,代码如下,但是不能实现,请帮忙!Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=E:\数据库例子\db1.mdb;Persist Security Info=True"
Adodc1.Recordset.Close
Adodc1.RecordSource = "select * from person where name='" + Text3.Text + "'"
Adodc1.Recordset.Open
Adodc1.Refresh
DataGrid1.Refresh
用adodc1.find()函数只能查询到满足条件的一条纪录,所以用sql语句实现
我想检索到数据库中的满足查询条件的所有纪录,代码如下,但是不能实现,请帮忙!Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=E:\数据库例子\db1.mdb;Persist Security Info=True"
Adodc1.Recordset.Close
Adodc1.RecordSource = "select * from person where name='" + Text3.Text + "'"
Adodc1.Recordset.Open
Adodc1.Refresh
DataGrid1.Refresh
Adodc1.Recordset.CursorType=adOpenStatic
Adodc1.Recordset.Open
Dim rs As Recordset Set conn = New Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Password="";Data Source=E:\数据库例子\db1.mdb;Persist Security Info=True" Set rs = New Recordset
rs.CursorLocation = adUseClient
rs.Open "select * from person where name='" & Text3 & "'", conn, adOpenStatic, adLockOptimistic Set DataGrid1.DataSource=rs
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = "SELECT * FROM TableName"
Adodc1.Refresh
DataGrid1.Refresh