Compile SQL Reference Table query vs 2010 c#

[rgh3320]

I am completely new to SQL server i know a few of the basics. I have a VS2010 asp.net c# application with two dropdown listboxes and a textbox. I need to calculate the numbers e.g 3 + 3 = Medium, using the table below to calculate the answer so i can insert the output value into a textbox. Could anyone please help ?


Table
1 2 3 4 5
1 Cold Cold Cold Cold HOT
2 Cold Cold Cold Medium HOT
3 Cold Medium Medium HOT HOT
4 Medium Medium Medium HOT HOT
5 Medium Medium Medium HOT HOT
Drop down Listbox 3 Drop down Listbox 3

TextBox Medium

 

[jbenson001]

You already posted in the SQL Server forum