XmlDataSource DDL and Gridview

rthomson77@hotmail.com · January 20th, 2009, 04:37 PM

I would like to create a simple page that uses an xml file with the following data.

Jobrole Course1 Course2 Course3 Course4

I then need a dropdown that shows all of the jobroles with the xml file and then upon selection of the Jobrole it displays the Course1 to 4 list either i a gridview or just as a list.

I can do this confidently using SQLDataSoure and any relational databsae but I am new to XML and am not sure how to use it.

Is anyone able to provide me with a sample?

Appreciate any help or guidance provided

mhkay · January 20th, 2009, 05:49 PM

You haven't said what technology you want to use: XSLT?

You're being a bit ambitious hoping that someone will give you a solution to this particular task especially as you have given such a sketchy description of the input and output. Get yourself a good book and work through some of the examples, or if you're short of cash go through one of the on-line tutorials on the web. Then come back here when there's a specific point you don't understand.

rthomson77@hotmail.com · January 21st, 2009, 10:09 AM

Ok,

Could you perhaps recommend a book to look at then because there seems to be lots that are based on XML and .Net?

Once I have read the book I will come back to the forum with any questions or specifics.

Thanks for your advice

mhkay · January 21st, 2009, 10:49 AM

Well, you'll have seen from my sig that I'm the author of the Wrox XSLT/XPath reference book. This is a big book that gives very comprehensive coverage of the language; it also goes quite deeply into the concepts. It's a book for people who like detail and who want a deep understanding. There are other books, such as Jeni Tennison's, that might be better if you prefer a gentler introduction.

Martin Honnen · January 21st, 2009, 10:57 AM

As you mention XmlDataSource I guess you want to use ASP.NET and its XmlDataSource control. There is a forum dedicated to that http://forums.asp.net/43.aspx, if you post your XML sample data and your requirements there then you can hopefully get some directions on how to use that control and other ASP.NET controls to find an ASP.NET solution.