Making DG Column Visible = False 1

[jfrost10]

Hey guys,

I'm working on the search functionality of our member portal. The result datagrid's columns dynamically change depending on what entity the user is searching on. The problem I'm having is that the first column after the button column needs to be invisible because it holds the record's ID. I tried this:

dgResults.DataSource = objSU.GetSearchResults(strSQL)
dgResults.DataBind()
dgResults.Columns(1).Visible = False

But that didn't work, and trying this:

dgResults.DataSource = objSU.GetSearchResults(strSQL)
dgResults.Columns(1).Visible = False
dgResults.DataBind()

produced an error.

So then I thought: I'll just add a column through code, but the DataGridColumn object doesn't seem to have a DataField property.

Any thoughts on how I could get this working?

Thanks,

D

 

[Zarcom]

Hey Jack check out this thread. The guy there seems to have gotten the column hidden but was having problems with it.

thread855-378526 That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[jfrost10]

Thanks Mark.

His problem is a bit different though:
he mentions that both columns are bound columns, whereas mine aren't; they all get created dynamically.

D

 

[link9]

So when you say that they get created dynamically, do you mean that you specifically create each column at run-time, or do you let your datagrid create its own columns based on the sql statement you pass there?

 

[jfrost10]

I'm letting my datagrid create its own columns based on dataset returned from my sql statement.

but what I'd LIKE to do is create the columns at run time (which would give me total control over how the data is shown).

btw, thanks again for that tip on disabling the back button a few posts ago. Just got around to implementing it, and it works like a charm.

D

 

[link9]

Your welcome on that tip. I love the simplicity of it.

Anyway, as for your question, I'm afraid you're going to have to create your own columns, because when you let the datagrid create its own, you give up the control to hide/show them (among other things).

Should be pretty simple... just loop through the columns of your datasource, setting the properties on each datagrid column as you go, and then .dataBind()

Should be a bit tedious, but easy, nonetheless.

 

[jfrost10]

see thats what I thought, but its borderline frustrating more than anything else:

For some reason I can't find where the DataField property of a datagrid column is. Its not at the first level, as i would have thought it was, and there's nothing really obvious in the next level that would point to where it is either. So I can add columns in the code, I just can't tell it what fields i want bound to which columns.

D

 

[link9]

http://www.123aspx.com/resdetail.aspx?res=893

 

[jfrost10]

Ah, BoundColumn, not just a column...never even crossed my mind.

Thanks Paul, you the man.

D