how to hide and show columns in gridview

Question

0.00/5 (No votes)

See more:

pls some one tell that how to hide and show columns in gridview in asp.net c#,
i want to show approved data in gridview which is approved by administrator.

my code is

C#

Copy Code

    string constr = @"Server=ITWLTD-DEV01;Database=parul;Integrated Security=true;";
    string query = @"select c.id,c.username,c.password,c.compname,c.contactperson,c.designation,c.Exposurejob,c.industry,c.location,c.status,c.landtype,c.calltype,c.called,c.assigned,c.closed,c.price,c.clc,c.email,c.followup from Category as c inner join login_details on c.id= login_details.id where c.id=11";

    SqlDataAdapter da = new SqlDataAdapter(query, constr);
    DataTable table = new DataTable();
    da.Fill(table);

    gvDetails.DataSource = table;
    gvDetails.DataBind();
}


if (CheckBox2.Checked == true)
{
    txtcompany.Visible = true;
    lblcompany.Visible = true;
    gvDetails.Columns["compname"].Visible = true;
}
else
{
    txtcompany.Visible = false;
    lblcompany.Visible = false;
    gvDetails.Columns["compname"].Visible = false;
}

but it throws error

Copy Code

The best overloaded method match for 'System.Web.UI.WebControls.DataControlFieldCollection.this[int]' has some invalid arguments

pls some one tell the solution.

Posted 1-Nov-12 23:51pm

chander_rani

Updated 1-Nov-12 23:56pm

Nelek

v2

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thomas Daniels · Answer 1 · 2012-11-01T23:56:00

Solution 1

The error is in this line:

C#

Copy Code

gvDetails.Columns["compname"].Visible = true;

and in this line:

C#

Copy Code

gvDetails.Columns["compname"].Visible = false;

You need to change the string between [ and ] into a integer.
The integer must be the index of the column.

Permalink

Posted 1-Nov-12 23:56pm

Thomas Daniels

Comments

[no name] 2-Nov-12 6:00am

i dont understand the code pls tell me where i put the integer in my code...

Thomas Daniels 2-Nov-12 6:07am

Between the [ and ] chars.
For example:
gvDetails.Columns[0].Visible = true;
In this case, 0 is the column index, the first column. To set the visiblity of the second column, do this:
gvDetails.Columns[1].Visible = true;

Naman Kumar Sinha · Answer 2 · 2012-11-02T00:21:00

The error is in this line of code

C#

Copy Code

gvDetails.Columns["compname"].Visible = false;

You must have an integer value inside the big brackets []. It is nothing but the index value of the column. Suppose you have five columns A,B,C,D & E. Their index value will be 0,1,2,3 & 4. If you want to hide fourth column for example compname here (i.e index value = 3), then you will have to modify your code like this

C#

Copy Code

gvDetails.Columns[3].Visible = false;

Hope that helps.

how to hide and show columns in gridview

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to hide and show columns in gridview

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us