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; }
private void FormatGrid() { dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; DataGridViewColumnCollection columnCollection = dataGridView1.Columns; DataGridViewColumn lastVisibleColumn = columnCollection.GetLastColumn( DataGridViewElementStates.Visible, DataGridViewElementStates.None); if (lastVisibleColumn != null) { lastVisibleColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } }
//</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; }