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.