Start Updating is not supported by data source sqldatasource1

Updating is not supported by data source sqldatasource1

NET includes data source controls that allow you to work with different types of data sources such as a database, an XML file, or a middle-tier business object.

We have explored the basics and adding paging feature to List View control through my previous articles List View Control in ASP. Like my previous articles on List View control, we will add this feature in 2 scenarios.

Our next step in learning List View Control is to add edit/update/delete/insert feature to the List View control.

In particular, you'll look at the class, provides a single object that you can define declaratively (in your web page) or programmatically (in your code-behind file).

It will manage internally the connection to the data, its selection, and various options concerning its presentation (such as paging and caching) so that all you need to do is tell a UI control what data source to use and everything else is taken care of.

Enables you to use Language-Integrated Query (LINQ) in an ASP.

NET Web page through declarative markup in order to retrieve and modify data from a data object.

Specify the Layout Template, Item Template, Edit Item Template, Insert Item Template that displays the List View similar to the previous section. To make the implementation simple, i have made it as inline query and it is a good practise to have it as SP's.

Thus, we have learnt how to provide edit/update/delete and insert feature for List View Control.

A data source control interacts with the data-bound controls and hides the complex data binding processes.

These are the tools that provide data to the data bound controls and support execution of operations like insertions, deletions, sorting, and updates.

Many data source controls exist for accessing data from SQL Server, from ODBC or OLE DB servers, from XML files, and from business objects.