Data Presentation Controls

Re: gridview column w/visible=false no longer contains cell data in beta 2

mrdindar — Wed, 15 Jul 2009 09:50:53 GMT

I think you guys take it for granted how to use Datakeys , But i didn't know and i had to find it .

So i though that would be useful for others like me that don't know how to use Datakeys specially when we have more than one Datakeys

//In GridView RowCommand Evens:

index = Convert.ToInt32(e.CommandArgument);
row = gvCommonData.Rows[index];
//If we have more than one DataKeys ( ItemId is the field that is visbile = false and myGridView.DatakeyName = Itemid)
int ItemId = Convert.ToInt32(gvCommonData.DataKeys[index].Values["ItemId"]);

//else
int ItemId = Convert.ToInt32(gvCommonData.DataKeys[index].Value);

Re: gridview column w/visible=false no longer contains cell data in beta 2

vasireddybharath — Wed, 15 Oct 2008 14:01:26 GMT

Hi,

i want to hide my table column at the server side. But I am unable to hide it. I am using style="table-layout:fixed;" for the table and on the pageload i am setting the visible=false for the first row of the table and the column which I want to hide.

Thanks

Re: gridview column w/visible=false no longer contains cell data in beta 2

fontecir — Sat, 22 Mar 2008 00:44:49 GMT

I have the following gridview, same request: I need the value of the hyperlinked text or the value of the hidden column (Filename). When I use DataKeys I only get the FileID. Thank you

<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False"
                    DataKeyNames="FileID,FileName" DataSourceID="FileListDataSource" AllowPaging="True" PageSize="6">
                    <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <RowStyle BackColor="#EFF3FB" />
                    <Columns>
                        <asp:HyperLinkField DataNavigateUrlFields="FileName"
                            DataNavigateUrlFormatString="{0}" DataTextField="FileName"
                            HeaderText="View File" />
                        <asp:BoundField DataField="FileName" HeaderText="FileName"
                            SortExpression="FileName" Visible="False" />
                        <asp:TemplateField ShowHeader="False">
                            <ItemTemplate>
                                <asp:LinkButton ID="lnkDeleteFile" runat="server" CausesValidation="False"
                                    CommandName="Delete" onclick="lnkDeleteFile_Click"
                                    onclientclick="JavaScript:return confirm('Are you sure?')" Text="Delete"></asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <EditRowStyle BackColor="#2461BF" />
                    <AlternatingRowStyle BackColor="White" />
                </asp:GridView>

Re: gridview column w/visible=false no longer contains cell data in beta 2

fontecir — Sat, 22 Mar 2008 00:44:16 GMT

Re: gridview column w/visible=false no longer contains cell data in beta 2

berkx — Tue, 26 Feb 2008 03:36:12 GMT

Hi,

Here's the link to resolve this problem..

http://www.thescripts.com/forum/thread471276.html

try also this one..

http://codeproject.wordpress.com/2007/10/24/gridview-hidden-fieldhow-to-get-hidden-field-value-in-gridviewdatakeys/

Re: gridview column w/visible=false no longer contains cell data in beta 2

hasek — Mon, 04 Feb 2008 17:19:07 GMT

hello

I had the same problem that you have and I found this solution . It might not be the best but it works :)

1.make all fields visible in GridView

than in the runtime on event gridview_RowDataBound set the field that you want to visible =false;

Re: gridview column w/visible=false no longer contains cell data in beta 2

pepone — Fri, 31 Aug 2007 10:36:18 GMT

gridView.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString()

Re: gridview column w/visible=false no longer contains cell data in beta 2

sisieko — Tue, 24 Apr 2007 20:40:15 GMT

I found answers in this thread very helpful. Thanks all :)

Re: gridview column w/visible=false no longer contains cell data in beta 2

JohanNL — Fri, 15 Dec 2006 10:08:19 GMT

Hi all,

If use the following code to loop through certain rows of the GridView

For Each gvr As GridViewRow In GridView1.Rows

	'Programmatically access the CheckBox from the TemplateField
	Dim cb As CheckBox = CType(gvr.FindControl("RowLevelCheckBox"), CheckBox)

	'If it's checked, show control
	If cb.Checked Then
		currentRowIndex = gvr.RowIndex.ToString()

		ShowControls(TODO, gvr.Cells(0).Text, gvr.Cells(1).Text, CType(gvr.Cells(2).Text, Integer), CType(gvr.Cells(3).Text, Integer))

	End If
Next

In the TODO spot I want the value of the DataKeyNames="CONTROL_ID"

How do I do this?

Re: gridview column w/visible=false no longer contains cell data in beta 2

matthewwebster — Mon, 10 Jul 2006 23:01:24 GMT

this should help- the easy way to get datakeys

if you're not using them, try creating some (even if just from the index of a basic array):

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        int index = Int32.Parse(e.CommandArgument.ToString());
        int pk = Int32.Parse(GridView1.DataKeys[ index ].Value.ToString());
    }

Re: gridview column w/visible=false no longer contains cell data in beta 2

haha345 — Tue, 04 Jul 2006 13:13:06 GMT

What if my datasource is just an array? How do I use datakeynames and datakey?

Re: gridview column w/visible=false no longer contains cell data in beta 2

columba — Wed, 12 Apr 2006 16:05:15 GMT

Ade's posted VB response worked a treat. Assuming you've got the viewstate switched on already.

Nothing like a coded example to make things clear.

Re: gridview column w/visible=false no longer contains cell data in beta 2

DevonS — Sun, 19 Mar 2006 20:55:44 GMT

Ok, you can ignore my previous post . If you call grid.DataBind() after paging the key values are there. I wasn't seeing both keys in my previous example because I added the additional key name while debugging and the browser had stuff cached in control state, yadda yadda yadda, so I reset IIS, Rebuilt my project and voila, there everything is. This was, of course after I realized I really don't need both keys anyway. Duh.!

Re: gridview column w/visible=false no longer contains cell data in beta 2

DevonS — Sun, 19 Mar 2006 20:22:09 GMT

phuff wrote:
The bug was that we cleared out the data keys when not bound to a data source control when handling the paging event. You can work around the issue by handing the RowCommand event. If the CommandName is "Page", it's a paging event. The DataKeys property should still be populated in the RowCommand event. Or, you can wait until after you're done paging and call DataBind. In the OnDataBound event, you can retrieve the key values.

So, I'm confused and dissapointed.... If you're not using a datasource control and have some paging the datakeynames is pretty much useless? Like the one guy posted, I have a tiered application and I'm binding to a datatable within a dataset. I need to be able to access two keys in my data, which I though the nice new datakeynames deal was supposed to be for. I can get the first value just fine, but the second value isn't even in the array. So it looks like this:

In the ascx, grid has DataKeyNames="DtlKey, GrpKey" GrpKey comes out fine

In the .cs, I set grid.DataSource = theDataset.Table; and call grid.DataBind()

In a _RowEditing event I use:

Guid tGrpID = new Guid(grd.DataKeys[e.NewEditIndex].Values["GrpKey"].ToString());

Guid tDtlID = new Guid(grd.DataKeys[e.NewEditIndex].Values["DtlKey"].ToString());

GrpKey comes out fine, but DtlKey always blows. What the hell?

Re: gridview column w/visible=false no longer contains cell data in beta 2

HiralKanaiya — Mon, 13 Mar 2006 04:13:43 GMT

I am trying to do the same thing.

I have first three boundfields in gridview set invisible and then i would like to retrieve these values on row command but it returns null.

can you please send me something in vb.net and explain how does this work. I am really confuse on this one why it forces me to keep everything visible if i want to access value of it later on.

thanks,

Hiral