How to Display data as per the DropdownList selection

Question

Sir,

I need your help to display data as per the dropDownList Selection.

Please look at the following ScreeShot:-




 My intention is , when I select a name from Customer Name dropDownList, I need to display the  concerned room type, roomPrice and paymentType in the following dropDownList.


The  SQL StoredProcedure I wrote for this function is:-


 Give me the C# code to implement this query.