If the statement does exist in memory, Oracle Database can reuse it and skip the task of parsing and optimizing the statement.
Using bind variables makes the statement reusable with different input values.
The Grid View also lets you perform other tasks very easily, such as paging and sorting your data, but not everything is as straightforward as it seems.
They are: The former event is raised before the current page changes and the later is raised after the page has changed. Write the following code in the Page Index Changing event of the Grid View.To preserve the data between callbacks, I want to get the existing gridview data and add one row to it and then rebind the gridview to reflect the latest addition. It has to get it's information from your datareader or dataset. -Dove Chocolate Wrapper Chroniclemaster1, Founder of So by the time you see your information populated in the datagrid, everything is finished. Earth A Growing History of our Planet, by our Planet, for our Planet. There are many articles and tutorials around that illustrate the use of Grid View control along with the new Data Source Controls.When attached with a Data Source control Grid View performs tasks such as paging, sorting and editing automatically i.e. However, at times you require to bind the Grid View with a Data View or Data Table directly.