Datagrid Column resize - Visual Basic .NET

Jorge

Hello All
I am trying to preserve the width of column in a datagrid
made by the user.

On form load i use this
<code>
Me.DataGrid2.TableStyles("artenc").GridColumnStyle s
(0).Width = 30
Me.DataGrid2.TableStyles("artenc").GridColumnStyle s
(1).Width = 30
Me.DataGrid2.TableStyles("artenc").GridColumnStyle s
(2).Width = 30
</code>
the user then resizes manually the width any columns .
Them after i update the datagrid dataset i want try to
store the current width
<code>
Dim tableStyle As DataGridTableStyle
tableStyle = New DataGridTableStyle
tableStyle.MappingName = "artenc"
Me.DataGrid2.TableStyles.Clear()
Me.DataGrid2.TableStyles.Add(tableStyle)

WidthDatagrid2(0) = Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(0).Width
WidthDatagrid2(1) = Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(1).Width
WidthDatagrid2(2) = Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(2).Width

Console.WriteLine(Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(1).Width)
Console.WriteLine(Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(1).Width)
Console.WriteLine(Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(2).Width)
Console.WriteLine(WidthDatagrid2(0))
Console.WriteLine(WidthDatagrid2(1))
Console.WriteLine(WidthDatagrid2(2))
</code>
all the console display 75 and i sure the width is not
75!?

Any suggestion on how to store the width of datagrid's
column?

Thanks

Kind Regards
Jorge

Nov 21 '05 #1

Subscribe Post Reply

2388

BobAchgill

Jorge,

Did you get this resolved? I could not find the thread
on your discussion to see if anyone answered.

I am interested because I have the same need... both to
set column width and preserve user's changing column
width on datagrids.

Thanks!

Bob Achgill

-----Original Message-----
Hello All
I am trying to preserve the width of column in a datagridmade by the user.

On form load i use this
<code>
Me.DataGrid2.TableStyles("artenc").GridColumnStyle s
(0).Width = 30
Me.DataGrid2.TableStyles("artenc").GridColumnStyle s
(1).Width = 30
Me.DataGrid2.TableStyles("artenc").GridColumnStyle s
(2).Width = 30
</code>
the user then resizes manually the width any columns .
Them after i update the datagrid dataset i want try to
store the current width
<code>
Dim tableStyle As DataGridTableStyle
tableStyle = New DataGridTableStyle
tableStyle.MappingName = "artenc"
Me.DataGrid2.TableStyles.Clear()
Me.DataGrid2.TableStyles.Add(tableStyle)

WidthDatagrid2(0) = Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(0).Width
WidthDatagrid2(1) = Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(1).Width
WidthDatagrid2(2) = Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(2).Width

Console.WriteLine(Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(1).Width)
Console.WriteLine(Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(1).Width)
Console.WriteLine(Me.DataGrid2.TableStyles
("artenc").GridColumnStyles(2).Width)
Console.WriteLine(WidthDatagrid2(0))
Console.WriteLine(WidthDatagrid2(1))
Console.WriteLine(WidthDatagrid2(2))
</code>
all the console display 75 and i sure the width is not
75!?

Any suggestion on how to store the width of datagrid's
column?

Thanks

Kind Regards
Jorge

.

Nov 21 '05 #2

Similar topics

WinForms DataGrid

by: Pietje de kort | last post by:

Hello, why is the System.Windows.Forms.DataGrid so un-customizable? I am trying to build a DataGrid that will resize it's last column when there is room left over (make it fill the total...

C# / C Sharp

Clearing a DataGrid

by: Brad | last post by:

I'm working with a DataGrid in C#, and the user needs to be able add and remove columns from the DataGrid on the fly, without opening and closing the form. The scenario is this. I have a setup...

C# / C Sharp

Using The NativeWindow Class To Draw A GDI Type Circle On Top Of A DataGrid Possibly In The Override OnPaint

by: Richard | last post by:

I have a requirement to put a GDI style circle or rectangle border around the selected row of a datagrid/ It will overlap into the row above and below the selected row. Doing this in a the OnPaint...

C# / C Sharp

Datagrid Column Auto Sizing

by: Brian Mitchell | last post by:

I hate to ask this question because I'm sure it's been asked before, but how do you automatically resize the columns in a datagrid when the form is resized? Thanks!!

Visual Basic .NET

Freeze Column in DataGrid

by: Agnes | last post by:

I understand it is impossible, but still curious to know "Can I freeze several column in the datagrid, the user can only scroll the first 3 columns (not verical), for the rest of the coulumn, it is...

Visual Basic .NET

Datagrid resizing rows on sort - not wanted

by: skOOb33 | last post by:

I successfully autosized the columns and rows on my Datagrid, and am now facing another issue. Having the sorting ability by clicking the column headers is key, but when I do that, it resizes all...

Visual Basic .NET

One line of code not working : susposed to resize datagrid column..

by: garyusenet | last post by:

I'm following a sql/vb tutorial which contains the following code which is meant to resize the datagrid view so that the columns take the correct width for the content within them. It doesn't...

Visual Basic .NET

Disable sort on specific columns with VB.NET datagrid

by: ECD | last post by:

Hello all, I can usually find solutions to my .NET problems by searching these groups, but I'm stumped on this one. I have a datagrid in VB.NET (2.0 framework). I want to disable sorting on...

Visual Basic .NET

2003 Datagrid and beyond

by: cj | last post by:

I was looking over some of my 2003 code today (see below) that loads a foxpro table via oledb connection. I used a sub "autosizecolumns" I found on the web but I never quite understood why they...

Visual Basic .NET

manual resize datagrid column at runtime in asp.net

by: ashinamdev | last post by:

Hi I have a probelm I am using the datagrid control in my asp.net web page. I want to resize the datagrid column at runtime. User can be able to resize the column width according to his...

.NET Framework

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware