How to set Gridview Column width as per database field width?

Question

I am new to windows desktop application development.

I have a grid in which I am displaying list of customers whose bills are printed.

The form looks like this.

The grid in this form displays the list of all customers and it is bounded in the Form_Load() my code is :

private void SearchForm_Load(object sender, EventArgs e)
{   
    cn = db.createConnection();
    if (cn.State == System.Data.ConnectionState.Open)
        cn.Close();
    cn.Open();
    cmd = new OleDbCommand("Select BillNo,PartyName,Address,City,State,BillDt from BillMaster", cn);
    da = new OleDbDataAdapter(cmd);
    ds = new DataSet();
    da.Fill(ds);
    cn.Close();
    dataGridView1.DataSource = ds.Tables[0];
    ds.Dispose();
}

But the width of the PartyName field is too short to read the full name. I want to customize the size of the all fields. How to do so?

Please help.

Do you want the width the be dynamic ? i.e. to match longest string ? — Ofiris, Apr 15 '13 at 14:39
Ok, check my answer and have a look in http://stackoverflow.com/questions/1025670/how-do-you-automatically-resize-columns-in-a-datagridview-control-and-allow-the for more options. — Ofiris, Apr 15 '13 at 14:49

Ofiris · Answer 1 · 2013-04-15T14:48:07.900

2

AutoResizeColumns is what you looking for.

dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;

AllCells - The column width adjusts to fit the contents of all cells in the column, including the header cell.

Also, have a look in DataGridViewAutoSizeColumnMode Enumeration

edited Apr 15 '13 at 14:48

answered Apr 15 '13 at 14:42

Ofiris

6,047
6
35
58

Sir, can. U privide some code plzzz. Coz I actually dont know how to implement. As per my application – Mohemmad K Apr 15 '13 at 16:37
Add the first line where `dataGridView1 `is initialized. – Ofiris Apr 15 '13 at 16:38
Sir, I have placed the grid view at design time without any column specified. Will it be useful for that or I have to create an object of the grid in my code??? – Mohemmad K Apr 15 '13 at 18:56
I tried creating the grid in my C# code. But also not working. Gives output as before. @Ofiris – Mohemmad K Apr 15 '13 at 19:02
Set it in the dgv properties – Ofiris Apr 15 '13 at 19:15

How to set Gridview Column width as per database field width?

1 Answers1