Syntax Error - C# Access data insert

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

    Syntax error (missing operator) in query expression 'Test Company','Address','Shipping','Houston','000-000-0000','sales@testcoy.com)'.

Here is the code:

        //[STAThread]
        static void Main() 
        {
        Application.Run(new StockPile());
        }

        private void StockPile_Load(object sender, System.EventArgs e)
        {
            myOleDbConn
=  new
OleDbConnection(System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString")) ;
        }

        private void tabCoyInfo_Click(object sender, System.EventArgs e)
        {

        }

        private void btnSave_Click(object sender, System.EventArgs e)
        {
            OleDbCommand myOleDbCommand = new OleDbCommand();
            // Open the connection
            myOleDbConn.Open();
            //Assign the connection property.
             myOleDbCommand.Connection=my OleDbConn;
            try
            {
                // Insert new company
                 myOl eDbCommand.CommandText
= "INSERT INTO CompanyInfo (coyName, coySymbol, coyBusType,
coyLocation, coyPhone, coyEMail)  VALUES
("+txtCoyName.Text+"','"+txtSymbol.Text+"','"+txtBusType.Text+"','"+txtLocation.Text+"','"+t xtPhone.Text+"','"+txtEmail.Text+")";
                 myOl eDbCommand.ExecuteNonQuery();
                 Mess ageBox.Show("New
Customer data recorded!");
            }
            catch(Exception ex)
            {
                 Mess ageBox.Show("Error
occurred, customer data could not be recorded: " + ex.Message);
            }
            finally
            {
                 //
 Close the connection if it is open
                 if
 (myOleDbConn.State==ConnectionState.Open)
                {
                 &nbs p;   myOleDbConn.Close();
                }
            }
        }