(Daniel Zambonini) Ten to midnight — it’s your partner’s birthday tomorrow, and you’ve forgotten their gift! Suddenly, a thought comes to mind: she’s always wanted to see a musical in the big city. “Barry,” you say, for that is the name of your web agent, “buy two tickets for Cats in London for tom

(David Clark) The Command objects in ADO.NET (such as OleDbCommand and SqlCommand) are a central aspect of the .NET database access strategy. When used properly, they provide excellent performance and security.

(Jeff Ryan) XML has become the common format for passing data between components residing on different platforms. With the move to XML-based services, developers often find themselves converting various data structures to and from XML. Arguably, the most prevalent form of persisting data is in relat

(Michael Rys) In Microsoft SQL Server 2000, we introduced the FOR XML clause to the SELECT statement. This clause provides the ability to aggregate the relational rowset returned by the SELECT statement into XML. FOR XML on the server supports three modes—RAW, AUTO, and EXPLICIT—that provide differe

(Kevin Ruse) While certainly not a full-blown XML editor, Dreamweaver MX 2004 includes a fair amount of support for XML. This latest release eases the web designers’ transition into the area of structured markup. Many web designers using Dreamweaver rarely view their code, preferring instead to stay

(Dinesh Asanka) Recently I got Microsoft Office Professional Edition 2003 Installed. I found a new tool which was not in the previous versions of MS Office. Curiosity makes me want to get more information on this. Still I am learning and I would like to share my little knowledge with you all from wh

A few years back, on a momentary down cycle between projects, I posted a little article about something I’d had to do at the time… which was to create a set of linked listboxes where, when the visitor made a selection from the first one, the contents of the other one automatically changed to match

Is there anyway I could return an XML with a SUM/GROUP BY clause in the select?!? This is actually fairly simple to implement. For this example I will use the pubs database. The first step is to create the query you want to use. For our example we will count how many titles each author has.

Think about all of the information that you access on the Web on a day-to-day basis; news headlines, search results, “What’s New”, job vacancies, and so forth. A large amount of this content can be thought of as a list; although it probably isn’t in HTML elements, the information is list-orient

(Marco Nanni) This article examines an example of multiple binary file upload for Web applications using Extensible Markup Language (XML) technology, without the typical limitation of traditional file upload processing. It describes how to use Microsoft XML Parser 3.0 (MSXML) and ActiveX Data Object