Setting Datagrid column width dynamically

[Veeves]

When a datagrid gets populated, if the data is longer than the header text, the column is only wide enough for the data to fit. The grid lines are right up against the data making it difficult to read. is there a way to manipulate the column width at runtime adding some space between the data and grid lines? Veeves

[NeverHeardOfMe]

At design time you can set CellPadding and CellSpacing property of DataGrid - remember, the dataGrid renders its results in an HTML table, and these properties simply translate to those of the table. You can set individual ciolumn widths at runtime using, for example: DataGrid1.Columns(2).ItemStyle.Width = System.Web.UI.WebControls.Unit.Percentage(30) This would change the third column to 30% of the overall width. You could use ...Pixel(100) if you wanted to give it a fixed width of, say, 100 pixels instead. cheers Phil

[Veeves]

Thanks for the response. CellPadding and CellSpacing will increase the height of the row which I don`t want. I could fix the width with percentage or pixels, but with variable length data, this method will only work sometimes. What would be best is if there was a way to convert units to a number type and back. Then I could grab the width of a column, add some units to it and then convert it back. Veeves

[VaibhavJ]

Hi, I think u will have to check for ItemDataBound event of the datagrid for this purpose maybe check if u can get the current column width and then change it there only or adjust the text by inserting
into the string to be bound to that column... I haven't tried this yet...But just thought of sharing this idea... Thanks for reading.. Thanks & regards, Vaibhav