.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Web Q&A: XPath, XML Notepad, Data Islands, Case Sensitivity, XSL, and More

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

More Related Resource Links

Real-World XML: Manipulate XML Data Easily with the XPath and XSLT APIs in the .NET Framework


XPath is emerging as a universal query language. With XPath, you can identify and process a group of related nodes in XML-based data sources. XPath provides an infrastructure that is integral to XML support in the .NET Framework. The XPath navigation model is even used under the hood of the XSLT processor. In this article, the author reviews the implementation details of the XPath navigator and the XSLT processor and includes practical examples such as asynchronous transformations, sorted node-sets, and ASP.NET server-side transformations.

Dino Esposito

MSDN Magazine July 2003

How to retrieve conditional XML data using XPath


 I have a XMLDataSource somewhat like:


I am storing these in a asp:formview. I am able to store author and publication values but not sure how can I store the value of book name? Actually I just want to use condition that I need to store "name" if "genere=Romance". something like this. I know we can use contition/expression in XPath method but if it is an attribute like <book genere="romance">. Can someone throw light on this question.

How to retrieve conditional XML data using XPath Expression

I have a XMLDataSource somewhat like:

DataColumn Name Case Sensitivity

If I understand the Microsoft documentation, DataColumn names are supposed to be case sensitive only "conditionally." In other words, if I have a column named "MyColumn" and there are no other columns in my collection with that name, then I should be able to reference it either:




This seems to work for me when I test it in C# code. However, if I rename a column, it seems that case all of the sudden becomes sensitive. For example:

myColCollection[0].ColumnName = "Renamed";
DataColumn myCol1 = myColCollection["Renamed"]; // returns a DataColumn object
DataColumn myCol2 = myColCollection["reNaMed"]; // returns a NULL refenrece.

This seems like a bug to me. Can anyone confirm this? Or explain a way around it?

DataColumn Name Case Sensitivity


* This question is related to this thread [http://forums.asp.net/t/707552.aspx]

I am also facing with the same situation.I have an existing application which have a interface exposed which have an DataTable as an input parameter.

I wanted to read the column name on ther server as case insensitive.

Mean't what ever column name is provided it can be read at the server side as case insensitive

Best way to refresh windows/controls in case relevant data has been updated


I have an application with number of screens used to edit/display data. In case any of screens is edited, all dependant screens must be refreshed. I do not want to refresh data used by screens each time they become active. I was thinking of creating an interface:

interface IRefreshable { void Resfresh() }

All child windows(=screens) will implement this interface. Once any of the screens is saved it will notify it's parent window (=main app window) what kind of data was resfreshed. Main window will permanently store list of all child windows that are affected by specific change and will resfresh them.

class Main:Form{

  private  static Dictionary<DataType, List<IRefreshable>> resfreshableDict;

  static Main()


    // initialize resfreshableDict



  public Refresh(DataType type)


    // fetch IResfreshable for the type from resfreshableDict and invoke Resfresh()





class TaxesScreen: Form, IRefreshable


  private saveData()


    // save data

    // notify parent about the change of taxes data


SSIS - Terra Data Case Studies

Can Anybody pls. provide the case studies for SSIS being used for TerraData integration.

Import data from notepad to SQL Server 2008


I have a notepad file like below:

Name:           Kerlavage, AR
Lab:            Bioinformatics
Institution:    The Institute for Genomic Research
Address:        9712 Medical Center Drive, Rockville, MD 20850 USA
Tel:            3018699056
Fax:            3018699423
E-mail:         arkerlav@tigr.org

PubMed ID:      2047873
Title:          Complementary DNA sequencing: expressed sequence tags and
                human genome project
Authors:        Adams,M.D., Kelley,J.M., Gocayne,J.D., Dubnick,M.,
                Polymeropoulos,M.H., Xiao,H., Merril,C.R., Wu,A., Olde,B.,
                Moreno,R.F., atal

new query - braces, case sensitivity, database names now required? TURN IT OFF PLEASE?


call me stupid or whatever, i don't care.

i have found the new query editor in 2008 have the most restrictive and pain in the a$$ feature i have ever seen.
every query now requires brackets, fully qualified dabase name + table + column for reference.

WHY am i required to type the name of the database i'm querying in a stored procedure?  COMPLETELY POINTLESS!
PLUS on top of all of that, the junk is CASE SENSITIVE.  if i wanted to waste time worrying about caps, braces and meaningless syntactical characters,  i would write code in C#.

the reason why this is SUCH AN INCONVENIENCE is that the database i am writing against has HUNDREDS of tables.
additionally, i've used 2005 for years and i really find it highly inconvenient to use the same tool as before but now i need to write queries in proper english and case.

here's a quick example: 
previously i could type 'select top 5 zipcode from shipment
NOW with the new and improved pain in the a$$ feature i have to type:
'select top 5 '[databasename].[dbo].[shipment].[zipcode] from [databasename].[dbo].[shipment]'
that might not be an exact example but you get the idea.

maybe i just don't know what the new intellisense feature is that controls this?
somebody please help me figure out how to turn off this restriction, it is

Manipulate XML data with XPath and XmlDocument (C#)

This link given a basic knowledge about XPath

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Visual Case Tool - UML Tutorial

The Class Diagram

The class diagram is core to object-oriented design. It describes the types of objects in the system and the static relationships between them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend