Tag Archives: SQL Server 2005

How to get directions using Bing Maps Directions module in ASP.NET

Download Source Code Introduction In this post we will see how to calculate route between two places on Bing map in ASP.NET Description We will use Bing Maps V7 SDK to load map and calculate directions between two locations. First we will store latitude and longitude of some cities in the SQL Server database. Then… Read More »

Custom Paging in ASP.NET GridView control with AJAX using ObjectDataSource control

Download source code In this article I will explain how to do custom paging in ASP.NET GridView control with AJAX using ObjectDataSource control Introduction In this article we will see how to enable custom paging in ASP.NET GridView control using ObjectDataSource control. We will also enable AJAX to avoid post back after navigation through paging.… Read More »

Recursive user defined function in SQL Server

Introduction In this post I will explain how write a recursive user defined function in SQL Server Description Recursive function is a function which calls itself for a certain number of times based on some business logic. We will create a simple recursive user defined function for calculating factorial of a number. Factorial of a… Read More »

How to write data of an SQL Server table to an XML file using C#

Introduction In this article I will discuss how to write data of an SQL server table to an XML file using C# Description I have an Employees table in Northwind database with some sample data that we are going to write in an XML file. You can download Northwind and pubs sample databases from here… Read More »

GridView data binding in ASP.NET using WCF service

In this article I will explain how to bind data in a GridView from SQL Server database using a WCF Service Introduction In this article first we will create a WCF service to get data from a SQL Server table. Then we will bind these data in a GridView control. Step 1: Create a new… Read More »

Autosuggest TextBox from database column in Windows Forms

In this article we will see how to create an autosuggest TextBox that will suggest data from a SQL Server database column Introduction In this article we will create a TextBox that will suggest names from a SQL Server database column FirstName. Typing first few characters will show matching names from the FirstName column as… Read More »

How to store Date and Time in separate columns in SQL Server 2005

In this article I will explain how to store Date and Time in SQL Server 2005 using User Defined Type Introduction In SQL Server 2008 four new data types were added. Two of them are Date and Time for storing date and time as separate data types. But if you need to deal with separate… Read More »

How to bind multiple SQL Server tables with a TreeView in a hierarchical order

In this article we will bind three SQL Server tables with a TreeView in a hierarchical order Objective In this article we will populate a TreeView with three tables – Country, State, and City in a hierarchical order. Country is at the top level which contains its states which further contains cities. Final output will… Read More »