datagrid size issue - any ideas ?

[Stuart]

Hi there

I have a datagrid in my application that can vary in width dramtically, this
is due to the number of visible columns which is controlled programatically
and can vary from day to day.

For ease of use, there is an id (basically a name) column in position 1 of
the datagrid, I would like to know if I can add another column, with the same
value, to the end position if the datagrid is wider than the screen. I can of
course take a guess and say, if x number of columns are visible then add the
mirrored column on the end, but would like to be a little more scientific
about it if I can.

Any ideas would be much appreciated.

Thanks, Stuart

[Cowboy (Gregory A. Beamer) - MVP]

The question is whether or not this is a requirement or a "nice to have"
feature, as you can spend a lot of time to really do it right.

Questions to answer:

1. How wide is each column as shown on screen (varchar can be thin or wide
in your dataset)?
2. What is the user's resolution set to?
3. Does user have large fonts or other assessibility turned on?

This is what I can think of off hand.

The point: You are either going to have to wing it or figure out exactly.

NOTE: For #1, you may have to completely walk the data to determine the
longest (with varchars). For #2, you are best to use JavaScript and send back
to the server (combination client and server script). I am not certain of how
to best determine assessibility features, so you may forget this.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"Stuart" wrote:

Hi there

I have a datagrid in my application that can vary in width dramtically, this
is due to the number of visible columns which is controlled programatically
and can vary from day to day.

For ease of use, there is an id (basically a name) column in position 1 of
the datagrid, I would like to know if I can add another column, with the same
value, to the end position if the datagrid is wider than the screen. I can of
course take a guess and say, if x number of columns are visible then add the
mirrored column on the end, but would like to be a little more scientific
about it if I can.

Any ideas would be much appreciated.

Thanks, Stuart

[Stuart]

Thanks very much - under these circumstances.... "nice to have" - I think
I'll wing it !

"Cowboy (Gregory A. Beamer) - MVP" wrote:

The question is whether or not this is a requirement or a "nice to have"
feature, as you can spend a lot of time to really do it right.

Questions to answer:

1. How wide is each column as shown on screen (varchar can be thin or wide
in your dataset)?
2. What is the user's resolution set to?
3. Does user have large fonts or other assessibility turned on?

This is what I can think of off hand.

The point: You are either going to have to wing it or figure out exactly.

NOTE: For #1, you may have to completely walk the data to determine the
longest (with varchars). For #2, you are best to use JavaScript and send back
to the server (combination client and server script). I am not certain of how
to best determine assessibility features, so you may forget this.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
"Stuart" wrote:

Hi there

I have a datagrid in my application that can vary in width dramtically, this
is due to the number of visible columns which is controlled programatically
and can vary from day to day.

For ease of use, there is an id (basically a name) column in position 1 of
the datagrid, I would like to know if I can add another column, with the same
value, to the end position if the datagrid is wider than the screen. I can of
course take a guess and say, if x number of columns are visible then add the
mirrored column on the end, but would like to be a little more scientific
about it if I can.

Any ideas would be much appreciated.

Thanks, Stuart