connelvalentine
asked on
VB.NET - Dynamically adjusting column widths in datagrid
Hi,
I'm creating an application in VB.NET. I've created a datagrid to display records from my database.
This datagrid will actually be showing data from different tables, depending on table the user wishes to view, so i'm creating and configuring the data adapter and dataset via code and then refreshing the datagrid.
I have a function which runs every time a user selects to display a table on the datagrid. It's a simple function that dynamically creates the datagridtextcolumns based on the number of columns in the table in the dataset. So far, the program works well.
However, the only part i'm having a problem with is the column width. I need to dynamically be able to adjust the width of the colum for each datagridtextcolumn, to fit the longest entry in that column. Any ideas on how this can be accomplished?
Best Regards,
CV.
I'm creating an application in VB.NET. I've created a datagrid to display records from my database.
This datagrid will actually be showing data from different tables, depending on table the user wishes to view, so i'm creating and configuring the data adapter and dataset via code and then refreshing the datagrid.
I have a function which runs every time a user selects to display a table on the datagrid. It's a simple function that dynamically creates the datagridtextcolumns based on the number of columns in the table in the dataset. So far, the program works well.
However, the only part i'm having a problem with is the column width. I need to dynamically be able to adjust the width of the colum for each datagridtextcolumn, to fit the longest entry in that column. Any ideas on how this can be accomplished?
Best Regards,
CV.
ASKER
HI hatem72,
Unfortunately, i'm still using VB.NET 2002.
I understand that the datagridview control has replaced the datagrid control in later versions of VB.NET. I'm looking for a solution that will work with just a datagrid control.
OR, i'm even open to any suggestions on how it can be possible to use the datagridview control in the VB.NET version i have. If this is possible, will i have to take any precautions while distributing my application later?
Best Regards,
CV
Unfortunately, i'm still using VB.NET 2002.
I understand that the datagridview control has replaced the datagrid control in later versions of VB.NET. I'm looking for a solution that will work with just a datagrid control.
OR, i'm even open to any suggestions on how it can be possible to use the datagridview control in the VB.NET version i have. If this is possible, will i have to take any precautions while distributing my application later?
Best Regards,
CV
For datagrid net 1.1 check this solution
http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q877q
vbturbo
http://www.syncfusion.com/FAQ/WindowsForms/FAQ_c44c.aspx#q877q
vbturbo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Hatem72,
This solution almost seems to be working from the dotnet247 link, but i'm having some problems understanding the code to tweak it a bit:
Dim size As SizeF
Dim sf As StringFormat = New StringFormat(StringFormat.
size = g.MeasureString(dtgr_datab
This is just a small snippet i've taken out from the code. Could you please explain what these lines of code mean? They're pretty greek to me and the VS help wasn't too helpful.
BR,
CV.
This solution almost seems to be working from the dotnet247 link, but i'm having some problems understanding the code to tweak it a bit:
Dim size As SizeF
Dim sf As StringFormat = New StringFormat(StringFormat.
size = g.MeasureString(dtgr_datab
This is just a small snippet i've taken out from the code. Could you please explain what these lines of code mean? They're pretty greek to me and the VS help wasn't too helpful.
BR,
CV.
Hi,
First thanx for [B] ... about that code snippet ... it's search result & i am working
with vb 2005 ... i am sory ... BUT good thing that snippet [almost seems to be working ] .
First thanx for [B] ... about that code snippet ... it's search result & i am working
with vb 2005 ... i am sory ... BUT good thing that snippet [almost seems to be working ] .
http://msdn2.microsoft.com/en-us/library/fd004dhd.aspx