如何使用 vb.net 更新 Access 中特定行和列中的值

Question

Private Sub btnUpdateu3_Click(sender As Object, e As EventArgs) Handles btnUpdateu3.Click
cmdInsert.CommandText = "Insert into ecd (first_name, last_name, relationship, phone_number)" + "Values('" + txtefnu3.Text + "','" + txtelnu3.Text + "','" + txterelu3.Text + "', '" + txtecnu3.Text + "')" + "Where student_id('" + txtsidu3.Text + "');"
cmdInsert.CommandType = CommandType.Text
cmdInsert.Connection = cnnOLEDB
cmdInsert.ExecuteNonQuery()
MessageBox.Show("Insertion Successful")
End Sub

Answer 1

似乎您需要更新查询，而不是插入。

Private Sub btnUpdateu3_Click(sender As Object, e As EventArgs) Handles btnUpdateu3.Click
cmdInsert.CommandText = "UPDATE ecd SET first_name = '" + txtefnu3.Text + "', last_name = '" + txtelnu3.Text + "', relationship = '" + txterelu3.Text + "', phone_number = '" + txtecnu3.Text + "' WHERE student_id = '" + txtsidu3.Text + "';"
cmdInsert.CommandType = CommandType.Text
cmdInsert.Connection = cnnOLEDB
cmdInsert.ExecuteNonQuery()
MessageBox.Show("Insertion Successful")
End Sub

这假设有一个非数字学生证(根据您的原件(。如果学生 ID 字段是数字，则不应使用包装单引号(例如'(。