We define a connection in the web.config file and give a name to the connection string.
Edit Index; Grid View Row grdvrow = (Grid View Row)grdview1. Within that Grid View is a Template Field that--in edit mode--contains a Repeater that lists all the available roles in my application as checkboxes.
What I want is to be able to update a user's roles based on the selections in those checkboxes.
The Grid View control is a tabular databound control but sometimes it is used like a spreadsheet control. NET 2.0 and is an improved version of the Data Grid control. We can use this to display data from a database and edit, sort and select the data.
Database Table Structure We are using an "EMPLOYEE" table so the "EMPLOYEE" table design is: Design of Grid View We design a Grid View with which we can perform update and delete operations.
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.