Syntax Error ASP.NET
<p>I'm getting a syntax error that I don't seem to find an answer to and I was hoping that someone would be able to see what I am missing.</p>

<p>I am trying to add data in a database by using the following code but it throws a Syntax error message and I don't really see why.</p>

<p>This is my code:</p>

<pre><code> // Get data from textboxes.
    string last = txtLastName.Text;
    string first = txtFirstName.Text;
    string gender = txtGender.Text;
    string email = txtEmail.Text;
       int age = int.Parse(txtAge.Text);
    string pref = "";    
    // Compose SQL command string.
    string sql = "INSERT INTO Applicant VALUES"  + 
        "('" + first + "', '" + last +
        "', '" + gender + "', '" + age + "', " + email + ");";
</code></pre>

<p>And this is the Error message</p>

<pre><code>Syntax error (missing operator) in query expression 'email.example@email.com'.

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.OleDb.OleDbException: Syntax error (missing operator) in query expression 'email.example@email.com'.

Source Error: 


Line 50:     // Create command object and execute insert statement.
Line 51:     OleDbCommand command = new OleDbCommand(sql, c);
Line 52:     command.ExecuteNonQuery();
Line 53:         
Line 54:     // Close connection.

Source File: d:\DePaul\Winter 2012\IT 330\Projects\Proj5-Nicolaides\Proj5-Nicolaides\application-form.aspx    Line: 52 

Stack Trace: 


[OleDbException (0x80040e14): Syntax error (missing operator) in query expression 'email.example@email.com'.]
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +992124
   System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object&amp; executeResult) +255
   System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object&amp; executeResult) +188
   System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object&amp; executeResult) +58
   System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +161
   System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
   ASP.application_form_aspx.btnSubmit_Click(Object sender, EventArgs e) in d:\DePaul\Winter 2012\IT 330\Projects\Proj5-Nicolaides\Proj5-Nicolaides\application-form.aspx:52
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.5448; ASP.NET Version:2.0.50727.5456
</code></pre>
