Hi

I have a hidden (visible=false) column on a gridview bound to a sql server
table. I am trying to access the field as;

For Each row As GridViewRow In grdEvents.Rows
If row.RowType = DataControlRowType.DataRow Then
bf = CType(row.Cells(row.Cells.Count - 1).FindControl("event id"),
BoundField)
End if
Next

but I get the 'System.Web.UI.Control' cannot be converted to
System.Web.UI.WebControls.BoundField' error. When I try to access it using
row.Cells(12).Text then it returns a blank value.

How can I access the relevant gridview column?

Thanks

Regards

"John" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> I have a hidden (visible=false) column on a gridview bound to a sql server
> table. I am trying to access the field as;
>
> For Each row As GridViewRow In grdEvents.Rows
> If row.RowType = DataControlRowType.DataRow Then
> bf = CType(row.Cells(row.Cells.Count - 1).FindControl("event id"),
> BoundField)
> End if
> Next
>
> but I get the 'System.Web.UI.Control' cannot be converted to
> System.Web.UI.WebControls.BoundField' error.

Hmm - not precisely certain what you're trying to do here... Clearly, you
don't actually need to convert a column into a BoundField or anything else
just to interrogate its contents...

> When I try to access it using row.Cells(12).Text then it returns a blank
> value.

Sounds like you've discovered one of the new features of GridViews, whereby
hidden columns are not saved in ViewState by default...

> How can I access the relevant gridview column?

Set the column Visible = True immediately before calling the GridView's
DataBind method, then set it Visible = False immediately afterwards...

Hi

I have used the 'Configure Data Source' to bind the gridview. Where would I
find the databind method in this case?

Thanks

Regards

"Mark Rae" <(E-Mail Removed)> wrote in message
news:e$(E-Mail Removed)...
> "John" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>
>> How can I access the relevant gridview column?
>
> Set the column Visible = True immediately before calling the GridView's
> DataBind method, then set it Visible = False immediately afterwards...
>

Hello John,

I am guessing you used an ObjectDataSource control to act as a
datasource for the gridview? Check the following:

The DataSourceID property of the gridview is set to that of the
objectdatasource.
WHen you call DataBind() on the gridview, the SelectMethod of the
objectdatasource is implicitly called.

John wrote:
> Hi
>
> I have used the 'Configure Data Source' to bind the gridview. Where would I
> find the databind method in this case?
>
> Thanks
>
> Regards
>
> "Mark Rae" <(E-Mail Removed)> wrote in message
> news:e$(E-Mail Removed)...
> > "John" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >
> >
> >> How can I access the relevant gridview column?
> >
> > Set the column Visible = True immediately before calling the GridView's
> > DataBind method, then set it Visible = False immediately afterwards...
> >