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
| 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