Saving images in database using ASP.NET FileUpload Control

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.

Saving images in database using ASP.NET FileUpload Control

Read Full Tutorial

Paging Repeater Control using PagedDataSource

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.

Paging Repeater Control using PagedDataSource

Read Full Tutorial

Enumerate SQL Server database Instances using ADO.NET

How many times you created a .NET application in which you need to know about all of the database systems on your company’s network? May be you need to create an application for database administrator of your SQL Server database so that he can see a list of all the SQL Server databases installed in the company. In this small tutorial I will show you how you can obtain the list of all SQL Server database instances.

Enumerate SQL Server database Instances using ADO.NET

Read Full Tutorial

Editing Data using ASP.NET GridView Control

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.

Editing Data using ASP.NET GridView Control

Read Full Tutorial