Tag Archives: SQL Server

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 »

How to add Pushpins to a Bing Map from database using ASP.NET

Introduction In this article I will explain how to add Pushpins to a Bing map from locations (Latitude/Longitude) stored in a SQL Server database table Description We will use “Bing Maps AJAX Control 7.0 ISDK” to create Bing map. You have to create a key to use Bing map in your applications. You can refer… Read More »

Create a Geographical Chart (Geo Chart) in ASP.NET from database using Google Chart Tools

In this article I will explain how to create a Geographical Chart in ASP.NET from database using Google Chart Tools Download Source Code Introduction In my last article I discussed about creating a simple Pie Chart in ASP.NET using Google Chart API. In this article we will see how we can create a Geographical Chart… 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 »

Data binding in WPF DataGrid control using SQL Server database

In this article I will explain how to display data from a SQL Server database table in a WPF DataGrid control Introduction Displaying data in a grid is a common task in a windows application. In a windows application we use DataGridView control for this task. In WPF we can use DataGrid control for the… Read More »

How to generate report from SQL Server database using Report wizard in ASP.NET

Introduction In this article we will generate a report from SQL Server database using Report wizard and display it in ASP.NET using MicrosoftReportViewer control. Step 1: Create a new ASP.NET Web Application Step 2: Add a new Report Wizard using Right Click on project and Add -> New Item. Click on Add button. Click Next… 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 »