September 2005 Entries

Zune Desktop theme for Windows XP
UPDATE: September 29, 2008 This post is relatively old and at that time, this was the only theme available. Currently there is a Zune theme for Windows XP which is pretty cool and gives the Vista Look n Feel. I would recommend not going for any third party "Vista look for XP" since they consume a lot of memory resources as well as result in leakages / spyware. The same can be downloaded from here Ever had a chance to look at the Windows Vista ("Longhorn") Screens? Waiting to explore the rich graphics ......

Posted On Wednesday, September 28, 2005 12:29 PM | Comments (13)

MVP Global Summit - Now Happening !!!
The Microsoft Most Valulable Professionals Summit (MVP Summit) for the year 2005 is happening now !!!MVP Summit is organized every year to provide an opportunity for MVPs to interact with Microsoft Product Groups, High Officials and other top notch people (including Steve Ballmer). Its a great opportunity for sharing and gaining knowledge on Microsoft Products. Its now happening at Redmond, Washington at the corporate headquarters of Microsoft. The Summit would be for 4 days providing ample opportunity ......

Posted On Wednesday, September 28, 2005 6:50 AM | Comments (3)

You may receive the error "This document already has a DocumentElement node." - Part II
In continuation to Part I of this article, we will examine how we can load the XML Fragment returned by the SQL FOR XML query, into a DataSet, to form a Well Formed XML Document.SqlConnection objCon = new SqlConnection("Connection String");SqlCommand objCmd = new SqlCommand("select * from customers for xml auto", objCon);XmlReader xr = null;XmlDocument xDoc = new XmlDocument();DataSet ds = new DataSet();try{objCon.Open();xr = objCmd.ExecuteXmlReader();d... ......

Posted On Monday, September 19, 2005 9:02 AM | Comments (4)

You may receive the error "This document already has a DocumentElement node." - Part III
This article is in continuation with Part I and Part II.In Part II, we examined how we can utilize the DataSet's intelligence to handle XML Format to overcome the "Document Element" issue while reading XML Data from SQL Server using FOR XML queries.We will examine a much more efficient way of handling SQL XML using the SQL XML Managed classes provided with the Microsoft SQL XML Managed Provider (Available for free download from Microsoft).Microsoft SQL XML introduces powerful set of Properties/Methods ......

Posted On Monday, September 19, 2005 9:02 AM | Comments (4)

You may receive the error "This document already has a DocumentElement node." - Part IV
This article is in continuation with Part I, Part II & Part III of the series related to solving the error "This document already has a DocumentElement node." which arises when we try to use XmlReader or an XmlDocument to load the XML Data returned by the FOR XML SQL Query.The FOR XML EXPLICIT is one of the toughest techniques in returning XML Data from SQL Server using FOR XML. But it also has the greatest flexibility in controlling the XML Format that is being returned contrary to the XML Fragment ......

Posted On Monday, September 19, 2005 9:02 AM | Comments (0)

You may receive the error "This document already has a DocumentElement node." while trying to read XML Data retrieved using the FOR XML clause
You may receive the error "This document already has a DocumentElement node." while trying to read XML Data retrieved using the FOR XML clause.SQL Server 2000's FOR XML Clause provides great support in querying SQL Server Data and retrieving it in the form of XML. In other words, you can get an XML representation of the Result Set using the FOR XML Clause.So, if a select statement of select * from customers retrieves results in a sequential way, select * from customers FOR XML AUTO will retrieve ......

Posted On Tuesday, September 13, 2005 9:38 AM | Comments (1)

Performing a Case In-sensitive search in an XML Document
XML, is one of the greatest standards that have been developed and adopted over the recent years for data storing and retrieving. XML Documents can store as much information as required and yet consume very less disk space due to them being flat files. XML has provided a great means of replacement to some extent for Databases.However XML has some restrictions (rather a good one) in it. XML is case sensitive. Man, MAN, man & mAn are all different when it comes to XML.XML tags need to be supplemented ......

Posted On Monday, September 12, 2005 1:17 PM | Comments (15)

Visual Studio 2005 ! The Count Down Begins !! 60 Days to go !!!
Hope by now everyone is aware of the next major release of Microsoft, the Visual Studio 2005 (They have eliminated the term .NET which was there in prior versions i.e Visual Studio .NET 2003, Visual Studio .NET 2002). The official release date is November 7, 2005 launch of Visual Studio 2005, one of the most significant releases in the history of the Developer Division. Visual Studio 2005 leverages on the next version of .NET Framework - 2.0. There has been a lot of Beta Releases, CTPs from which ......

Posted On Thursday, September 8, 2005 9:42 AM | Comments (7)

Tech Fest 2005 - Microsoft User Group, Hyderabad... Its Festival Time for Techies Now !!!
Microsoft User Group, Hyderabad popularly called as MUGH (Formerly DNUG - DotNet User Group, Hyderabad) proudly presents Tech Fest 2005 !!!After the huge success of DevCon 2005, MUGH is back again with Tech Fest an event covering contests on both the new releases from Microsoft - Whidbey & Yukon.The two broad categories are as follows:Code Warriors 2005Code Warriors 2005 is a developer challenge, that enables software developers all over to develop and exhibit their applications using Microsoft ......

Posted On Tuesday, September 6, 2005 11:56 AM | Comments (8)