Animated Charts with FusionCharts and ASP.NET

Visualizing data in form of colorful graphs makes data look interesting and easy to comprehend and if you animate then it's like icing on the cake.

FusionCharts is the name that comes in mind when we talk about cool animated chart and graphs. FusionCharts library has been in market for years and has been very successful in this area. There are many big companies who use their product but along with paid product FusionCharts also provide a free open source version of the library it's known as FusionCharts Free. You can use this library for both personal and commercial use. [More]

Tags: , , ,

ASP.NET | XML

Weather Information from Google Weather using ASP.NET and LINQ to XML

Today, we will take advantage of Google Weather API to retrieve weather information for a given zip code and show it on our ASP.NET page. Google weather (http://www.google.com/ig/api?weather=96715) API return data in XML format and we will parse this data on our page using LINQ to XML and traverse through nodes to retrieve the returned information. This is a very basic example but once we know how to fetch one node information rest all is a piece of cake. [More]

Tags: , , , ,

ASP.NET | LINQ | XML

Reading XML file using jQuery

XML is very commonly used for data transmission purposes. Today we will read XML file and print results on page with the help of jQuery library.

For this demo I am going to use XML file generated from one of the weather API of Google. [More]

Tags: , ,

ASP.NET | jQuery | XML

Import Multiple XML file and parse to tabular data in SQL Server

In this article, we will see as how we can upload the xml file from physical drive and then parse it to tabular data. Our problem statement is say we want to upload the entire xml files that we received in one particular day. [More]

Tags: , , , , , ,

SQL Server | XML

Converting XML document to tabular format in SQL Server

XML has become an easiest mode to exchange and transfer data. There can be a scenario when we have received data in xml format and we want to store in tabular format in one of the table that we have created in SQL Server. Below is how we can go about solving such a problem. [More]

Tags: , , , ,

SQL Server | SQL Tricks | XML

FOR XML EXPLICIT

For XML Explicit is a very complex mode but it allows to present the data in any desirable format we want. It can cause maintenance problem because queries can be very big and any change can be overwhelming. One of the advantages of Explicit mode over others is we can output column values as CDATA. [More]

Tags: , , ,

SQL Server | SQL Tricks | XML

FOR XML RAW in SQL Server

In this article we will go over as how we can retrieve tabular data as XML and some XML basics. We will first go over as how we can retrieve tabular data in XML format. We will use AdventureWorks table for this. [More]

Tags: , ,

SQL Server | XML