using System.Collections.Generic;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Windows.Forms;
private static SqlConnection Cnx = new SqlConnection();
private static SqlCommand Cmd = new SqlCommand();
private static SqlDataAdapter DataAdapt = new SqlDataAdapter();
private static DataSet MonDataSet = new DataSet();
private static string MaChaine;
private static int cptvue = 0;
public static void Se_Connecter_SqlServer()
MaChaine = "Data Source=sqlserver.montpellier.epsi.fr,4433;Initial Catalog=projetcsharp;User ID=lucas.reynes;Password=epsi561GZZ";
Cnx.ConnectionString = MaChaine;
Cmd.CommandType = CommandType.Text;
MessageBox.Show("Erreur... Contacter votre Administrateur Système : " + ex.Message);
public static void Se_Deconnecter_SqlServer()
#region "Requêtes Select et Action"
public static int Generer_Cle_Primaire(string nomcle, string nomtable)
Cmd.CommandText = "SELECT Max(" + nomcle + ") FROM " + nomtable;
DataAdapt.SelectCommand = Cmd;
return Convert.ToInt32(Cmd.ExecuteScalar());
public static void Executer_Requete_Action(string marequeteaction)
Cmd.CommandText = marequeteaction;
MessageBox.Show("Requête Action Correctement Exécutée...!", "Action", MessageBoxButtons.OK, MessageBoxIcon.Information);
MessageBox.Show(ex.Message, "Erreur dans la tentative d'action", MessageBoxButtons.OK, MessageBoxIcon.Error);
public static DataTable Executer_Requete_Select(string marequeteselect)
DataTable result = new DataTable();
string MaVue = "MaVue" + cptvue;
Cmd.CommandText = marequeteselect;
DataAdapt.SelectCommand = Cmd;
DataAdapt.Fill(MonDataSet, MaVue);
MessageBox.Show(ex.Message);
result = MonDataSet.Tables[MaVue];
#region "Gestion de l'interface"
public static void AlimenterComboBox(ref ComboBox macombo, string marequete, string mavaleur)
macombo.DataSource = Executer_Requete_Select(marequete);
if (!string.IsNullOrEmpty(mavaleur))
macombo.ValueMember = mavaleur;
#region "Gestion du DataSet"
public static string GetChamp_DataTable(DataTable lesdonnees, int ligne, int colonne)
return Convert.ToString(lesdonnees.Rows[ligne][colonne]);
public static void Vider_Dataset()