title: Inserting into table from a form in asp.net
body: <p>I have a page that you fill some information and according to that information i insert a new row to the database. Here is the screenshot of the form that is filled:</p>
  
  <p><img src="https://i.stack.imgur.com/KrA1a.jpg" alt="enter image description here"></p>
  
  <p>Here is my code to insert into database when clicked submit button:</p>
  
  <pre><code> protected void CreateCourseButton_Click(object sender, EventArgs e)
  {
      SqlConnection con = new SqlConnection();
      con.ConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=University;Integrated Security=True;Pooling=False";
  
      string query1 = "insert into Courses(CRN,CourseName,StudyLevel,Capacity,Instructor,Credits,Prerequisite) values ("
          + courseID.Text + "," + courseName.Text + "," + studyLevel.SelectedValue + "," + capacity.Text + "," + "Admin," + credits.Text + "," + prereq.Text + ")";
  
  
  
      SqlCommand cmd1 = new SqlCommand(query1, con);
      con.Open();
      cmd1.ExecuteNonQuery();
      con.Close();
  }
  </code></pre>
  
  <p>The problem is, i get the following error when i click submit:</p>
  
  <pre><code>Server Error in '/Bannerweb' Application.
  
  Incorrect syntax near the keyword 'to'.
  
  Description: An unhandled exception occurred during the execution of the current web     
  request. Please review the stack trace for more information about the error and where   
  it originated in the code. 
  
  Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the   
  keyword 'to'.
  
  Source Error: 
  
  
  Line 32:         SqlCommand cmd1 = new SqlCommand(query1, con);
  Line 33:         con.Open();
  Line 34:         cmd1.ExecuteNonQuery();
  Line 35:         con.Close();
  Line 36:     }
  
  Source File: c:\Banner\Bannerweb\Pages\CreateCourse.aspx.cs    Line: 34 
  
  Stack Trace: 
  
  
  [SqlException (0x80131904): Incorrect syntax near the keyword 'to'.]
     System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean     
  breakConnection) +2084930
     System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean    
  breakConnection) +5084668
     System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
     System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler,   
  SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject  
  stateObj) +2275
     System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean 
  async) +228
     System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result,     
  String methodName, Boolean sendToPipe) +326
     System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
     CreateCourse.CreateCourseButton_Click(Object sender, EventArgs e) in  
  c:\Banner\Bannerweb\Pages\CreateCourse.aspx.cs:34
    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
     System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
  </code></pre>
  
  <p>Line 34 is:</p>
  
  <pre><code>cmd1.ExecuteNonQuery();
  </code></pre>
  
  <p>Can anyone help me with this error?</p>
  
  <p>Thanks</p>