Select, Add, Update, and Delete Data in a ASP.NET GridView

Question

I am working on a gridview1. This gridview is binded to more then 100 table and displaying data correctly. gridview1 but problem is , i am unable to purform insert ,update ,delete task. how should i revolve this. Note:-Tables doesn't have primery key .some table have rowid(not all). Cant change table structure at any cost. eagerly waitng for the response. Thanks in advance

Mohsin Arif · Answer

hi here is also solution that you dont need to disturb the table structures. just add ROW number using query and it will help out to delete and update the record suppose you have Name, age etc then you add one your own column of ROW number which would be give you the row number either you can add with some prefix or not but it make all record unique and you can easily perform any action.

Gajendra Jangid · Answer

check below links: https://www.youtube.com/watch?v=vuoJeQ4L3WI

Amit Kumar · Answer

Hi, Follow the below links. You have to manage it because u have the project you know better compare to anyone. For better help you can follow below links. https://www.c-sharpcorner.com/UploadFile/009464/make-edit-update-and-delete-operation-in-gridview-in-Asp-Net/ https://www.c-sharpcorner.com/uploadfile/raj1979/select-add-update-and-delete-data-in-a-Asp-Net-gridview-control/ https://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx

Nitish Kumar Mishra · Answer

Hi Rupesh, Thanks for the reply. 1. to distingwish data in each table i am using rowid and unique key 2 i want to update gridview which have data between the range of 1 to 1000 or above . not 100 records. with 1 gridview binding more then 100 table on dropdown selectindex change.

Rupesh Kahane · Answer

Hi I have couple of questions 1) How you are distingwish the data in each table. Their must have some uniquesness so you have tell us the what combinations you are considering while Insert / Update / delete. So we can guide you. 2) Let us know are u going to update gridview1 which contains more than 100 records righ ? Thanks