How to delete XML indexes in SQL server

When Developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to delete an XML index, they should follow the next steps:

1. In Object Explorer, right-click the table with the XML index they want to delete and click Design (Modify in SP1 or earlier).

How to create an XML index in SQL server

Developers use an XML index to create indexes for columns of the data type xml, which cannot be indexed using the Index/Keys dialog box. Each xml column can have more than one XML index, but the first one created (primary) will be the basis of the others. When Developers working with SQL Server “Denali”, […]

How to assign an XML Schema Collection to a column in SQL server

Columns that use the xml data type can have the XML values validated against an XML schema collection. The schema collection must exist in the database before developers modify the table. If they create a new schema while modifying the table definition, the schema collection list will not include the new collection. When developers working with […]

How to populate the TreeNode objects in ASP.NET in VB.NET

If your project has a large amount of data to display in a TreeView, you probably don’t want to fill it in all at once, because that increase the time taken to process the initial request for the page, and also increase the size of the page and the view state.  The TreeView includes […]

How to populate the TreeNode objects in ASP.NET in C#

If your project has a large amount of data to display in a TreeView, you probably don’t want to fill it in all at once, because that increase the time taken to process the initial request for the page, and also increase the size of the page and the view state.  The TreeView includes […]

How to use the TreeNode object in selection mode in ASP.NET in VB.NET

You can use TreeNode in one of two modes:

– In selection mode, clicking the node posts back the page and raises the TreeView.SelectedNodeChanged event. This is default mode for all nodes.

– In navigation mode, clicking a node navigates to a new page, and the SelectedNodeChanged event is not […]

How to use the TreeNode object in selection mode in ASP.NET in C#

You can use TreeNode in one of two modes:

– In selection mode, clicking the node posts back the page and raises the TreeView.SelectedNodeChanged event. This is default mode for all nodes.

– In navigation mode, clicking a node navigates to a new page, and the SelectedNodeChanged event is not […]

How to use XSLT with TreeView to make XML hierarchical data binding in ASP.NET

In the article How to use TreeView to make XML hierarchical data binding in ASP.NET is shown how you can use XmlDataSource and TreeView control together to make hierarchical data binding. In addition XmlDataSource has built-in support for XSL transformations. You can use it to convert the source XML document into an XML structure […]

How to use TreeView to make XML hierarchical data binding in ASP.NET

Some controls in .NET, like TreeView, have the built-in smarts to show hierarchical data. When you bind the TreeView to an XmlDataSource, it uses the XmlDataSource.GetHierarchicalView() method and displays the full structure of the XML document.

The next XML file named BooksList.xml is used as example:

 

<?xml version=”1.0″ encoding=”utf-8″?>

<BooksList>

<Book ISBN-13=”978-0545139700″>

<Title>Harry Potter and […]

How to validate XML document with XDocument class in VB.NET

When you want to validate an XML document against a schema, by using XDocument you need to import the System.Xml.Schema namespace. In this way you can use validation classes which XDocument class doesn’t have. The imported namespace contains an Extensions class that include a Validate() method you can use on an XElement or XDocument.

Note: […]

Recommended ASP.NET Examples