[moh61]

اضفت الكود بها الطريقة ... ومازبطت معي


تطلع لي رسالة : System.Data.OleDb.OleDbException: 'Data type mismatch in criteria expression.'

PHP كود :

Dim connLoadCustomerData As New OleDbConnection(ConfigurationManager.ConnectionStrings("LAUNDRY_SYSTEM.My.MySettings.Laundry_DatabaseConnectionString").ConnectionString)
                    Dim query As String = "SELECT Customers.productA,Customers.itemnumber,Customers.price,Customers.Total,Customers.billnumber,Customers.dates,Tailor.T1,Tailor.T2,Tailor.T3,Tailor.T4,Tailor.T5 FROM Customers inner join Tailor on Customers.ID=Tailor.ID WHERE Customers.billnumber='" & INVOICENUMBER & "' OR Tailor.billnumber='" & INVOICENUMBER & "'"
                    Using Cmd As New OleDbCommand(query, connLoadCustomerData)
                        Cmd.CommandType = CommandType.Text
                        Using sda As New OleDbDataAdapter(Cmd)
                            Using dt As New DataTable()
                                sda.Fill(dt)
                                CustomersDataGridView.DataSource = dt
                            End Using
                        End Using
                    End Using