Category Archives: SQL Server

Implementing Paging in SQL Server 2005 Stored Procedures

Normally for implementing Paging in Grid View, we enable the Paging property in GridView and will write code in the PageIndex Changed event. But the problem with this approach is it will fetch all the data from Database for Paging, … Continue reading

Posted in .Net, SQL Server | Tagged , , , | Leave a comment

Enumerating Instances of SQL Server using C#

One of the project I am worked, I had to enumerate SQL Server instances of the network for creating dynamic connection string. Here is a code snippet which will retrieve all the SQL Server instance in a network using C# … Continue reading

Posted in .Net, ASP.Net, SQL Server | Tagged , , , , | Leave a comment

Implementing Custom Paging in DataRepeater using C# and SQL Server

Normally DataRepeater doesn’t have a paging feature; and you can implement it using LINQ, if you are using .Net 3.5. Here is an implementation which is using SQL Server 2005 feature ROW_NUMBER(). You can get more information about ROW_NUMBER() from … Continue reading

Posted in .Net, .Net 3.0 / 3.5, ASP.Net, SQL Server, Visual Studio | Tagged , , , , , | Leave a comment

TreeView Population without recursive function

If you want to display hierarchical data in a Treeview normally we are using recursion. I was looking for code which helps to avoid recursion using a Single query. But that code was using VB.Net and it was using a … Continue reading

Posted in .Net, .Net 3.0 / 3.5, SQL Server, Visual Studio, Windows Forms | Tagged , , , , , , , | 2 Comments

How to Store and Retrieve files from SQL Server Database

The forum I joined recently got lot of queries like How to Save Images in the Database, How to save files in SQL Server, How read files from Database etc. So I thought of writing a post regarding this. Even … Continue reading

Posted in .Net, .Net 3.0 / 3.5, ASP.Net, SQL Server, Visual Studio, Windows Forms, WPF | Tagged , , , , , , | 2 Comments