Visual Studio 2005 / FX 2.0

I've got a datagrid which is bound to a BindingSource, pretty standard
stuff. Basically the grid is populated with every column from the underlying
table. I've got some columns marked as invisible, however the primary key
column keeps showing up. The best I can do is set this to width 5, but this
isn't what I want. Why can't I get this column to be invisible?

Thanks!

- Joe Geretz -

I think I read this same problem in a posting a while back.
Try putting all the columns that are going to be invisible
*together*. No promises, but it's free to try it.

Robin S.
-------------------------
"Joseph Geretz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Visual Studio 2005 / FX 2.0
>
> I've got a datagrid which is bound to a BindingSource, pretty standard
> stuff. Basically the grid is populated with every column from the
> underlying table. I've got some columns marked as invisible, however
> the primary key column keeps showing up. The best I can do is set this
> to width 5, but this isn't what I want. Why can't I get this column to
> be invisible?
>
> Thanks!
>
> - Joe Geretz -
>

Here is what I found in your stocking today:

Probably the easiest technique is to set MappingType to Hidden on either the
dataset or the datatable BEFORE binding to the grid:

ds.YourTable.YourIDColumn.ColumnMapping = MappingType.Hidden;
-OR-

dt.Columns["YourID"].ColumnMapping = MappingType.Hidden;

"Joseph Geretz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Visual Studio 2005 / FX 2.0
>
> I've got a datagrid which is bound to a BindingSource, pretty standard
> stuff. Basically the grid is populated with every column from the
> underlying table. I've got some columns marked as invisible, however the
> primary key column keeps showing up. The best I can do is set this to
> width 5, but this isn't what I want. Why can't I get this column to be
> invisible?
>
> Thanks!
>
> - Joe Geretz -
>

Thanks guys for your responses.

I played around with this a bit. It seems that the *first* column in the
grid can't be rendered invisible? Does that sound up to spec? I found that
simply shifting the column down to the second position caused it to go
invisible as defined. Then I tried to make the new column in the number one
position invisible, and found that it wouldn't cooperate.

Is this the defined behavior? Grid column #1 must be visible? In any case,
easy enough to work around.

Thanks,

- Joe Geretz -

"Joseph Geretz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Visual Studio 2005 / FX 2.0
>
> I've got a datagrid which is bound to a BindingSource, pretty standard
> stuff. Basically the grid is populated with every column from the
> underlying table. I've got some columns marked as invisible, however the
> primary key column keeps showing up. The best I can do is set this to
> width 5, but this isn't what I want. Why can't I get this column to be
> invisible?
>
> Thanks!
>
> - Joe Geretz -
>

Nope, it should not work that way. If you hide the column in the table, it
should not appear anywhere. If you are still showing columns after using the
MappingType.Hidden, that would tell me that you are doing a binding before
you set the Hidden property.

"Joseph Geretz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks guys for your responses.
>
> I played around with this a bit. It seems that the *first* column in the
> grid can't be rendered invisible? Does that sound up to spec? I found that
> simply shifting the column down to the second position caused it to go
> invisible as defined. Then I tried to make the new column in the number
> one position invisible, and found that it wouldn't cooperate.
>
> Is this the defined behavior? Grid column #1 must be visible? In any case,
> easy enough to work around.
>
> Thanks,
>
> - Joe Geretz -
>
> "Joseph Geretz" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Visual Studio 2005 / FX 2.0
>>
>> I've got a datagrid which is bound to a BindingSource, pretty standard
>> stuff. Basically the grid is populated with every column from the
>> underlying table. I've got some columns marked as invisible, however the
>> primary key column keeps showing up. The best I can do is set this to
>> width 5, but this isn't what I want. Why can't I get this column to be
>> invisible?
>>
>> Thanks!
>>
>> - Joe Geretz -
>>
>
>

Hi Earl,

What do you mean when you say 'hide the column in the table'? I'm not hiding
the column in the table; I'm setting Visible=False in the corresponding
column in the bound Grid.

Thanks,

- Joe Geretz -

"Earl" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Nope, it should not work that way. If you hide the column in the table, it
> should not appear anywhere. If you are still showing columns after using
> the MappingType.Hidden, that would tell me that you are doing a binding
> before you set the Hidden property.
>
> "Joseph Geretz" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Thanks guys for your responses.
>>
>> I played around with this a bit. It seems that the *first* column in the
>> grid can't be rendered invisible? Does that sound up to spec? I found
>> that simply shifting the column down to the second position caused it to
>> go invisible as defined. Then I tried to make the new column in the
>> number one position invisible, and found that it wouldn't cooperate.
>>
>> Is this the defined behavior? Grid column #1 must be visible? In any
>> case, easy enough to work around.
>>
>> Thanks,
>>
>> - Joe Geretz -
>>
>> "Joseph Geretz" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Visual Studio 2005 / FX 2.0
>>>
>>> I've got a datagrid which is bound to a BindingSource, pretty standard
>>> stuff. Basically the grid is populated with every column from the
>>> underlying table. I've got some columns marked as invisible, however the
>>> primary key column keeps showing up. The best I can do is set this to
>>> width 5, but this isn't what I want. Why can't I get this column to be
>>> invisible?
>>>
>>> Thanks!
>>>
>>> - Joe Geretz -
>>>
>>
>>
>
>

As I noted in the earlier post, I'm referring to using MappingType.Hidden.
This allows you to hide the column on the dataset or datatable so it does
not appear when you bind the source to the grid.

"Joseph Geretz" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Earl,
>
> What do you mean when you say 'hide the column in the table'? I'm not
> hiding the column in the table; I'm setting Visible=False in the
> corresponding column in the bound Grid.
>
> Thanks,
>
> - Joe Geretz -
>
> "Earl" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Nope, it should not work that way. If you hide the column in the table,
>> it should not appear anywhere. If you are still showing columns after
>> using the MappingType.Hidden, that would tell me that you are doing a
>> binding before you set the Hidden property.
>>
>> "Joseph Geretz" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Thanks guys for your responses.
>>>
>>> I played around with this a bit. It seems that the *first* column in the
>>> grid can't be rendered invisible? Does that sound up to spec? I found
>>> that simply shifting the column down to the second position caused it to
>>> go invisible as defined. Then I tried to make the new column in the
>>> number one position invisible, and found that it wouldn't cooperate.
>>>
>>> Is this the defined behavior? Grid column #1 must be visible? In any
>>> case, easy enough to work around.
>>>
>>> Thanks,
>>>
>>> - Joe Geretz -
>>>
>>> "Joseph Geretz" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> Visual Studio 2005 / FX 2.0
>>>>
>>>> I've got a datagrid which is bound to a BindingSource, pretty standard
>>>> stuff. Basically the grid is populated with every column from the
>>>> underlying table. I've got some columns marked as invisible, however
>>>> the primary key column keeps showing up. The best I can do is set this
>>>> to width 5, but this isn't what I want. Why can't I get this column to
>>>> be invisible?
>>>>
>>>> Thanks!
>>>>
>>>> - Joe Geretz -
>>>>
>>>
>>>
>>
>>
>
>