SQL Command Error
<p>here is the story :</p>

<p>Im trying to insert some data form the form to my data base but some thing wrong with the syntax "Vs Say so" but i can't find the mistake and some one help ?</p>

<pre><code>MySqlConnection conn = new MySqlConnection("Server=localhost;Database=ltdb;UID=root;Password=1234;port=3306");
try
{
    string command = "(INSERT INTO invoice companyName,rate,svatNo,tinNo,line1,line2,city)VALUES('" + this.txtname.Text + "','" + this.txtrate.Text + "','" + this.txtsvatno.Text + "','" + this.txttinno.Text + "','" + txtadline1.Text + "','" + txtadline2.Text + "','" + txtcity.Text + "');";
    conn.Open();
    MySqlCommand cmd = new MySqlCommand(command, conn);
    cmd.ExecuteNonQuery();
    conn.Close();
    MessageBox.Show("Saved !");
}
catch (Exception ex)
{
    MessageBox.Show(ex.Message);
}
</code></pre>