Showing posts with label GridView Column. Show all posts
Showing posts with label GridView Column. Show all posts

GridView Column Remove or Hide Using RowCreated Event in Asp.Net C#

GridView Column Remove or Hide Using RowCreated


Gridview Columns Want To Remove or Hide In Run Time  Using RowCreated Event or Gridview Column Visible False in Asp.Net C#.

                                 DEMO



 HTML CODING for GridView DataBound


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">      
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Height="109px"  Width="664px">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="ID" />
                <asp:BoundField DataField="name" HeaderText="Name" />
               <asp:BoundField DataField="country" HeaderText="Country" />
                <asp:BoundField DataField="amount" HeaderText="Amount" />
            </Columns>
        </asp:GridView>
       
    </form>
</body>
</html>


                              C# CODING

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class BindDropDown : System.Web.UI.Page
{  
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
        con.Open();

        SqlCommand cmd = new SqlCommand("select * from country", con);

        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        adp.Fill(dt);

       GridView1.Columns[3].Visible = false;

        GridView1.DataSource = dt;
        GridView1.DataBind();
       
     
    }  




HTML CODING Without DataBound

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
<asp:GridView ID="GridView2" runat="server" RowCreated="GridView2_RowCreated" OnRowCreated="GridView2_RowCreated1">
        </asp:GridView>
        <br />
    </form>
</body>
</html>



                      C# CODING


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class BindDropDown : System.Web.UI.Page
{  
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
        con.Open();

        SqlCommand cmd = new SqlCommand("select * from country", con);

        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        DataTable dt = new DataTable();
        adp.Fill(dt);

        GridView2.DataSource = dt;
        GridView2.DataBind();
     
    }     

    protected void GridView2_RowCreated1(object sender, GridViewRowEventArgs e)
    {
        e.Row.Cells[3].Visible = false;
    }
}



First - Add New Form - Add GridView From ToolBox






Next - Gridview Column - Bound The DataFields






Next - GridView Column  Visible False or RowCreated Cell Values False






Next - Run[F5] - Column Hide & Show 






GridView Article Full List

GridView Article Full List


Nested GridView - GridView Inside Another GridView Show in Asp.Net C#

Image Update in GridView Using Asp.Net C#





Update Multiple Rows in GridView With CheckBox Selection With Confirmation in Asp.Net C#


Delete Multiple Rows in GridView With CheckBox Selection  With Confirmation in Asp.Net C#





GridView SelectedIndexChanged Use in Asp.Net C#




GridView Column Remove or Hide Using RowCreated Event in Asp.Net C#



 GridView Selected Row Values in Previous Page Avoid Page Refresh (Go To Previous Page Using JavaScript) Using Back Button in JavaScript Asp.Net C#



How to Export GridView Data to Excel Using Asp.Net C#


How to Export Gridview to PDF Document   Generate  in Asp.Net C# Using ITextSharp



GridView Column Hide Or Remove in Asp.Net C#


Sorting GridView Selected DropDownList Values in Asp.Net C#


GridView Row Number Increment Automatically in Asp.Net C#


Import Excel Sheet Data To GridView Page_Loading And GridView Binding  Using Asp.Net C#


GridView Sorting An Ascending and Descending With Using DataBaseTable in Asp.Net C#


Button Click Event Inside GridView Using Asp.Net C#


GridView Paging Using PageIndexChanging Event in Asp.Net C#


RegisterForEventValidation can only be called during Render();


 DataPager Control Using ListView Show Details  in Asp.Net C#


What is Grid VIew Control in Asp.Net c#


How to GridView  Header  Hide Using Asp.Net C#



Image Insert &  Upload  Bind GridView Using Asp.Net C# 


GridView Bind Using with DataReader in Asp.Net C# 




GridView Column Hide Or Remove in Asp.Net C#

GridView Column Hide Or Remove



Gridview Display Particular Columns Hide Or Remove Run Time Using Gridview_RowCreated Event in Asp.Net C#.

                        
                           DEMO 




HTML CODING

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" OnRowCreated="GridView1_RowCreated">
    <Columns>
        <asp:BoundField DataField="country" HeaderText="COUNTRY" />
        <asp:BoundField DataField="amount" HeaderText="AMOUNT" />
        <asp:BoundField DataField="name" HeaderText="NAME" />
    </Columns>
     <HeaderStyle BackColor="#FF3300" />
            <RowStyle BackColor="Silver" />
            <AlternatingRowStyle BackColor="#9999FF" />
</asp:GridView>
       
    </div>
    </form>
</body>
</html>



                          C# CODING

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data.OleDb;
using System.Data;
using System.Data.SqlClient;


public partial class Default4 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["dbcon"].ToString());
        con.Open();
        SqlCommand cmd = new SqlCommand("select country,amount,name from country", con);

        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        adp.Fill(ds);

        GridView1.DataSource = ds;
        GridView1.DataBind();

    }
    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        e.Row.Cells[1].Visible = false;

        //Amount Column Not Show
    }
}

First - Add New Web Form  - Select GridView From  ToolBox 




Next - Go -To - Edit Column - Add BoundField - Change Header & DataField





Next - Go -To - Edit Column - Add BoundField - Change Header & DataField






Next - Bind Values To GridView  On Page_Load






Next - Select GridView - Go-To - Property - RowCreated 






Next - Visible = False  The Column Cell Values





Next - Run[F5] - WithOut  Column  Hide Show All Column Otherwise Hide The Columns