Help Required with hiding DataColumns

[Chris H.]

Fellow .Netters,

I have come to an impass trying to "hide" a column on a data grid - I'm sure
it's a fairly simple thing (but so am I, that's why I'm stuck)

Imagine if you will that I have a table as structure thus (this is all an
example)

PartID (string)
Part Code (string)
Description (string)
InStock (string)

Now, the PartID field is purely an internal code which has no display value
whatsoever but is needed internally by the system for various other purpose.

My Select statement is simply "Select * from Parts...." and what I want to
do is display all the columns, except the Part ID...but retain the PartID
for other actions required later (as it's in a specific format)

Please put me out of my misery and help me solve this...

Chris....

[Steve]

Chris,

You can find just about everything you ever wanted to know about the WinForms DataGrid here:

http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp

Check out item 5.13 for your specific issue.
http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q708q

hth,
Steve
"Chris H." wrote:

Fellow .Netters,

I have come to an impass trying to "hide" a column on a data grid - I'm sure
it's a fairly simple thing (but so am I, that's why I'm stuck)

Imagine if you will that I have a table as structure thus (this is all an
example)

PartID (string)
Part Code (string)
Description (string)
InStock (string)

Now, the PartID field is purely an internal code which has no display value
whatsoever but is needed internally by the system for various other purpose.

My Select statement is simply "Select * from Parts...." and what I want to
do is display all the columns, except the Part ID...but retain the PartID
for other actions required later (as it's in a specific format)

Please put me out of my misery and help me solve this...

Chris....

[Chris H.]

Thanks....That' s did the job....

"Steve" <St***@discussi ons.microsoft.c om> wrote in message
news:2B******** *************** ***********@mic rosoft.com...

Chris,

You can find just about everything you ever wanted to know about the WinForms DataGrid here:
http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp

Check out item 5.13 for your specific issue.
http://www.syncfusion.com/FAQ/WinFor...c44c.asp#q708q

hth,
Steve
"Chris H." wrote:

Fellow .Netters,

I have come to an impass trying to "hide" a column on a data grid - I'm sure it's a fairly simple thing (but so am I, that's why I'm stuck)

Imagine if you will that I have a table as structure thus (this is all an example)

PartID (string)
Part Code (string)
Description (string)
InStock (string)

Now, the PartID field is purely an internal code which has no display value whatsoever but is needed internally by the system for various other purpose.
My Select statement is simply "Select * from Parts...." and what I want to do is display all the columns, except the Part ID...but retain the PartID for other actions required later (as it's in a specific format)

Please put me out of my misery and help me solve this...

Chris....

[Sean Bright]

Chris:

I know that your question has already been answered so you'll probably
never look here again, but you might try looking at the DataKeys
collection of the DataGrid to solve your problem in the future, rather
than relying on hidden columns.

Basically, when you are databinding, i.e.:

dataGrid1.DataS ource = intentory.GetLi st();
dataGrid1.DataB ind();

Add this before you DataBind() call:

dataGrid1.DataK eyField = "PartID"; // Assuming PartID is serializable

Later, in your ItemCommand event handler, you can just do this:

string partID = dataGrid1.DataK eys[e.Item.ItemInde x].ToString();

To retrieve the PartID. Makes things cleaner if you ask me... but you
didn't! :)

Enjoy,
Sean

Chris H. wrote:

Fellow .Netters,

I have come to an impass trying to "hide" a column on a data grid - I'm sure
it's a fairly simple thing (but so am I, that's why I'm stuck)

Imagine if you will that I have a table as structure thus (this is all an
example)

PartID (string)
Part Code (string)
Description (string)
InStock (string)

Now, the PartID field is purely an internal code which has no display value
whatsoever but is needed internally by the system for various other purpose.

My Select statement is simply "Select * from Parts...." and what I want to
do is display all the columns, except the Part ID...but retain the PartID
for other actions required later (as it's in a specific format)

Please put me out of my misery and help me solve this...

Chris....

[Chris H.]

Thanks Sean.....any advice is good at the moment, I'm still a novice at
this...just have to work out now how to make the grid Non-Edittable with Row
Selection (just a scrolling list that the user selects and then off it goes
and does some stuff....)
"Sean Bright" <se**@noreply.c om> wrote in message
news:gP******** ************@gi ganews.com...

Chris:

I know that your question has already been answered so you'll probably
never look here again, but you might try looking at the DataKeys
collection of the DataGrid to solve your problem in the future, rather
than relying on hidden columns.

Basically, when you are databinding, i.e.:

dataGrid1.DataS ource = intentory.GetLi st();
dataGrid1.DataB ind();

Add this before you DataBind() call:

dataGrid1.DataK eyField = "PartID"; // Assuming PartID is serializable

Later, in your ItemCommand event handler, you can just do this:

string partID = dataGrid1.DataK eys[e.Item.ItemInde x].ToString();

To retrieve the PartID. Makes things cleaner if you ask me... but you
didn't! :)

Enjoy,
Sean

Chris H. wrote:

Fellow .Netters,

I have come to an impass trying to "hide" a column on a data grid - I'm sure it's a fairly simple thing (but so am I, that's why I'm stuck)

Imagine if you will that I have a table as structure thus (this is all an example)

PartID (string)
Part Code (string)
Description (string)
InStock (string)

Now, the PartID field is purely an internal code which has no display value whatsoever but is needed internally by the system for various other purpose.
My Select statement is simply "Select * from Parts...." and what I want to do is display all the columns, except the Part ID...but retain the PartID for other actions required later (as it's in a specific format)

Please put me out of my misery and help me solve this...

Chris....