Gridview not updating on edit
On Click of any of this button, I want to edit the details of that particular row.The Rad Grid View is bound to an Observable Collection.We first of all create a Stored Procedure that gets the Id of an employee as a parameter from the Grid View on whichever row the user clicked. In this event, first we get the datakey value that is the id of an employee of whichever row the user clicked and that id is passed as a parameter to the Stored Procedure. According to the above, in these three operations we use three events of the Grid View for each operation.Point numbers 2 and 3 are performed after point 1 is performed.1.On click of the button, I am calling a Delegate Command to do the action.I am passing the current row as the Command Parameter of that button.You can see the C# code below will give the row number whatever you are editing by New Edit Index property.
In case of the bound field’s we need to check what column it is and need to use index of that cloumn, which is little hard and even in future if we change the column order If you see the Last Template Field part in the above code, I am using the link buttons for edit, update, delete and cancel.
We define a connection in the web.config file and give a name to the connection string.
Now we access this connection string on the page so we can open a connection with the relation database. The first one accesses the connection string and the other is for the SQL connection.
Now we define a method for opening a connection with the relation database and returns a SQL connection object depending on the connection string that is passed as a parameter of the Sql Connection class constructor.
Delete a Record We can delete a record from the database table by clicking on the delete button that is in the Delete column of the Grid View.