Column Resizing in Data Grid

[alibinjamil]

I am populating data from data base into a data grid. What I want is that the column resize them selves according to the length of the data that they get from the data base. Please do let me know if there is a way I can do this. Some thing like Autoresizing for the data grid.

 

Thanks

[Mehyar]

I dont think so.......

 

You have to specify the column widths yourself using a tablestyle.

[donnacha]

You might try the following .

If you create your own class and inherit DataGridTextBoxColumn, then overide the paint method and in this work out the length of the text in the cell and if it exceeds the column width then increase the column width appropriately. I think you can get at it in the paint method using Me.DataGridTableStyle.GridColumnStyles(0).Width.

 

Try and see if it works.

[ballisticnylon]

You could use the MeasureString method of a graphics object to get the pixel width of each entry in the column, and then compare that to the column's width.

Dim G as Graphics = me.CreateGraphics
Dim str as String = "abcdefg"  '<-- example string
Dim pixelWidth as Integer = G.MeasureString(str, me.font).Width
If Column.Width <= pixelWidth Then Column.Width = pixelwidth
G.Dispose

I didn't actually thy this, but it might work.