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.
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.
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.
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.
The visitors to a web site can typically be divided into two groups: the users and the administrators. In data driven web sites, users are normally allowed to view data and administrators are allowed to add, edit or delete data. In this tutorial I will show you how you can create an editable GridView control for administrators to modify database records directly into the GridView control.
If you are a regular visitor of blogs, contents publishing or news related websites you must have noticed a small RSS or XML icon somewhere on the page. This is very useful technique which content presenters or authors used fairly regularly on blogs to publish their articles or tutorials to other websites who subscribed to their feeds. In this article I will show you how to generate RSS feed for your ASP.NET websites.
This tutorial will show you how to use CheckBox inside GridView and how to handle its events to update database records based on its Checked state.
Sending emails from ASP.NET 2.0 application is made very simply using MailMessage and SmtpClient classes available in System.Net.Mail namespace in .NET Framework. Sometimes SMTP server required authentication information of email client to send emails. In the following tutorial, I will show you how you can authenticate smtp client when sending emails in ASP.NET 2.0.
.NET Framework namespace System.Net.Mail contains many classes developers can use to send all types of emails in ASP.NET 2.0. In the following tutorial I will show you how you can send a simple plain text email in ASP.NET 2.0.
Calendar control is one of the most exciting controls in ASP.NET. It has many properties to customize the appearance of the control according to your application requirements. It does not support data binding, but it is still possible to customize the contents of this control by using some of its events. In the following tutorial, I will show you how you can create one simple online event organizer using its DayRender Event.