Datagridview как изменить размер столбца

I have created a database and table using Visual Studio’s SQL Server Compact 3.5 with a dataset as my datasource. On my WinForm I have a DataGridView with 3 columns. However, I have been unable to figure out how to get the columns to take up the full width of the DataGridView which is shown in the image below.

I want to make the abbreviates column wider and then have the description column extend all the way over to the edge of the form. Any suggestions?

Update:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace QuickNote
{
public partial class hyperTextForm : Form
{
    private static hyperTextForm instance;

    public hyperTextForm()
    {
        InitializeComponent();
        this.WindowState = FormWindowState.Normal;
        this.MdiParent = Application.OpenForms.OfType<Form1>().First();            
    }

    public static hyperTextForm GetInstance()
    {
        if (instance == null || instance.IsDisposed)
        {
            instance = new hyperTextForm();
        }

        return instance;
    }

    private void abbreviationsBindingNavigatorSaveItem_Click(object sender, EventArgs e)
    {
        this.Validate();
        this.abbreviationsBindingSource.EndEdit();
        this.tableAdapterManager.UpdateAll(this.keywordDBDataSet);
    }

    private void hyperTextForm_Load(object sender, EventArgs e)
    {
        // TODO: This line of code loads data into the 'keywordDBDataSet.abbreviations' table. You can move, or remove it, as needed.
        this.abbreviationsTableAdapter.Fill(this.keywordDBDataSet.abbreviations);
        abbreviationsDataGridView.Columns[1].Width = 60;
        abbreviationsDataGridView.Columns[2].Width = abbreviationsDataGridView.Width - abbreviationsDataGridView.Columns[0].Width - abbreviationsDataGridView.Columns[1].Width - 72;
    }
}
}

asked Aug 12, 2012 at 23:01

dataGridView1.Columns[1].Width = 108;  // or whatever width works well for abbrev
dataGridView1.Columns[2].Width = 
    dataGridView1.Width 
    - dataGridView1.Columns[0].Width 
    - dataGridView1.Columns[1].Width 
    - 72;  // this is an extra "margin" number of pixels

6

In my Visual Studio 2019 it worked only after I set the AutoSizeColumnsMode property to None.

I have created data grid view like this:

I want to change the column width. What should I do?
Should I change the code in designer.cs or just in .cs?

Update:

private void sqlConnStaff()
    {
        BindingSource dbBindSource = new BindingSource();

        SqlCommand com;
        com = new SqlCommand();
        SqlConnection con = new SqlConnection(strCon);

        com.Connection = con;
        com.CommandType = CommandType.StoredProcedure;
        com.CommandText = "view_staff";

        SqlDataAdapter dataAdapter = new SqlDataAdapter(com);

        IDCabang = new SqlParameter();
        IDCabang.SqlDbType = SqlDbType.VarChar;
        IDCabang.Size = 5;
        IDCabang.ParameterName = "@IDCabang";
        IDCabang.Value = IDCabangC;
        IDCabang.Direction = ParameterDirection.Input;

        com.Parameters.Add(IDCabang);

        con.Open();

        DataTable table = new DataTable();
        table.Locale = System.Globalization.CultureInfo.InvariantCulture;
        dataAdapter.Fill(table);
        dbBindSource.DataSource = table;

        dataGridView3.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
        // you can make it grid readonly.
        dataGridView3.ReadOnly = true;
        // finally bind the data to the grid
        dataGridView3.DataSource = dbBindSource;

        con.Close();
    }

asked May 14, 2013 at 10:13

dataGridView1.Columns[0].Width = 200;

8

DataGridViewColumn firstcolumn = dataGridView1.Columns[0];
column.Width = 150;

0

You can change it in designer: click on DataGridView then on this small arrow in upper right corner of gird and go Edit Columns -> Select Column -> Width default is 100.

I have created data grid view like this:

I want to change the column width. What should I do?
Should I change the code in designer.cs or just in .cs?

Update:

private void sqlConnStaff()
    {
        BindingSource dbBindSource = new BindingSource();

        SqlCommand com;
        com = new SqlCommand();
        SqlConnection con = new SqlConnection(strCon);

        com.Connection = con;
        com.CommandType = CommandType.StoredProcedure;
        com.CommandText = "view_staff";

        SqlDataAdapter dataAdapter = new SqlDataAdapter(com);

        IDCabang = new SqlParameter();
        IDCabang.SqlDbType = SqlDbType.VarChar;
        IDCabang.Size = 5;
        IDCabang.ParameterName = "@IDCabang";
        IDCabang.Value = IDCabangC;
        IDCabang.Direction = ParameterDirection.Input;

        com.Parameters.Add(IDCabang);

        con.Open();

        DataTable table = new DataTable();
        table.Locale = System.Globalization.CultureInfo.InvariantCulture;
        dataAdapter.Fill(table);
        dbBindSource.DataSource = table;

        dataGridView3.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
        // you can make it grid readonly.
        dataGridView3.ReadOnly = true;
        // finally bind the data to the grid
        dataGridView3.DataSource = dbBindSource;

        con.Close();
    }

asked May 14, 2013 at 10:13

dataGridView1.Columns[0].Width = 200;

8

DataGridViewColumn firstcolumn = dataGridView1.Columns[0];
column.Width = 150;

0

You can change it in designer: click on DataGridView then on this small arrow in upper right corner of gird and go Edit Columns -> Select Column -> Width default is 100.

Ответы

• После заполнения таблицы можно выполнить что-то вроде:

  DataGridView1.Columns(0).Width = 50
  DataGridView1.Columns(1).AutoSizeMode = DataGridViewAutoSizeColumnsMode.Fill
  

  либо обрабатывать событие
  ColumnAdded (я бы выбрал этот вариант для простых или временных приложений), либо создать преднастроенные столбцы с заданным свойством Width в дизайнере и отключить автосоздание столбцов (я бы выбрал этот вариант в общем случае для всех остальных приложений).

  • Предложено в качестве ответа
    Naomi N
    20 февраля 2011 г. 18:09
  • Помечено в качестве ответа
    Abolmasov Dmitry
    20 февраля 2011 г. 23:18