Code Simplified – Viral Sarvaiya

Code Simplified – Viral Sarvaiya, Web Developer Friends, dot net Developer, Sql Server Developer

Posts Tagged ‘XML’

Read XML in Silverlight

Posted by Viral Sarvaiya on August 25, 2010


XML is an important medium in the world of Silverlight especially where Web Services are involved.  The .NET 3.5 that comes with Silverlight omits some of the core XML objects that you will find in the full incarnation of .NET 3.5.  There is however the XML Reader and Writer classes that allow you high speed access to reading and writing XML documents.  In our sample on this page we use an XML reader to read a simple XML file and render the results to the page.

Our example XML file looks like this, as you can:

<?xml version="1.0"?>
<customers>
 <customer id="10001" first="John" last="Smith" company="Donuts plc">jsmith@mymail.com</customer>
 <customer id="10002" first="Rete" last="Bandy" company="This Is Bloggers Co.">rete@superbloggers.com</customer>
 <customer id="10003" first="James" last="Bird" company="Timestone">james.bird@timestone.co.uk</customer>
 <customer id="10004" first="Sarah" last="McCauly" company="Automated Snowmen Ltd">smccauly@automatedsnowmen.com</customer>
 <customer id="10005" first="Pete" last="Rowan" company="Cooltec Consultants">pete.rowan@cooltec.com</customer>
</customers>

Now add a Listbox to usercontrol

<UserControl x:Class="XMLTutorial.Page"
 xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
 xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
 Width="400" Height="300">
 <Grid x:Name="LayoutRoot" Background="White">
 <ListBox x:Name="customersList" Width="400" Height="200" />
 </Grid>
</UserControl>
Now in usercontrol’s C# file
public partial class Page : UserControl
 {
 public Page()
 {
 InitializeComponent();

 PopulateCustomersList();
 }

 private void PopulateCustomersList()
 {
 XmlReaderSettings settings = new XmlReaderSettings();
 settings.XmlResolver = new XmlXapResolver();
 XmlReader reader = XmlReader.Create("Customers.xml");

 reader.MoveToContent();

 while (reader.Read())
 {
 if (reader.NodeType == XmlNodeType.Element && reader.Name == "customer")
 {
 customersList.Items.Add(new ListBoxItem() { Content = reader.GetAttribute("last") +
 ", " + reader.GetAttribute("first") + " (" + reader.ReadInnerXml() + ")" });
 }

 if (reader.NodeType == XmlNodeType.EndElement && reader.Name == "customers")
 {
 break;
 }
 }

 reader.Close();
 }
 }
Enjoy Coding…….

Posted in ASP.NET, Silverlight | Tagged: , , , , | Leave a Comment »

Retrieving Data as XML from SQL Server

Posted by Viral Sarvaiya on November 2, 2009


All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.

The release of Microsoft SQL Server 2000 a couple of months ago saw Microsoft jump on the XML band-wagon too – they’ve included a number of different ways to manipulate data as well-formed XML. Firstly, there’s the SQL XML support. Microsoft’s implementation of SQL XML provides a simple configuration tools that allows developers to gain remote access to databases using URL based queries over HTTP. For example, we can setup an SQL XML virtual directory on our Web server named “myVirtual”. Then, assuming we have the appropriate security permissions, we can use any browser to query our database using a simple URL based query (such as: http://www.myserver.com/myVirtual?SQL=select+*+from+products+for+xml+auto). This then returns our results as an XML based recordset.

Notice the “for xml auto” part of our query above? This determines the way in which SQL Server 2000 shapes our data. There are three shaping methods:

1. “for xml auto”: Returns XML elements that are nested, based on which tables are listed in the “from” part of the query, and which fields are listed in the “select” part.

2. “for xml raw”: Returns XML elements with the “row” prefix (ex: “<row tProduct …>”). Each column in a table is represented as an attribute and null column values aren’t included.

3. “for xml explicit”: Explicit mode is the most complex shaping method used in SQL Server 2000. It allows users to query a data source in such a way that the names and values of the returned XML are specified before the query batch is executed.

for read detials click here

other links…

http://msdn.microsoft.com/en-us/library/ms345137%28SQL.90%29.aspx

http://www.15seconds.com/issue/001102.htm

Posted in ASP.NET, Sql Server | Tagged: , , , | 1 Comment »

 
%d bloggers like this: