For example if the column name is Name its corresponding parameter name will be @Name.
Once this is done the Sql Data Source will automatically pick values from respective Text Boxes inside the Grid View row to be edited.
Each data source control wraps a particular data provider-relational databases, XML documents, or custom classes and helps in: There are many data source controls available in ASP.
NET for accessing data from SQL Server, from ODBC or OLE DB servers, from XML files, and from business objects.
Contents Core Services Web.config File Refactoring Extensible Output Caching Auto-Start Web Applications Permanently Redirecting a Page Shrinking Session State Expanding the Range of Allowable URLs Extensible Request Validation Object Caching and Object Caching Extensibility Extensible HTML, URL, and HTTP Header Encoding Performance Monitoring for Individual Applications in a Single Worker Process Multi-Targeting Ajaxj Query Included with Web Forms and MVCContent Delivery Network Support Script Manager Explicit Scripts Web Forms Setting Meta Tags with the Page. Meta Description Properties Enabling View State for Individual Controls Changes to Browser Capabilities Routing in ASP.
NET 4Setting Client IDs Persisting Row Selection in Data Controls ASP.
When the Button is clicked, the Insert function of the Sql Data Source is executed which then inserts the records to the database and binds the Grid View again to display the newly inserted record.Connection to data is made through two important properties Connection String and Provider Name.The following code snippet provides the basic syntax of the control: Configuring various data operations on the underlying data depends upon the various properties (property groups) of the data source control.NET and really don't take these kinds of things for granted.Books and hyperlinks are reasonable answers or additions to your answer.The Data Source View class serves as the base class for all data source view classes, which define the capabilities of data source controls.