Comments by Member 11545313 (Top 5 by date)

int a = cmd.ExecuteNonQuery();

i try it but , he added me all the information in combobox + exeption
(Conversion failed when converting the varchar value 'Money,2015-03-23 ,90min' to data type int.
i want to increase the insertion of field in combobox at runtime

i'm post it just in this forum think's for advice

i tried in button added
try
{
cn.Open();
cmd.CommandText = ("insert into film (nom_film,date_sortie,duree)values('" + textBox1.Text+ "','"+this.dateTimePicker1.Text+"','"+textBox3.Text+"')");
cmd.Connection = cn;
cmd.ExecuteNonQuery();

//the problems is inside loop
if (comboBox1.SelectedIndex != 0)
{
this.comboBox1.Items.Add(this.comboBox1.SelectedIndex);
//comboBox1.Refresh();
}

textBox1.Clear();
textBox1.Focus();
textBox3.Clear();
MessageBox.Show("Film Ajouter Avec Succees", "insertion Filme", MessageBoxButtons.OK, MessageBoxIcon.Information);
cn.Close();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message.ToString());
}