1 2
|
"INSERT INTO Prospect (Titre,Sujet,Civilite,Nom,Prenom,Tel_1,Tel_2,Fax,Email,Adresse,CodeP,Ville,Pays,Source,Evaluation,NomSCT,Fonction,Contact) SELECT 'Titre2', '" + TextBoxsujet.Text.ToString() + "','" + DropDownListcivilite.SelectedItem.ToString() + "','" + TextBoxnom.Text.ToString() + "','" + TextBoxprenom.Text.ToString() + "','" + TextBoxtelephone.Text.ToString() + "','" + TextBoxnum.Text.ToString() + "','" + TextBoxfax.Text.ToString() + "','" + TextBoxemail.Text.ToString() + "','" + TextBoxrue.Text.ToString() + "','" + TextBoxpostal.Text.ToString() + "',Ville.Id_Ville,Pays.ID_Pays,Source_Prosp.Id_Source,Evaluation.Id_Eval,'" + TextBoxNomS.Text.ToString() + "','" + TextBoxFonction.Text.ToString() + "','" + TextBoxContact.Text.ToString() + "' FROM Pays,Ville,Source_Prosp,Evaluation WHERE 'DropDownListpays.SelectedItem'= Pays.Libelle AND 'DropDownListVille.SelectedItem'=Ville.Libelle AND 'DropDownListsource.SelectedItem'=Source_Prosp.Libelle AND 'DropDownListevaluation.SelectedItem'=Evaluation.Libelle"; |
Partager