Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
04-09-2013, 07:31 PM #1
- Join Date
- Apr 2010
- Thanked 0 Times in 0 Posts
Inserting data into another table
I've been following a book called 'ASP.NET 4 website using C# and VB'. 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!
protected void submitButton_Click(object sender, EventArgs e)
// Define data objects
// Read the connection string from Web.config
string 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["@EmployeeID"].Value = 5;
comm.Parameters["@StationNumber"].Value = stationTextBox.Text;
comm.Parameters["@CategoryID"].Value = categoryList.SelectedItem.Value;
comm.Parameters["@SubjectID"].Value = subjectList.SelectedItem.Value;
comm.Parameters.Add("@Description", System.Data.SqlDbType.NVarChar, 50);
comm.Parameters["@Description"].Value = descriptionTextBox.Text;
comm.Parameters["@StatusID"].Value = 1;
// Enclose database code in Try-Catch-Finally
// Open the connection
// Execute the command
// Reload page if the query executed successfully
// Display error message
"Error submitting the help desk request! Please " +
"try again later, and/or change the entered data!";
// Close the connection
CREATE PROCEDURE InsertHelpDesk
INSERT INTO HelpDesk (EmployeeID, StationNumber, CategoryID,
SubjectID, Description, StatusID)
VALUES (@EmployeeID, @StationNumber, @CategoryID, @SubjectID,
Last edited by Ozzy; 04-09-2013 at 08:17 PM.
04-10-2013, 12:13 PM #2
- Join Date
- Mar 2013
- Thanked 1 Time in 1 Post
you want actual category, subject and status to be inserted but in your code you have not added those fields.
04-30-2013, 03:05 PM #3
- Join Date
- May 2012
- Thanked 7 Times in 7 Posts
I totally agree with sunny68, as there is no such fields in the table that you want to insert.