ASP.NET Tutorials

ASP.NET

Displaying Total in Footer of GridView

Posted by Waqas Anwar on 04 Jun 2009 - Views Count: 54910

During my training career, I have been asked one common question several times that how we can calculate summary totals inside GridView control and how we can show it at the footer of GridView control. So I have decided to write a tutorial on this topic. In this tutorial I will show you how you can calculate and display totals not only in GridView footer but also on any control outside GridView control.

ASP.NET

Formatting GridView output based on Data

Posted by Waqas Anwar on 04 Jun 2009 - Views Count: 13115

ASP.NET GridView control is the most commonly used control for displaying data on the web page. If you want to display database records as HTML table “as is”, it is very easy to accomplish using GridView. Sometimes you want to customize the HTML output of the GridView and want to display data differently based on its value. In this tutorial I will show you how you can call custom formatting functions inside GridView to customize GridView control.

ASP.NET

Deleting multiple Rows in GridView using Checkbox

Posted by Waqas Anwar on 03 Jun 2009 - Views Count: 36157

In one of my other article “Using Checkbox in ASP.NET GridView Control”, I have shown you how you can update the row status in database using checkboxes in GridView. There are situations when you want to provide checkboxes in GridView for deleting multiple database records similar to Hotmail or Yahoo inboxes. GridView control allows you to delete only a single record at a time but in this tutorial I will show you how you can implement multiple records deletion scenario in GridView control.

ASP.NET

Export ASP.NET GridView to Excel

Posted by Waqas Anwar on 01 Jun 2009 - Views Count: 8455

Many developers use GridView control to display web reports in their ASP.NET websites. GridView control render data in a tabular form just like HTML tables but it lack the functionality of exporting its contents to any other format such as Excel of PDF file. It is very common requirements of many clients to export web report data to Excel file so that they can perform some analysis using Excel built in features. In this Tutorial I will show you how to export GridView control as Excel File.

ASP.NET

Display Microsoft Excel File in ASP.NET GridView

Posted by Waqas Anwar on 30 May 2009 - Views Count: 14324

Microsoft Excel is still very powerful and widely used tool in almost all the companies. Many people use it extensively to store and analyze tabular data without learning a relational database management system such as SQL Server or Oracle. If you are creating ASP.NET website, there are chances that the data is made available to you in an Excel file and reading and displaying Excel data in ASP.NET page can make your applications more powerful for analysis. In this tutorial I will show you how to read Excel file and displaying data in ASP.NET GridView control.

ASP.NET

Display images in DataList from Database

Posted by Waqas Anwar on 01 May 2009 - Views Count: 26088

In one of my previous article I have shown you how you can save images in database as binary data using File Upload control. I have received many requests to write an article on displaying binary images from the database in a data bound control such as DataList or GridView. In this tutorial I will show you how you can achieve this with only few lines of code.

ASP.NET

Saving images in database using ASP.NET FileUpload Control

Posted by Waqas Anwar on 29 Apr 2009 - Views Count: 25996

Saving and displaying images in database tables is a common requirement in ASP.NET projects. There are two ways to store images in database either you store image URLs in database as normal string or you store image as binary data. In this tutorial I will show you how you can upload and save images directly in SQL Server database table as binary data.

ASP.NET

Paging Repeater Control using PagedDataSource

Posted by Waqas Anwar on 22 Apr 2009 - Views Count: 15075

Paging large database result sets is very important and common feature in modern websites. For ASP.NET developers, Microsoft has build paging functionality into the GridView control by default and developers just have to set some simple properties true and that’s all they need to have paging in their websites. Many developers prefer Repeater or DataList control over GridView due to its large overhead. In this Tutorial, I will show you how you can do paging using light weight ASP.NET Repeater control and PagedDataSource class.