Hello everyone,

I've been following the ASP.NET 4 website book, which is a great book. How ever I have come across a problem I am trying to overcome. In chapter 9 of the book a page is created where you can insert data into a form and that data is then inserted into the SQL table. Now everything worked fine as I was following the tutorial. But then I decided to play around a bit and change the data so that instead of it showing the ID's of each table:


it would show the what the actual category, subject and status is.


this is what my .cs code looks like for the submit button when it is stored into the table and I'm sure there is something here I'm supposed to change or add?.
I really don't know and I have spent all day trying to figure it out. Any help will be greatly appreciated!

PHP Code:
protected void submitButton_Click(object senderEventArgs e)
    {
        if (
Page.IsValid)
        {
            
// Define data objects
            
SqlConnection conn;
            
SqlCommand comm;
            
// Read the connection string from Web.config
            
string connectionString =
                
ConfigurationManager.ConnectionStrings[
                
"SPCC HelpDesk"].ConnectionString;
            
// Initialize connection
            
conn = new SqlConnection(connectionString);
            
// Create command 
            
comm = new SqlCommand("InsertHelpDesk"conn);
            
// Specify we're calling a stored procedure
            
comm.CommandType System.Data.CommandType.StoredProcedure;
            
// Add command parameters
            
comm.Parameters.Add("@EmployeeID"System.Data.SqlDbType.Int);
            
comm.Parameters["@EmployeeID"].Value 5;

            
comm.Parameters.Add("@StationNumber"System.Data.SqlDbType.Int);
            
comm.Parameters["@StationNumber"].Value stationTextBox.Text;

            
comm.Parameters.Add("@CategoryID"System.Data.SqlDbType.Int);
            
comm.Parameters["@CategoryID"].Value categoryList.SelectedItem.Value;

            
comm.Parameters.Add("@SubjectID"System.Data.SqlDbType.Int);
            
comm.Parameters["@SubjectID"].Value subjectList.SelectedItem.Value;

            
comm.Parameters.Add("@Description"System.Data.SqlDbType.NVarChar50);
            
comm.Parameters["@Description"].Value descriptionTextBox.Text;

            
comm.Parameters.Add("@StatusID"System.Data.SqlDbType.Int);
            
comm.Parameters["@StatusID"].Value 1;
            
// Enclose database code in Try-Catch-Finally
            
try
            {
                
// Open the connection
                
conn.Open();
                
// Execute the command
                
comm.ExecuteNonQuery();
                
// Reload page if the query executed successfully
                
Response.Redirect("HelpDesk.aspx");
            }
            catch
            {
                
// Display error message
                
dbErrorMessage.Text =
                    
"Error submitting the help desk request! Please " +
                    
"try again later, and/or change the entered data!";
            }
            
finally
            
{
                
// Close the connection
                
conn.Close();
            }
        }
    }