Hello ,
I am stumped by this Error in ASP .NET when trying to insert a record thru DetailsView web control :
below is my details view , the object data source its connected thru and the custom class that i wrote which simply calls down the table adapters insert method. The tabladapter's insert method works just fine when i try it from the designer but is always giving this error from the page :(. I m using Northwind db for this application, can anyone please tell me wats causing this error ?
Custom class ( for products table in Northwind db) :
[System.ComponentModel.
public
{
}
NorthwindTableAdapters.
<
Insert command text in tableadapter :
INSERT INTO Products (ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued)VALUES (@ProductName,@SupplierID,@CategoryID,@QuantityPerUnit,@UnitPrice,@UnitsInStock,@UnitsOnOrder,@ReorderLevel,@Discontinued)