How to trace AccessDataSource INSERT and UPDATE errors?

D

DC

I have an AccessDataSource with defined InsertCommand and UpdateCommand
and linked to a Details View. When I run the commands Im getting an

[OleDbException (0x80040e10): No value given for one or more required
parameters.]

for both UPDATE and INSERT, when I stop them executing and render

Response.Write(DetailsSource.InsertCommand)

or

Response.Write(DetailsSource.UpdateCommand)

all I get is

InsertCommand="INSERT INTO [user_table] ([ID], [ImageName], [Title],
[ForeName], [SurName], [PhoneNo], [RoomNo], (e-mail address removed)
 

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top