How to update data in windows form application using sql connection without using datasoure

This is my inventory system here i have to insert update delete and search for the data,  insert and search part is working well but delete and update part having issue.

this is the code.

This is the interface. Here i can't use any data source only SQL severer Need help urgently