Video: CREATE AN XML DATA SOURCE IN EXPRESSION WEB

Presenter:Todd Miranda

Dynamic web sites require data as input. However, the data does not always have to come from a database. Data is often available in the form of XML files. This video demonstrates how to create a Data Source from an XML file in Expression Web.

The following text is a software generated transcript of the video. Click on a minute link to jump to a location within the video



Minute 0

The latest on Miranda in this video to show you how to create an XML data source and Marshall s expression web is begin by creating a new website will create just a single place website and through okay about a fall we get our default html file soap let s have an ASP net file to our project and will call this exile there sort of have an XML data source is what they wish to create that we grew our data source library pain and we can do local XML files we can choose edit XML file or we can go to file choose import import file a writ at a file that we go to


Minute 1

Expo fall are created for this demo called members of XML and US won t bring that into our web project should I see that over here we ve got one XML file sure enough we hover over the XML file we sued a couple of options we ll are the properties of that file which is just so the file properties and its location organized to show data is a view of the actual date is in the XML file for him to go look at all the records that are in that figure XML file with you see the structure of the XML file Easily there okay we ll ask you once see the data in an webpage for less double click on our ASP net page to open it up and here s what s great about using XML in Marshall s expression when we will show the Davidson members of XML to the way to do that is rare click in order drag and drop at writing here in our form 10 and there were no


Minute 2

Notice of ASP net XML controls created for us and our members XML file was loaded images say the data right here our webpage one thing to note though is that by default and excess LT transform files created for us as well and this is how the data is transformed from its XML format here into a formidably can view on the page here so that we haven t written any code women do anything except write effectively destroyed or XML file on tour form so let s say this is the access asked us to save our access to the file and looks right click or a figure that they can do preview in browser and sure enough there we are without XML data writer webpage ever had right what love can listen this a step further if we take a look ourASP net makes the


Minute 3

Trolls created for us appear in the top right hand corner of that control in the context menu we can extend that a few things that we can do so let s take a look at silly options are available to us we can add filters to our data we can still worked our data if one do that so we can go in here disorderly can say we will also work body is active so add that since the sending and do okay and obviously you can see there that a we have sordid power data in our Excel file we can edit the columns we can select which columns we want to keep this display were displayed all columns right now so that s fun we going to change layout is really nice in case layout dialog box with a few tabs available to us we ve got a good capability showing header and footer and a column summary


Minute 4

We can go into layout we change the layout was ordered to what you specify the source of our ex SLT transform and we can look at how we are processing the excess healthy in this case we use the ASP net XML control listen go through layout of the select day different layout to square data from a select this layout choose okay and we ll miss his indicates if you change the view style any custom formatting or Web part connections will be removed and is because was effectively happening is that access all transformed being completely rewritten to any modifications you would make to that or can be lost if this e mail we got a different way of viewing our data still sordid but now displayed in a more look different to your format selects to a safe and yes we want save the changes would make to


Minute 5

To sell file with right click a new preview in browser and our data is laid out in the new way that we specify pricing seen how easy it is to create an ASP net page drag or XML file onto our XML plays really use that as an XML data source for data field to lay that out if we can come in here with you completely style our data using accessibility and CSS files if one do that with one of the things I want to show you biggest this is where things have really really nice really takes the XML data source to the next level in expression when obviously were used to ASP net pages are a more dynamic page soon got capability to server side processing and more dynamic processing using an ASP net page but what


Minute 6

Our host that is hosting our webpage when for Web server does not have the capability to run server side ASP net pages well that s our problem was of a poor default html file is a standard HTML file is no ASP net no server processing for this file however were to take younger drag our XML file onto her web based surface and we see that we can view the XML file in a standard HTML page as well so we can go in here the same thing we have done before we can do to change layout would you choose this same tender laid out and we had chosen this it laid out their so let s say this


Minute 7

And once I does and that we were right click or HTML file and a preview in browser and noticed that it foretells a spade a spade a starter runs on some dynamic scripts where click here to allow the content and yes to allow the active content and here we or viewing or XML data in a standard HTML page with no dynamic server side processing and we still have the capability to do that really likes that we can use our XML data source and not only an ASP net page but also in an HTML page

Click here to go to original video page