Firstly thanks to joefawcett and mhkay for responding to my XML parsing problem. Unfortunately I'm still struggling. The problem is with the following line of code:

objParameterNodes = objDom.SelectNodes("/StoredProcedures/StoredProcedure[@name=usp_Get_Authors_By_States]/Parameters/Parameter")

This statement does not populate my XmlNodeList and I get an error message warning me that the stotedprocedure expects a parameter which was not suppled. however if I enter this XmlNodeList gets instantiated and off it goes.

objDom.SelectNodes("/StoredProcedures/StoredProcedure/Parameters/Parameter")

If convinced the problem lies with the XPath expression.

Perhaps usp_Get_Authors_By_States should be in quotes. Is it supposed to be the name of an element, or a character string to be compared with @name?

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference