Updating gridview rows using sqldatasource Sexy girl web cam
There are also chances where we will have output parameters associated with the Store procedures whose value should be assigned to a page control like Label, etc.Sometimes, there are chances where we require changing the SQL query that is executed against database at runtime for a particular case.The Bind Grid() method is our own function that we will create later on.The method essentially binds the Grid View with a Data View.
To use strored procedure we need to set the “Select Command” property to the stored procedure name and “Select Command Type” proeprty to “Stored Procedure”.
I have created a table called CD_Users to demonstrate the Sql Data Source control usages in this article.
Drag a Sql Data Source control and a Grid View control from the “Data” tab of Visual Studio toolbar.
In Part 2 of this we will see some more advance features like filtering, programmatically accessing the resultsets, etc.
There are many articles and tutorials around that illustrate the use of Grid View control along with the new Data Source Controls.
By default, when we configure the Sql Data Source control with a Databound control it will populate the data on the initial page load.