高分求.net里vb语法操作数据库基本语句

来源：百度知道 编辑：UC知道 时间：2024/05/21 14:19:52
要求以根目录下web.mdb为名,main为表名,里面只有两个字段，一个是名为id的自动编号主键,一个是名为about的备注型字段

要求:连接,显示,修改,插入,删除about字段的值.一定要用vb语法
答案被采纳的，再加一到三百分！高分悬赏同志们别小气,难道没人懂asp.net吗
我要连接web.mdb里面名为main的表里的about字段,我要修改,删除,插入记录的,该表有id自动编号字段

Dim Cnn As New Data.OleDb.OleDbConnection
Dim DbAdapter As New Data.OleDb.OleDbDataAdapter
Dim Cmd As New Data.OleDb.OleDbCommand
Dim dsAll As New Data.DataSet

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\webapp\test\web.mdb"
Cmd.Connection = Cnn
End Sub

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
'插入
Cmd.CommandText = "insert into main (about) values ('" + TextBox1.Text + "')"
UpdateTable()
End Sub

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
'修改
Dim ids As Integer
ids = 1
Cmd.CommandText