asked on

asp.net c# gridview columns hide

Hello,
I have a *.aspx page where I allow users to search a database table via stored procedure.
When the user clicks an asp.button called "find", it fires the stored procedure which populates a gridview control.

I am attempting to hide two columns on this gridview and cannot seem to accomplish that.

My *.aspx code follows:
---------------
<asp:SqlDataSource ID="ds_warrantsearchresults" runat="server" ConnectionString="<%$ ConnectionStrings:Jailinfo_JAUConnectionString1 %>"
SelectCommand="sp_getAllWarrantsbyName" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="FirstNameTextBox" Name="Firstname" PropertyName="Text"
Type="String" Size="50" ConvertEmptyStringToNull="false" />
<asp:ControlParameter ControlID="LastNameTextBox" Name="Lastname" PropertyName="Text"
Type="String" ConvertEmptyStringToNull="false" />
<asp:ControlParameter ControlID="SpnTextBox" Name="Spn" PropertyName="Text" Type="String"
ConvertEmptyStringToNull="false" />
<asp:ControlParameter ControlID="DobTextBox" Name="Dob" PropertyName="Text" Type="String"
ConvertEmptyStringToNull="false" />
</SelectParameters>
</asp:SqlDataSource>

<asp:GridView ID="gv_warrantsearchresults" runat="server" DataKeyNames="Spn" AllowSorting="True"
DataSourceID="ds_warrantsearchresults" CellPadding="4" Font-Names="Arial" Font-Size="Small"
ForeColor="#0033CC" GridLines="None" Width="580px" EmptyDataText="NO Matching Data Found"
OnSelectedIndexChanged="gv_warrantsearchresults_SelectedIndexChanged" PageSize="15"
ShowFooter="True" AllowPaging="true">
<%-- <HeaderStyle CssClass="GridHeader" /> --%>
<RowStyle BackColor="#EFF3FB" />
<EmptyDataRowStyle Font-Names="Arial" Font-Size="Small" ForeColor="Red" />
<Columns>
<asp:CommandField ShowSelectButton="True" />
</Columns>
<FooterStyle BackColor="White" Font-Bold="True" ForeColor="White" Font-Names="Arial"
Font-Size="X-Small" />
<PagerSettings Mode="NumericFirstLast" />
<PagerStyle BackColor="#507CD1" ForeColor="#507CD1" HorizontalAlign="center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" HorizontalAlign="Left" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" HorizontalAlign="Left" VerticalAlign="Top" />
</asp:GridView>

-----------

The codebehind of the asp.button that fires the stored procedure follows:
-----------

protected void Button1_Click(object sender, EventArgs e)
{
pnl_gvWarrantSearchResults.Visible = true;
//gv_warrantsearchresults.Visible = true;

gv_warrantsearchresults.Columns[0].Visible = true;
gv_warrantsearchresults.Columns[1].Visible = true;
//gv_warrantsearchresults.Columns[2].Visible = true;
//gv_warrantsearchresults.Columns[3].Visible = true;
//gv_warrantsearchresults.Columns[4].Visible = false;

pnl_gvSearchResults_Detailsview.Visible = true;
dv_searchresults.Visible = true;

pnl_wsdetail_imageview.Visible = true;

//pnl_agreetoterms.Visible = true;
//txt_AgreedToTerms.Text = "You Hereby Agree to Terms & Conditions";

pnl_display_ddl.Visible = true;

}

---------------

ANY HELP with this would be greatly appreciated.

BuggyCoder

Here is sample code:-

foreach (GridViewRow gvr in GridView1.Rows)
	    {
//add aditional logic here
	        gvr.Cells[0].Visible = false;    
            }

Open in new window

see this as well:-
http://www.codeproject.com/Articles/43727/Show-Hide-GridView-Columns-in-ASP-NET

MikeMCSD

I used this once and it worked :

protected void grid1_RowDataBound(object sender, GridViewRowEventArgs e)
{

if ( condition)
{
e.Row.Cells[1].Visible = false;
e.Row.Cells[2].Visible = false;
e.Row.Cells[3].Visible = false;

..

Rick

Use the gridview's rowdatabound event and change the "visible" property to false:

e.row.cells(0).visible = false;

Or change the display attribute to "none":

e.row.cells(0).style.add("display", "none");

SOLUTION

Ashley Bryant

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Rahul Agarwal

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial