data type mismatch in criteria expression in c# 2010
<p>I have this problem I keep getting the error message:</p>

<pre><code>data type mismatch in criteria expression 
</code></pre>

<p>It appears when I add my totals to my access db.  </p>

<p>If I click my submit button, but if I click it again then all the data writes to my db. If I take total out then it all writes first time.</p>

<p>It is a rating program so all fields are integers and all my fields in my db are set to number except for EmployeeName.  </p>

<p>All the questions that have been asked on this matter that I can find are on the date/time data type which does not help me below is the coding I am using to calculate my total all other numbers are inputted by the user except for total.</p>

<pre><code>public void Admin(string EmployeeName, string OutPuts, string Efficiency, 
                      string Courtesy, string Difficulty, string Project, 
                      string Commitments, string Responsibility, string Attendance, 
                      string Interested, string Leads, string Administration, 
                      string Leadership, string Ownership, string Costs, 
                      string Customers, string Workspace, string Tot1)         
    {             
        try             
        {                  
            int num1, num2, num3, num4, num5, num6, num7, num8, num9, num10, 
                num11, num12, num13, num14, num15, num16, res;                  
            num1 = Convert.ToInt32(tbOutput.Text);                 
            num2 = Convert.ToInt32(tbEfficiency.Text);                 
            num3 = Convert.ToInt32(tbCourtesy.Text);                 
            num4 = Convert.ToInt32(tbDifficulty.Text);                 
            num5 = Convert.ToInt32(tbProjects.Text);                 
            num6 = Convert.ToInt32(tbCommitments.Text);                 
            num7 = Convert.ToInt32(tbResponsibility.Text);                 
            num8 = Convert.ToInt32(tbAttendance.Text);                 
            num9 = Convert.ToInt32(tbInterested.Text);                 
            num10 = Convert.ToInt32(tbLeads.Text);                 
            num11 = Convert.ToInt32(tbAdmin.Text);                 
            num12 = Convert.ToInt32(tbLeadership.Text);                 
            num13 = Convert.ToInt32(tbOwnership.Text);                 
            num14 = Convert.ToInt32(tbCosts.Text);                 
            num15 = Convert.ToInt32(tbCustomers.Text);                 
            num16 = Convert.ToInt32(tbWorkspace.Text);                  
            res = num1 / 10 * 9 + num2 / 10 * 8 + num3 / 10 * 3 
                + num4 / 10 * 2 + num5 / 10 * 9 + num6 / 10 * 5 
                + num7 / 10 * 6 + num8 / 10 * 5 + num9 / 10 * 5 
                + num10 / 10 * 5 + num11 / 10 * 10 + num12 / 10 * 5 
                + num13 / 10 * 5 + num14 / 10 * 3 + num15 / 10 * 10 
                + num16 / 10 * 10;                  
            tbRes.Text = Convert.ToString(res);                  
            string request = tbEmployee.Text;                 
            //Opens a connection to the database                 
            OleDbConnection conn = new OleDbConnection(ConnString);                 
            conn.Open();                 
            OleDbCommand cmd = conn.CreateCommand();                 
            cmd.CommandText = "SELECT * FROM [Admin] WHERE EmployeeName = '" + request + "';";                 
            OleDbDataReader dbReader = cmd.ExecuteReader();                 
            dbReader.Read();                 
            OleDbCommand updateUser = conn.CreateCommand();                 
            updateUser.CommandText = ("UPDATE [Admin] SET OutPuts ='" + OutPuts + "', Efficiency = '" + Efficiency 
                                      + "', Courtesy = '" + Courtesy + "', Difficulty = '" + Difficulty + "', Project = '" 
                                      + Project + "', Commitments = '" + Commitments + "', Responsibility = '" + Responsibility 
                                      + "', Attendance = '" + Attendance + "', Interested = '" + Interested + "', Leads = '" 
                                      + Leads + "', Administration = '" + Administration + "', Leadership = '" 
                                      + Leadership + "', Ownership = '" + Ownership + "', Costs = '" 
                                      + Costs + "', Customers = '" + Customers + "', Workspace = '" + Workspace + ", Tot1 = " 
                                      + Tot1 + "' WHERE EmployeeName = '" + request + "'");                 
            updateUser.ExecuteNonQuery();                  
            //If User exsits                 
            if (dbReader.HasRows)                 
            {                     
                string EmployeeName = dbReader.GetString(0);                 
            }                 
            else                 
            {                     
                MessageBox.Show("Employee is not in this category", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);                     
                conn.Close();                 
            }                 
            conn.Close();             
        }             
        catch (OleDbException e)             
        {                 
            MessageBox.Show("The exception is " + e.ToString());             
        }         
    }
</code></pre>
