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,995
Messages
2,570,230
Members
46,819
Latest member
masterdaster

Latest Threads

Top