Inserting, Updating, Deleting and Paging records using ListView controls

ListView control is a new control added into ASP.NET 3.5. It enables you to display data in a format specified by you using templates and styles. It is useful for data in any repeating structure just like DataList and Repeater controls. However, unlike those controls ListView control enable you to edit, insert, delete, sort, paginate data without any extra effort.

Download

 Download source code for Inserting, Updating, Deleting and Paging records using ListView controls

In this article, I am going to explain a basic way to work with ListView control. After going through this article, you will be able to add, edit, and delete records using ListView control. In this article I am going to use LinqDataSource (Learn how to work with LinqDataSource control in details http://www.dotnetfunda.com/articles/article39.aspx ) as the data source of the ListView.

I assume that you have created LINQ to SQL classes by going through http://www.dotnetfunda.com/articles/article39.aspx article. Now let’s start working with ListView control.



First create a new .aspx page and go to design view. Go to Data tab of the Toolbox and drag ListView control to your page. Now again go to the Data tab and drag LinqDataSource control to the page. Now configure the LinqDataSource control as described in http://dotnetfunda.com/tutorials/tutorial39.aspx article. Make sure that you have selected Enable Delete, Enable Insert and Enable Update checkbox from the smart tag of the LinqDataSource control as displayed in the picture below.



Now open the smart tag of the ListView control and choose the Data Source as the LinqDataSource as displayed in the picture below.


Now click on Configure ListView … from the smart tag of the Listview. Select Tiled from Layout, Professional from Style and Enable Editing, Enable Inserting, Enable Deleting and Enable Paging from the Options as displayed in the picture below. In the Enable Paging dropdown you may select Next/Previous pager or Numeric pager.



Now Save your files and press F5 to run. You should see an Insert form in your browsers. Just enter few records, try editing, deleting records. Once the number of records will exceed the PageSize of the DataPagers (that will be automatically inserted into ListView when you will select Enable Paging from the Configure ListView dialogue box) First, Previous, Next and Last button at the bottom will be enabled automatically.



You should see ListView something like above picture in your browser provided you have inserted the same records as I do :).

Hope you enjoyed playing with ListView and LinqDataSource control. Do let me know if you have any comments or suggestions. Thanks and Happy Coding !!!

If you like this article, subscribe to our RSS Feed. You can also subscribe via email to our Interview Questions, Codes and Forums section.