我用adodb连接的数据库,怎么样执行删除,修改和添加操作啊?我初学者~~!
Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim connstr As String
Dim sql As String
Private Sub Form_Load()
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=user1;pwd=user1;Initial Catalog=student;Data Source=JINANSSE"
conn.Open connstr
sql = "select * from student"
rs.Open sql, conn, adOpenDynamic, adLockPessimistic
If Not (rs.EOF And rs.BOF) Then
Text1.Text = rs("sno")
Text2.Text = rs("sname")
Else
ab = MsgBox("数据库错误")
End If
End Sub
这是我连接数据库的语言。
以后怎么写添加删除和修改数据的代码啊?~~~~求了