Hi I want to get the values from the Invisible rows from my gridview here is my code ltaspGridView ID34gvTeam34 runat34server34 Width34900px34 AutoGenerateColumns34False34 BackColor34White34 BorderColor34CC996634 BorderStyle34None34 BorderWidth341px34 CellPadding34434gt ltColumnsgt ltaspBoundField DataField34FULLNAME34 HeaderText

If you want to get the names of columns which are set to visible false Then you can make your GridView like this Use TemplateField and set it to visible falseltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34false34gt ltColumnsgt ltaspBoundField DataField34FULLNAME34 HeaderText34NAME34 gt ltaspTemplateField HeaderText34EVALUATION34 Visible34false34gt ltItemTemplategt ltaspLabel ID34lblEvalution34 runat34server34 Text39lt Eval34EVALUATION34 gt39 gt ltItemTemplategt ltaspTemplateFieldgt ltaspTemplateField HeaderText34BRS34 Visible34false34gt ltItemTemplategt ltaspLabel ID34lblBRS34 runat34server34 Text39lt Eval34BRS34

This WayltDOCTYPE html PUBLIC 34W3CDTD XHTML 10 TransitionalEN34 34httpwwww3orgTRxhtml1DTDxhtml1transitionaldtd34gtlthtml xmlns34httpwwww3org1999xhtml34gtlthead runat34server34gt lttitlegtlttitlegt ltscript src34httpajaxgoogleapiscomajaxlibsjquery1102jqueryminjs34gt ltscriptgt ltscript type34textjavascript34gt documentreadyfunction 39idGridView1 td39clickfunction alertthiscontextinnerText ltscriptgtltheadgtltbodygt ltform id34form134 runat34server34gt ltdivgt Using JQuery ltbr gt ltaspGridView ID34GridView134 runat34server34 AutoGenerateColumns34false34gt ltColumnsgt ltaspBoundField DataField34FULLNAME34 HeaderText34NAME34

Make columns hidden in GridView and access their values server side in ASP.Net

ianfranc...

SOLVED CLOSED ACTIVE ANSWERED
User: ianfrancisdavocol
Posted: on Feb 24, 2014 02:47 AM
Forum: Data Controls
Answer: 2
Views: 5121

Hi I want to get the values from the Invisible rows from my gridview. here is my code.

   <asp:GridView ID="gvTeam" runat="server" Width="900px" 
                   AutoGenerateColumns="False" BackColor="White" BorderColor="#CC9966" 
                   BorderStyle="None" BorderWidth="1px" CellPadding="4">
                   <Columns>
                       <asp:BoundField DataField="FULLNAME" HeaderText="NAME" />
                       <asp:ButtonField DataTextField="EVALUATION" HeaderText="EVALUATION" 
                           Text="EVALUATION" CommandName="select" >
                       <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                       </asp:ButtonField>
                       <asp:ButtonField DataTextField="BRS" HeaderText="BRS" Text="BRS" 
                           CommandName="select" />
                       <asp:ButtonField DataTextField="SD" HeaderText="SD" Text="SD" 
                           CommandName="select" />
                       <asp:ButtonField DataTextField="BUILD_UT" HeaderText="BUILD &amp; UT" 
                           Text="BUILD" CommandName="select" />
                       <asp:ButtonField DataTextField="SAT" HeaderText="SAT" Text="SAT" 
                           CommandName="select" />
                       <asp:ButtonField DataTextField="IAT" HeaderText="IAT" Text="IAT" 
                           CommandName="select" />
                       <asp:ButtonField DataTextField="UAT" HeaderText="UAT" Text="UAT" 
                           CommandName="select" />
                       <asp:ButtonField DataTextField="OAT" HeaderText="OAT" Text="OAT" 
                           CommandName="select" />
                       <asp:ButtonField DataTextField="FOR_RELEASE" HeaderText="FOR RELEASE" 
                           Text="FOR RELEASE" CommandName="select" />
                       <asp:ButtonField DataTextField="PIT" HeaderText="PIT" Text="PIT" 
                           CommandName="select" />
                       <asp:BoundField DataField="EVALUATION" HeaderText="EVALUATION" 
                           Visible="False" />
                       <asp:BoundField DataField="BRS" HeaderText="BRS" Visible="False" />
                       <asp:BoundField DataField="SD" HeaderText="SD" Visible="False" />
                       <asp:BoundField DataField="BUILD_UT" HeaderText="BUILD &amp; UT" 
                           Visible="False" />
                       <asp:BoundField DataField="SAT" HeaderText="SAT" Visible="False" />
                       <asp:BoundField DataField="IAT" HeaderText="IAT" Visible="False" />
                       <asp:BoundField DataField="UAT" HeaderText="UAT" Visible="False" />
                       <asp:BoundField DataField="OAT" HeaderText="OAT" Visible="False" />
                       <asp:BoundField DataField="FOR_RELEASE" HeaderText="FOR RELEASE" 
                           Visible="False" />
                       <asp:BoundField DataField="PIT" HeaderText="PIT" Visible="False" />
                   </Columns>
                   <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
                   <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
                   <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
                   <RowStyle BackColor="White" ForeColor="#330099" HorizontalAlign="Center" 
                       VerticalAlign="Middle" />
                   <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
                   <SortedAscendingCellStyle BackColor="#FEFCEB" />
                   <SortedAscendingHeaderStyle BackColor="#AF0101" />
                   <SortedDescendingCellStyle BackColor="#F6F0C0" />
                   <SortedDescendingHeaderStyle BackColor="#7E0000" />
               </asp:GridView>

Dim dvr As GridViewRow = gvTeam.SelectedRow
Dim strEval as String = dvr.Cells(11).Text

