如何从VB表单更新访问表 [英] How to Update Access Table from VB Form

问题描述

Me.SMSDATA1DBTableAdapter.Fill(Me.SMSToolDBDataSet.SMSDATA1DB)
通过使用数据网格，我可以显示数据.
现在，我需要更新Access表各自的字段.
任何机构都请帮助我.........

Me.SMSDATA1DBTableAdapter.Fill(Me.SMSToolDBDataSet.SMSDATA1DB)
By using Data Grid i display the data.
Now i need to Update the Access table respective of their fields.
Any Body PLEASE help me.........

推荐答案

^ ]

按照此链接.....:)

Insert, Update, Delete & Search Values in MS Access 2003 with VB.NET 2005[^]

Follow This link.....:)

使用更新命令:

Use the Update Command :

Dim cmdUpdate As New OleDbCommand
cmdUpdate.Connection = cnnOLEDB  'Setting connection property of command object
cmdUpdate.CommandText = "UPDATE TableName SET FieldName = '" & txtName.Text & "' WHERE IDFieldName = " & txtID.Text & ";" 
Try
   cmdUpdate.ExecuteNonQuery() 'Executing Update Command
Catch ex as Exception
   MessageBox.Show(ex.Message) 'Error MEssage
End Try

这篇关于如何从VB表单更新访问表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！