Delete doesnt work in my gridview

Question

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. ' SelectCommand='SELECT [ScheduleID],[ScheduleDay],[ScheduleMonth],[ScheduleYear],[Schedulehour],[Schedulemin],[ScheduleJob1],[ScheduleJob2] FROM schedule' UpdateCommand ='UPDATE schedule set [scheduleday]=@ScheduleDay,[schedulemonth]=@ScheduleMonth,[scheduleyear]=@ScheduleYear,[schedulehour]=@Schedulehour,[schedulemin]=@Schedulemin,[scheduleJob1]=@ScheduleJob1,[schedulejob2]=@ScheduleJob2 where [scheduleid]=@ScheduleID' DeleteCommand ='DELETE [Schedule] WHERE [ScheduleID]=@ScheduleID'> Thats about it. Don't see it this time. What am I doing wrong ? Kind Regards NETFAN

NETFAN · Answer

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.

Delete doesnt work in my gridview

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)