Problem with inserting data into an Access DB
I have a linkbutton with the CommandName as Insert in the InsertTemplate of a form view. Using an AccessDataSource control with an InsertCommand sql statement with parameters it only adds new records if I set a default value to a parameter and only that default value of the parameter will be added in the appropriate field of the table. If none of my parameters have a default value in the parameters element of the datasource control then no record gets added to the table, nothing happens. I've checked the name of my textboxes, checkboxes, dropdowns, etc... to make sure they are spelled correctly and that no other controls from the other form templates have the same name and I still get the same results.