private void Enseignant_etudiants_Load(object sender, EventArgs e)
{
con = new SqlConnection(connectionString);
da = new SqlDataAdapter("SELECT * FROM Etudiant", con);
ds = new DataSet();
BindingSource bs = new BindingSource();
try
{
da.Fill(ds, "Etudiants");
bs.DataSource = ds.Tables["Etudiants"];
dataGridView1.DataSource = bs;
}
catch (Exception ex)
{
MessageBox.Show("Erreur d'affichage ! \n plus de détails : " + ex.ToString());
}
//Modifier le bouton de statistiques
Statistiques.Width = 100;
//Deplacer le bouton de statistiques à la fin
DataGridViewColumnCollection columnCollection = dataGridView1.Columns;
DataGridViewColumn firstVisibleColumn =
columnCollection.GetFirstColumn(DataGridViewElementStates.Visible);
DataGridViewColumn lastVisibleColumn =
columnCollection.GetLastColumn(
DataGridViewElementStates.Visible, DataGridViewElementStates.None);
int firstColumn_sIndex = firstVisibleColumn.DisplayIndex;
firstVisibleColumn.DisplayIndex = lastVisibleColumn.DisplayIndex;
}
//</snippet160>
//<snippet170>
// Swap the last column with the first.
private void Button10_Click(object sender, EventArgs args)
{
DataGridViewColumnCollection columnCollection = dataGridView.Columns;
DataGridViewColumn firstVisibleColumn =
columnCollection.GetFirstColumn(DataGridViewElementStates.Visible);
DataGridViewColumn lastVisibleColumn =
columnCollection.GetLastColumn(
DataGridViewElementStates.Visible, DataGridViewElementStates.None);
int firstColumn_sIndex = firstVisibleColumn.DisplayIndex;
firstVisibleColumn.DisplayIndex = lastVisibleColumn.DisplayIndex;
lastVisibleColumn.DisplayIndex = firstColumn_sIndex;
}
private void Form1_Load(object sender, EventArgs e)
{
chkWtrM.Checked = false;
DataTable gvSource = DisplayFilesInGridView();
DataRow gvRow;
//Get All Folders Or Directories and add in table
DirectoryInfo directory = new DirectoryInfo(@"input/");
DirectoryInfo[] subDirectories = directory.GetDirectories();
foreach (DirectoryInfo dirInfo in subDirectories)
{
gvRow = gvSource.NewRow();
gvRow[0] = dirInfo.Name;
gvSource.Rows.Add(gvRow);
}
//Get files in all directories
FileInfo[] files = directory.GetFiles("*.pdf", SearchOption.AllDirectories);
foreach (FileInfo fileInfo in files)
{
PdfReader pdfReader = new PdfReader(fileInfo.FullName);
int numberOfPages = pdfReader.NumberOfPages;
gvRow = gvSource.NewRow();
gvRow[0] = fileInfo.Name;
gvRow[1] = numberOfPages.ToString();
gvSource.Rows.Add(gvRow);
}
dataGridView1.DataSource = gvSource;
//Output
DataTable outgvSource = DisplayFilesOutGridView();
DataRow outgvRow;
//Get All Folders Or Directories and add in table
DirectoryInfo outdirectory = new DirectoryInfo(@"output/");
DirectoryInfo[] outsubDirectories = outdirectory.GetDirectories();
foreach (DirectoryInfo outdirInfo in outsubDirectories)
{
outgvRow = outgvSource.NewRow();
outgvRow[0] = outdirInfo.Name;
outgvSource.Rows.Add(outgvRow);
}
//Get files in all directories
FileInfo[] outfiles = outdirectory.GetFiles("*.pdf", SearchOption.AllDirectories);
foreach (FileInfo outfileInfo in outfiles)
{
PdfReader pdfReader = new PdfReader(outfileInfo.FullName);
int numberOfPages = pdfReader.NumberOfPages;
outgvRow = outgvSource.NewRow();
outgvRow[0] = outfileInfo.Name;
outgvRow[1] = numberOfPages.ToString();
outgvSource.Rows.Add(outgvRow);
}
dataGridView2.DataSource = outgvSource;
// Initialize the button column.
DataGridViewButtonColumn buttonColumn = new DataGridViewButtonColumn();
buttonColumn.Text = "Remove";
buttonColumn.AutoSizeMode =
DataGridViewAutoSizeColumnMode.AllCells;
// Use the Text property for the button text for all cells rather
// than using each cell's value as the text for its own button.
buttonColumn.UseColumnTextForButtonValue = true;
// Add the button column to the control.
dataGridView3.Columns.Insert(0, buttonColumn);
//Change remove column to last-child
DataGridViewColumnCollection columnCollection = dataGridView3.Columns;
DataGridViewColumn firstVisibleColumn = columnCollection.GetFirstColumn(DataGridViewElementStates.Visible);
DataGridViewColumn lastVisibleColumn = columnCollection.GetLastColumn(DataGridViewElementStates.Visible, DataGridViewElementStates.None);
int firstColumn_sIndex = firstVisibleColumn.DisplayIndex;
firstVisibleColumn.DisplayIndex = lastVisibleColumn.DisplayIndex;
//lastVisibleColumn.DisplayIndex = firstColumn_sIndex;
}
