I am working on a program that updates a Database via ASP.NET (C#) using Microsoft Access and OleDb and have the following problem when loading my web form in FireFox:
"The INSERT INTO statement contains the following unknown field name: 'txtCustomerID'. Make sure you have typed the name correctly, and try the operation again."
I dont understand why i am getting this as i have labled 'txtCustomerID' textbox correctly in the webform, has it got to match exacly what the collumn is in the access database? Could it be that my query is not correct?
command.CommandText = command.CommandText = "INSERT INTO Customers (txtCustomerID, txtCompanyName, txtContactTitle, txtAddress, txtCity, txtRegion, txtPostalCode, txtCountry, txtPhone, txtFax) VALUES (@CustomerID, @CompanyName, @ContactTitle, @Address, @City, @Region, @PostalCode, @Country, @Phone, @Fax)";