1 2 3 4 5 6 7 8 9 10
|
cmd.CommandType =CommandType.Text
cmd.CommandText = "insert into notes(note,eleve,niveau,classe,matiere) values(@note,@eleve,@niveau,@classe,@matiere)"
cmd.Parameters.Add("@note", SqlDbType.float, "note").Value = nt;
cmd.Parameters.Add("@eleve", SqlDbType.NVarChar, 25, "eleve").Value =Me.listeleve.SelectedValue
cmd.Parameters.Add("@niveau", SqlDbType.NVarChar, 25, "niveau").Value = Me.ListeNiveau.SelectedValue
cmd.Parameters.Add("@classe", SqlDbType.NVarChar, 25, "classe").Value = Me.listeclasse.SelectedValue
cmd.Parameters.Add("@matiere", SqlDbType.NVarChar, 25, "matiere").Value = Me.listematiere.SelectedValue
cmd.Connection = con
cmd.ExecuteNonQuery() |
Partager