The problem is when the program is run the columns in the datagrid are a set width irrespective of the length of the data in the column, which looks rubbish.

My question is how can i set the column widths of the datagrid, but better still how can i check the length of the data in the column and make the width of the column big enough to accommodate it??

if its not possible with the datagrid then is there a component that i can use with a ADO connection to mySQL database that has this ability?

Any help much appreciated