No data insertion (message: insertion successful)
<pre><code>        private void iSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
    {
        using (SqlConnection conn = new SqlConnection(Connection.con))
        {                
            conn.Open();               
                using (SqlCommand cmd = new SqlCommand(@"INSERT INTO [City] (name) VALUES (@Name)", conn))
                {
                    cmd.Parameters.AddWithValue("@Name", city.Text.ToLower());                        
                    MessageBox.Show(city.Text);
                    MessageBox.Show("Insertion successful");
                }

                using (SqlCommand cmd = new SqlCommand(@"INSERT INTO [State] (name) VALUES (@Name)", conn))
                {
                    cmd.Parameters.AddWithValue("@Name", state.Text.ToLower());
                    MessageBox.Show("Insertion successful");
                }
            conn.Close();
         }
    }
</code></pre>

<p>Program is not inserting, rows in the database tables are empty and I'm getting messages that insertion is successful. Please help. Thanks.</p>