Dim Con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Music_Sales_Database.mdb;")
Dim Com As OleDbCommand
Dim SaleCode As Integer
Dim MusicID As String
Dim SubTotalPrice As Decimal
Dim Copies1 As Integer
Dim STR1 As String
SaleCode = 1
Com = New OleDbCommand
Com.Connection = Con
For x As Integer = 0 To SalesDataGridView.Rows.Count - 1
MusicID = SalesDataGridView.Rows(x).Cells(0).Value
SubTotalPrice = SalesDataGridView.Rows(x).Cells(5).Value
Copies1 = SalesDataGridView.Rows(x).Cells(3).Value
STR1 = "INSERT INTO Sales(Sales_ID, Sales_Date, Copies, Music_ID, Staff_ID, Total_Price) VALUES (@Sales_ID, @Sales_Date, @Copies, @Music_ID, @Staff_ID, @Total_Price)"
Dim Comm As New OleDbCommand(STR1, Con)
Comm.Parameters.AddWithValue("@Sales_ID", SaleCode)
Comm.Parameters.AddWithValue("@Sales_Date", txtDateAndTime)
Comm.Parameters.AddWithValue("@Copies", Copies1)
Comm.Parameters.AddWithValue("@Music_ID", MusicID)
Comm.Parameters.AddWithValue("@Staff_ID", txtStaff_ID)
Comm.Parameters.AddWithValue("@Total_Price", SubTotalPrice)
'Command.ExecuteNonQuery()
Comm.Dispose()
Next
Connection.Close()
大家好,我的前辈,我不知道为什么没有显示任何错误,并且无法将其保存到 Access 数据库中。
整个代码都在按钮中,我解释了我希望程序如何工作:
1.)我有一个未绑定的datagridview,可以从几个文本框中添加数据。
2.)一个名为“签出”的按钮,该按钮用于将我的datagridview数据传递到Access数据库......这是我面临的问题......有人可以帮助我解决它......
多谢...
我也参考了这个链接,但我对 C# 不太熟悉一次将datagridview的所有数据插入数据库 https://stackoverflow.com/questions/10556556/insert-all-data-of-a-datagridview-to-database-at-once