Dim mycom As New ADODB.Command
Dim f As ADODB.Field
MyCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
" Data Source=" & App.Path & _
"\BaoBao.mdb;Persist Security Info=False"
MyCon.Open
strsql = "select * from bbao"
Set mycom.ActiveConnection = MyCon
mycom.CommandText = strsql
Set MyRs = mycom.Execute
if myrs.recordcount>0 then
MyRs.MoveFirst
Show
Do While Not MyRs.EOF
lblWan(MyRs.Fields("num")).Caption = MyRs.Fields("name")
Dim mycom As New ADODB.Command
Dim f As ADODB.Field
MyCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
" Data Source=" & App.Path & _
"\BaoBao.mdb;Persist Security Info=False"
MyCon.Open
strsql = "select * from bbao"
Set mycom.ActiveConnection = MyCon
mycom.CommandText = strsql
Set MyRs = mycom.Execute
MyRs.MoveFirst
Show
Do While Not MyRs.EOF
lblWan(MyRs.Fields("num")).Caption = MyRs.Fields("name")
先判断是否存在
connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "你的数据库.mdb"
adodc1.connectstring=connectstring
sql = select * from zl where no = '" + text1.text + "'"
adodc1.RecordSource= sql
'判断是否存在
if not adodc1.recordset.eof and not adodc1.recordset.bof then
adodc1.recordset.fileds("name")=text1.text
else
adodc1.recordset.addnew
……
adodc1.recordset.updata
end if