| 12
 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
 
 | using System;
using System.Collections;
using System.Configuration;
using System.Data.SqlClient;
using System.Security.Cryptography;
using System.Text;
using System.Text.RegularExpressions;
using System.Web.Mail;
using System.Windows.Forms;
 
/// <summary>
/// Summary description for Execute_update_insert_delete
/// </summary>
public class Execute_update_insert_delete
{
    public int Execute(string requeteString, string p_prenom, string p_nom, string p_sexe, DateTime p_date_naissance, string p_pays, string p_passe, string p_email, DateTime p_date_creation, string p_adresse)
    {
        var connString = ConfigurationManager.ConnectionStrings["XXOA_MAILS_ConnectionString"].ConnectionString;
        SqlConnection conn = new SqlConnection(connString);
        conn.Open();
        SqlCommand cmd = new SqlCommand(requeteString, conn);
        SqlParameter param = new SqlParameter();
        cmd.Parameters.Add(new SqlParameter("@PRENOM", p_prenom));
        cmd.Parameters.Add(new SqlParameter("@NOM", p_nom));
        cmd.Parameters.Add(new SqlParameter("@SEXE", p_sexe));
        cmd.Parameters.Add(new SqlParameter("@DATE_NAISSANCE", p_date_naissance));
        cmd.Parameters.Add(new SqlParameter("@PAYS", p_pays));
        cmd.Parameters.Add(new SqlParameter("@PASSE", p_passe));
        cmd.Parameters.Add(new SqlParameter("@EMAIL", p_email));
        cmd.Parameters.Add(new SqlParameter("@DATE_CREATION", p_date_creation));
        cmd.Parameters.Add(new SqlParameter("@ADRESSE", p_adresse));
        int countLigne = 0;
        countLigne = cmd.ExecuteNonQuery();
        return countLigne;
        conn.Close();
    }
} | 
Partager