Comments by wire_jp (Top 2 by date)

wire_jp 19-Oct-19 9:41am View

@Tadit Dash: I want to insert into the column called Inventory in the dbo.Store table.

wire_jp 19-Feb-19 17:51pm View

Hello,

The first error is shown below:

[Code]
exception thrown 'system.invalidoperationexception' in system.data.dll (the SelectCommand property has not been initilalized before calling Fill vba.net [/code]

This first error occurred with this section of vba.net code: -
[Code]
Dim MySqldaOrders As New MySqlDataAdapter
Dim OrdersBindingSource As New BindingSource
Try
con.Open()
Dim queryOrders As String = "select * from database.Orders"
cmd = New MySqlCommand(queryOrders, con)
MySqldaOrders.Fill(dtOrders)[/code]

The second error below: -

[Code]
System.InvalidOperationException: 'Update unable to find TableMapping['Orders'] or DataTable 'Orders'.'[/code]

and this second error message occurred at this line of code:-
[Code]
Me.daOrders.Update(dsOrders, "Orders")[/code]