Delete doesnt work in my gridview

Hi, Again me. Now I have problem with the delete of an item in the gridview. It doesnt work. Hope this time somebody can help. Thats about it. Don't see it this time. What am I doing wrong ? Kind Regards NETFAN

I cant believe this sh*t :D:D I found it. But it is string the OldvalueId you give for the command to know which record to update or delete has to preceed "original_" for deleting a record but for updating a record it is not necessary. Is this a bug or am I getting it wrong here. DeleteCommand ="DELETE [Schedule] WHERE [ScheduleID]=@original_ScheduleID"> this works UpdateCommand ="UPDATE schedule set [scheduleday]=@ScheduleDay,[schedulemonth]=@ScheduleMonth,[scheduleyear]=@ScheduleYear,[schedulehour]=@Schedulehour,[schedulemin]=@Schedulemin,[scheduleJob1]=@ScheduleJob1,[schedulejob2]=@ScheduleJob2 where [scheduleid]=@ScheduleID" and this works too. Even though it is different in giving the ID.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

NETFAN21y ago
I cant believe this sh*t :D:D I found it. But it is string the OldvalueId you give for the command to know which record to update or delete has to preceed "original_" for deleting a record but for updating a record it is not necessary. Is this a bug or am I getting it wrong here. DeleteCommand ="DELETE [Schedule] WHERE [ScheduleID]=@original_ScheduleID"> this works UpdateCommand ="UPDATE schedule set [scheduleday]=@ScheduleDay,[schedulemonth]=@ScheduleMonth,[scheduleyear]=@ScheduleYear,[schedulehour]=@Schedulehour,[schedulemin]=@Schedulemin,[scheduleJob1]=@ScheduleJob1,[schedulejob2]=@ScheduleJob2 where [scheduleid]=@ScheduleID" and this works too. Even though it is different in giving the ID.