编写access数据库增加,删除,变更,查询,代码
时间: 2024-03-28 20:41:27 浏览: 20
以下是使用VB.NET编写的Access数据库增加、删除、变更和查询的示例代码:
1. 建立数据库连接:
```
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;")
conn.Open()
```
2. 增加数据:
```
Dim cmd As New OleDbCommand("INSERT INTO mytable (name, age) VALUES ('John', 30)", conn)
cmd.ExecuteNonQuery()
```
3. 删除数据:
```
Dim cmd As New OleDbCommand("DELETE FROM mytable WHERE id = 1", conn)
cmd.ExecuteNonQuery()
```
4. 变更数据:
```
Dim cmd As New OleDbCommand("UPDATE mytable SET name = 'Mike' WHERE id = 2", conn)
cmd.ExecuteNonQuery()
```
5. 查询数据:
```
Dim cmd As New OleDbCommand("SELECT * FROM mytable", conn)
Dim reader As OleDbDataReader = cmd.ExecuteReader()
While reader.Read()
Console.WriteLine("Name: " & reader("name") & ", Age: " & reader("age"))
End While
reader.Close()
```
注意:以上代码仅供参考,具体实现需要根据实际情况进行调整。另外,也可以使用其他编程语言(如C#)来编写Access数据库的增删改查代码。