Single DropDownList running Multiple Queries - Revisted

I have a drop down with several option. I would like that if a certain item is select then a certain query will run. I read a post that azamsharp on 12/23/03
In that post he suggested to do:
string myProcedure = DropDownList.SelectedItem.value.ToString(); 

SqlCommand myCommand = new SqlCommand("myProcedure",myConnection);


Can some one help to explain this to me? Also while reading through the post it seems that this wasn't a great idea. Are there any other solutions?


Thanks
...