Set select, insert, update, and delete commands for sqldatasource in ASP. net2.0

Select the products data source and check the asterisk (*) to read all database fields. However, this will only generate the SELECT command. If you still want the insert, update, and delete commands, select advanced and check the two options.

Note that only the selected table in the database can be used with the primary key. Otherwise, the advanced options are gray, if the primary key is not available, the default value of datakeynames is unknown. I used to spend a lot of time on this issue. After dragging the gridview control, I edited the update command in it. Only then did I find that datakeynames is empty and I realized this. I hope it will help you.