public void AddNewPatient(string pNom, string pPrenom, string pAdresse, string pCp, string pLocalite, string pTel, string pGsm)
{
DataTable TPatients = new DataTable();

OleDbConnection m_ADONetConnection = new OleDbConnection(connString);

OleDbDataAdapter m_PatientsDataAdapter;
//Inutile de vrifier le contenu du SELECT car les donnes proviennent de sources sr.
m_PatientsDataAdapter = new OleDbDataAdapter("SELECT * FROM Patients", m_ADONetConnection);
OleDbCommandBuilder m_CommandBuiler = new OleDbCommandBuilder(m_PatientsDataAdapter);
m_PatientsDataAdapter.Fill(TPatients);


m_PatientsDataAdapter.SelectCommand = new OleDbCommand();
m_PatientsDataAdapter.SelectCommand.Connection = m_ADONetConnection;
// Vrification des paramtres entr par l'utilisateur
m_PatientsDataAdapter.SelectCommand.Parameters.Add("@Nom", OleDbType.VarChar, 200);
m_PatientsDataAdapter.SelectCommand.Parameters["@Nom"].Value = pNom;

m_PatientsDataAdapter.SelectCommand.Parameters.Add("@Prenom", OleDbType.VarChar, 200);
m_PatientsDataAdapter.SelectCommand.Parameters["@Prenom"].Value = pPrenom;

m_PatientsDataAdapter.SelectCommand.Parameters.Add("@Adresse", OleDbType.VarChar, 200);
m_PatientsDataAdapter.SelectCommand.Parameters["@Adresse"].Value = pAdresse;

m_PatientsDataAdapter.SelectCommand.Parameters.Add("@Cp", OleDbType.VarChar, 10);
m_PatientsDataAdapter.SelectCommand.Parameters["@Cp"].Value = pCp;

m_PatientsDataAdapter.SelectCommand.Parameters.Add("@Localite", OleDbType.VarChar, 200);
m_PatientsDataAdapter.SelectCommand.Parameters["@Localite"].Value = pLocalite;

m_PatientsDataAdapter.SelectCommand.Parameters.Add("@Tel", OleDbType.VarChar, 20);
m_PatientsDataAdapter.SelectCommand.Parameters["@Tel"].Value = pTel;

m_PatientsDataAdapter.SelectCommand.Parameters.Add("@Gsm", OleDbType.VarChar, 20);
m_PatientsDataAdapter.SelectCommand.Parameters["@Gsm"].Value = pGsm;

DataRow drNewRow = TPatients.NewRow();
drNewRow["NomPatients"] = "@Nom";
drNewRow["PrenomPatients"] = "@Prenom";
drNewRow["AdressePatients"] = "@Adresse";
drNewRow["CPPatients"] = "@Cp";
drNewRow["LocalitePatients"] = "@Localite";
drNewRow["TelPatients"] = "@Tel";
drNewRow["GSMPatients"] = "@Gsm";
TPatients.Rows.Add(drNewRow);

m_PatientsDataAdapter.Update(TPatients);

m_ADONetConnection.Close();


}