1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
|
//la requete select :
this.DataAdapterLycee = new MySql.Data.MySqlClient.MySqlDataAdapter("SELECT * FROM eleve,responsable WHERE eleve.idResp=responsable.idResp ORDER BY idEleve ASC",this.ConnectionLycee);
//la commande d'instertion :
DataRow tmp = this.dataSet1.Tables["eleve"].NewRow();
tmp["NomEleve"] = NEleve.NomEleve.Text;
tmp["PrenomEleve"] = NEleve.PrenomEleve.Text;
tmp["NomResp"] = NEleve.NomResp.Text;
tmp["PrenomResp"] = NEleve.PrenomResp.Text;
tmp["AdrResp"] = NEleve.AdresseResp.Text;
tmp["cPResp"] = NEleve.cpResp.Text;
tmp["VilleResp"] = NEleve.VilleResp.Text;
tmp["TelDom"] = NEleve.TelDom.Text;
tmp["TelTrav"] = NEleve.TelTrav.Text;
tmp["MontantCaution"] = NEleve.Caution.Text;
tmp["ModePaiement"] = NEleve.ModePaiement.Text;
tmp["BanqueC"] = NEleve.BanqueC.Text;
tmp["NumCheque"] = NEleve.NumCheque.Text;
tmp["DateCaution"] = DateTime.Today.ToString("dd-MM-yyyy");
if(NEleve.Adherent.Checked == true)
{
tmp["adherent"] = "O";
}
else
{
tmp["adherent"] = "N";
}
this.dataSet1.Tables["eleve"].Rows.Add(tmp);
this.dataSet1.Tables["eleve"].AcceptChanges();
this.DataAdapterLycee.InsertCommand = new MySql.Data.MySqlClient.MySqlCommand("INSERT INTO responsable(idResp,NomResp,PrenomResp,cPResp,AdrResp,SAdrResp,VilleResp,TelDom,TelTrav,adherent) VALUES('','?NomResp','?PrenomResp','?CPResp','?AdrResp','?SAdrResp','?VilleResp','?TelDom,'?TelTrav','?adherent')",this.ConnectionLycee);
this.DataAdapterLycee.InsertCommand.Parameters.Add("NomResp",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters.Add("PrenomResp",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters.Add("CPResp",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters.Add("AdrResp",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters.Add("SAdrResp",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters.Add("VilleResp",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters.Add("TelDom",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters.Add("TelTrav",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters.Add("adherent",MySqlDbType.VarChar);
this.DataAdapterLycee.InsertCommand.Parameters["NomResp"].SourceColumn = "NomResp";
this.DataAdapterLycee.InsertCommand.Parameters["PrenomResp"].SourceColumn = "PrenomResp";
this.DataAdapterLycee.InsertCommand.Parameters["CPResp"].SourceColumn = "cPResp";
this.DataAdapterLycee.InsertCommand.Parameters["AdrResp"].SourceColumn = "AdrResp";
this.DataAdapterLycee.InsertCommand.Parameters["SAdrResp"].SourceColumn = "SAdrResp";
this.DataAdapterLycee.InsertCommand.Parameters["VilleResp"].SourceColumn = "VilleResp";
this.DataAdapterLycee.InsertCommand.Parameters["TelDom"].SourceColumn = "TelDom";
this.DataAdapterLycee.InsertCommand.Parameters["TelTrav"].SourceColumn = "TelTrav";
this.DataAdapterLycee.InsertCommand.Parameters["adherent"].SourceColumn = "adherent";
this.DataAdapterLycee.Update(this.dataSet1.Tables["eleve"]); |
Partager