it always return null value. thanks in advance

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

0 1

Reply
ANSWER
User: Azim
Replied: on Feb 24, 2014 03:19 AM
Report

If you want to get the names of columns which are set to visible false. Then you can make your GridView like this

Use TemplateField and set it to visible false.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField DataField="FULLNAME" HeaderText="NAME" />
                <asp:TemplateField HeaderText="EVALUATION" Visible="false">
                    <ItemTemplate>
                        <asp:Label ID="lblEvalution" runat="server" Text='<%# Eval("EVALUATION") %>' />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="BRS" Visible="false">
                    <ItemTemplate>
                        <asp:Label ID="lblBRS" runat="server" Text='<%# Eval("BRS") %>' />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="SD" Visible="false">
                    <ItemTemplate>
                        <asp:Label ID="lblSD" runat="server" Text='<%# Eval("SD") %>' />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:Button ID="btnGetRows" runat="server" OnClick="GetRows" Text="GetColumns" />
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
            <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
            <RowStyle BackColor="White" ForeColor="#330099" HorizontalAlign="Center" VerticalAlign="Middle" />
        </asp:GridView>

VB.Net

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
        If Not Me.IsPostBack Then
            Dim dt As New DataTable()
            dt.Columns.AddRange(New DataColumn(3) {New DataColumn("FullName", GetType(String)), New DataColumn("EVALUATION", GetType(String)), New DataColumn("BRS", GetType(String)), New DataColumn("SD", GetType(String))})
            dt.Rows.Add("Shaikh Azim", "EVALUATION1", "BRS1", "SD1")
            dt.Rows.Add("Kalpesh Pagdhare", "EVALUATION2", "BRS2", "SD2")
            dt.Rows.Add("Sajid dhukka", "EVALUATION3", "BRS3", "SD3")
            Me.GridView1.DataSource = dt
            Me.GridView1.DataBind()
        End If
    End Sub

    Protected Sub GetRows(sender As Object, e As EventArgs)
        Dim row As GridViewRow = TryCast(TryCast(sender, Button).NamingContainer, GridViewRow)
        Dim lblEvalution As String = TryCast(row.Cells(1).FindControl("lblEvalution"), Label).Text
        Dim lblBRS As String = TryCast(row.Cells(1).FindControl("lblBRS"), Label).Text
        Dim lblSD As String = TryCast(row.Cells(1).FindControl("lblSD"), Label).Text
    End Sub

Thank You.

Azim

0 5

Reply
ANSWER
User: Azim
Replied: on Feb 24, 2014 05:50 AM
Report

This Way:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js">
    </script>
    <script type="text/javascript">
        $(document).ready(function () {
            $('[id*=GridView1] td').click(function () {
                alert($(this).context.innerText);
            });
        });
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        Using JQuery
        <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField DataField="FULLNAME" HeaderText="NAME" />
                <asp:TemplateField HeaderText="EVALUATION">
                    <ItemTemplate>
                        <asp:Label ID="lblEvalution" runat="server" Text='<%# Eval("EVALUATION") %>' />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="BRS">
                    <ItemTemplate>
                        <asp:Label ID="lblBRS" runat="server" Text='<%# Eval("BRS") %>' />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="SD">
                    <ItemTemplate>
                        <asp:Label ID="lblSD" runat="server" Text='<%# Eval("SD") %>' />
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
            <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
            <RowStyle BackColor="White" ForeColor="#330099" HorizontalAlign="Center" VerticalAlign="Middle" />
        </asp:GridView>
        <br />
        Using LinkButton
        <br />
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:BoundField DataField="FULLNAME" HeaderText="NAME" />
                <asp:TemplateField HeaderText="EVALUATION">
                    <ItemTemplate>
                        <asp:LinkButton runat="server" Text='<%# Eval("EVALUATION") %>' OnClick="GetCell"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="BRS">
                    <ItemTemplate>
                        <asp:LinkButton runat="server" Text='<%# Eval("BRS") %>' OnClick="GetCell"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="SD">
                    <ItemTemplate>
                        <asp:LinkButton runat="server" Text='<%# Eval("SD") %>' OnClick="GetCell"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
            <PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
            <RowStyle BackColor="White" ForeColor="#330099" HorizontalAlign="Center" VerticalAlign="Middle" />
        </asp:GridView>
    </div>
    </form>
</body>
</html>

VB.Net

Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
        If Not Me.IsPostBack Then
            Dim dt As New DataTable()
            dt.Columns.AddRange(New DataColumn(3) {New DataColumn("FullName", GetType(String)), New DataColumn("EVALUATION", GetType(String)), New DataColumn("BRS", GetType(String)), New DataColumn("SD", GetType(String))})
            dt.Rows.Add("Shaikh Azim", "EVALUATION1", "BRS1", "SD1")
            dt.Rows.Add("Kalpesh Pagdhare", "EVALUATION2", "BRS2", "SD2")
            dt.Rows.Add("Sajid dhukka", "EVALUATION3", "BRS3", "SD3")
            Me.GridView1.DataSource = dt
            Me.GridView1.DataBind()
            Me.GridView2.DataSource = dt
            Me.GridView2.DataBind()
        End If
    End Sub
    Protected Sub GetCell(sender As Object, e As EventArgs)
        Dim btn As LinkButton = TryCast(sender, LinkButton)
        ClientScript.RegisterStartupScript(Me.[GetType](), "alert", "alert('" + btn.Text + "')", True)
    End Sub

Thank You

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Make columns hidden in GridView and access their values server side in ASP.Net

Company

Explore

Follow us

Contact Us