Row editing and updating in gridview in asp net herpesdatingchicago com
you can see VT_ACl Report Table design In the below HTML Markup I have a simple ASP. First column containing the Check Box, second column containing a Label for display ID and Access Path of the folder respectively and the third column containing a Label and Drop Down List for display and edit status of the folder respectively. You would be better off if you create another index on ACLId and include column Status in it since that will really speed up the lookup in UPDATE statement.Here I am using Grid View with paging to display the data, and the data is about millions of rows. In this T-SQL, updates are happening in batches of 1000 records rather than updating the whole data set.
First, we don’t really need the Id column to be displayed, so go ahead and delete the Bound Field with Data Field=”Id” from the columns. If you press the Link Button you will see that the “Name” and “Sort Order” columns will change to Text Box controls, waiting for new values.
In this article however, I'll show you how a Grid View control can be used to update (edit), delete and insert data in a remote SQL Server table. Attach the Grid View with the Sql Data Source control, the way we have shown the link above.