Updating sql using gridview control
Here is one of the sample methods that gets SQL Server instances asynchronously.After Begin Invoke(), the user is free to perform any task. This is how you can invoke a method asynchronously by using a delegate.I tried to bind a temporary datatable object to Data Grid View and then update the main table, but I was not able to do so.I used the adapter's Fill() method, which takes the starting record and number of records as input parameters with dataset. Use grids to display data and to enable users to enter information.Unlike an edit control, grid controls can show multiple data items and multiple table rows at once.
This let me allow sorting and, in case you do not want to show any columns, you can do it here.I use this feature to get all tables from the selected database.Delegates are the best practices to design the async architectures because most things are handled internally by CLR and you do not have to bother much about them.A grid can either be a browse grid or an update grid.
You can use a browse grid for viewing only, and you cannot select individual cells.
This new thread will not be able to access the controls on the parent thread.