通过VB FORM写入各个字段的Access数据库表 [英] Write to Access Database Table in respective fiels Via VB FORM

问题描述

请任何人帮助我，
我正在VS2010中开发一个VB.NET App.
我将表单连接到Access数据库并显示数据.但是我需要将数据写入访问表中的各个字段.

Please anybody help me,
I am Developing one VB.NET App in VS2010.
I connect my Form to Access Database and show the data. But i need to write the data to respective fields in Access Table.

推荐答案

尝试以下链接:

插入，更新，删除和删除带VB.NET 2005的MS Access 2003中的搜索值

要在DataGridView中显示数据:

Try the following link :

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

To display data in DataGridView :

Dim objda = New OleDbDataAdapter
Dim objdataset As DataSet = New DataSet
Dim dv As DataView
objda.SelectCommand = New OleDbCommand
OpenConnection()
objda.SelectCommand.CommandText = "Select * FROM TableName"
objda.Fill(objdataset, "TableName")
dv = New DataView(objdataset.Tables("TableName"))
DataGridView1.DataSource = dv

它将为您提供帮助:)

It will help you :)

您需要在SQL中编写合适的Insert方法.恐怕我的回答有点模糊，因为您的问题确实很模糊.如果您更新有关如何从访问中检索数据并显示数据的问题，那么我可以将答案更新为更具体.

You need to write a suitable Insert method in SQL. I am afraid my answer is a little vague because your question is really vague. If you update your question with how you are retrieving the data from access and showing it, then I can update my answer to be more specific.

这篇关于通过VB FORM写入各个字段的Access数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！