Posted by news.sbcglobal.net on 06/11/06 00:31

Here's my problem:

I'm developing an ASP.NET 2.0 application that has a user select one or more
auto manufacturers from a listbox ("lstMakes"). Once they do this, another
listbox ("lstModels") should be filled with all matching models made by the
selected manufacturers. If lstMakes was not multi-select, I'd have no
problem. But in this case it has to be multi-select. The database is SQL
Server 2005 which does not accept arrays as parameters. I've been told that
I have to create an XML document that will act as a filtered Manufacturers
table that I can join to my Models table in my stored procedure. Problem is
I don't have the foggiest idea how to do this. I've seen some examples that
just leave me scratching my head so I was hoping someone could look at what
I'm trying to do and show me how to do this. Thanks!

[Back to original message]