Corrigé bts ig
1) Proposer un schéma XSD :<?xml version="1.0" encoding="utf-8"?><xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"> <xs:element name="FestivaleRire"> <xs:complexType> <xs:sequence> <xs:element name="participant" maxOccurs="unbounded" > <xs:complexType> <xs:sequence> <xs:element name="nom" type="xs:string" /> <xs:element name="prenom" type="xs:string" /> <xs:element name="civilite" type="xs:string" /> <xs:element name="tel" type="xs:integer" /> <xs:element name="ville"> <xs:complexType> <xs:sequence> <xs:element name="idv" type="xs:integer" /> <xs:element name="libellev" type="xs:string" /> </xs:sequence> </xs:complexType> …afficher plus de contenu…
SqlConnection cx; string sc = "data source=.; initial catalog=BD_Festival; integrated security=yes"; public Form1() { InitializeComponent(); }Question 1):private void btAj_Click(object sender, EventArgs e) { cx = new SqlConnection(sc); string req = "insert into Participant (idP,nom,prenom,Tel,idV) values (@idp,@nom,@prenom,@tel,@idv)"; SqlCommand cmd = new SqlCommand(req, cx); cmd.Parameters.AddWithValue("@idp", t1.Text); cmd.Parameters.AddWithValue("@nom", t2.Text); cmd.Parameters.AddWithValue("@prenom", t3.Text); cmd.Parameters.AddWithValue("@tel", t4.Text); cmd.Parameters.AddWithValue("@idv", t5.Text); cx.Open(); cmd.ExecuteNonQuery(); cx.Close(); } private void btSuppr_Click(object sender, EventArgs e) { cx = new SqlConnection(sc); string req = "Delete