hidding column in gride view

Question

0.00/5 (No votes)

See more:

hi i have beed lookin arrounf=d for sometime
i need to hide column in a datatable loaded from session
i tried mapping.hidden but did nt work
i already add them to session hidden but they appear in page 2
may any help pls

this is page 2 page load

VB

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
       Response.Cache.SetCacheability(HttpCacheability.NoCache)
       setMenu()
       Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache)
       Response.Cache.SetNoStore()
       lbldte.Text = DateAndTime.Now.ToShortDateString
       If Page.PreviousPage IsNot Nothing Then
           Dim GridView1 As GridView = DirectCast(Page.PreviousPage.FindControl("GridView1"), GridView)

       End If
       If Session("ProductsTable") IsNot Nothing Then
           dt = DirectCast(Session("ProductsTable"), DataTable)

           GridView1.DataSource = dt
           GridView1.DataBind()

       End If

       If Not IsPostBack Then
           'check if the webpage is loaded for the first time.
           'Saves the Previous page url in ViewState
           ViewState("PreviousPage") = Request.UrlReferrer
       End If
   End Sub

Posted 19-May-13 22:14pm

shery_l

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

kumar2413 · Answer 1 · 2013-05-19T22:24:00

Solution 1

C#

dt.Columns.Remove("columnName");
dt.Columns.RemoveAt(columnIndex);

Try this and see.

Posted 19-May-13 22:24pm

kumar2413

shery_l · Answer 2 · 2013-05-19T22:25:00

Solution 2

the remove will delete the value inside
but i wana keep it as i insert it to database on button click

Posted 19-May-13 22:25pm

shery_l

Comments

kumar2413 20-May-13 4:27am

try this then
"dt.Columns[0].Visible= false;"

shery_l · Answer 3 · 2013-05-19T22:29:00

Solution 3

should i try this in page 2 after loading session
or page 1 before adding to session
as in page 1 i already have them hidden , but they appear in page 2

Posted 19-May-13 22:29pm

shery_l

Comments

kumar2413 20-May-13 4:31am

Then put it in page 2 n try.

shery_l 20-May-13 4:32am

that is what i get

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30456: 'Visible' is not a member of 'System.Data.DataColumn'.

Source Error:

Line 37:
Line 38: End If
Line 39: dt.Columns(0).Visible = False
Line 40: If Not IsPostBack Then
Line 41: 'check if the webpage is loaded for the first time.

shery_l · Answer 4 · 2013-05-19T22:31:00

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30456: 'Visible' is not a member of 'System.Data.DataColumn'.

Source Error:

Line 37:
Line 38: End If
Line 39: dt.Columns(0).Visible = False
Line 40: If Not IsPostBack Then
Line 41: 'check if the webpage is loaded for the first time.

shery_l · Answer 5 · 2013-05-19T22:39:00

yes
i did
this code at page 1 submit button

Protected Sub btnGetData_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnGetData.Click
Dim strEMPPRJCDE As String
Dim strEMPBRN As String
Dim strVSTDTE As String
Dim strBRNCDE As String
Dim strPRJCDE7 As String
Dim strEMPAGE As String
Dim strEMPSRL As String
Dim strRQSTSRC As String
Dim strUPDUSR As String
Dim strEMPBRTDAT As String

dt.Columns.Add("Serial no.", GetType(Integer))
dt.Columns.Add("Employee code", GetType(String))
dt.Columns.Add("Employee Name", GetType(String))
dt.Columns.Add("Telephone", GetType(String))
dt.Columns.Add("Branch(job)", GetType(String))
dt.Columns.Add("General Clinic", GetType(String))
dt.Columns.Add("Dental Clinic", GetType(String))
dt.Columns.Add("Emp.Age", GetType(String))
dt.Columns.Add("Visit date", GetType(String))

dt.Columns(7).ColumnMapping = MappingType.Hidden
For Each gvRow As GridViewRow In Gridview1.Rows
Dim row As DataRow = dt.NewRow()
row("Serial no.") = gvRow.Cells(0).Text
row("Employee code") = DirectCast(gvRow.Cells(0).FindControl("empnum"), TextBox).Text
row("Employee Name") = DirectCast(gvRow.Cells(3).FindControl("empnme"), TextBox).Text
row("Branch(job)") = DirectCast(gvRow.Cells(8).FindControl("dropjobqs"), DropDownList).SelectedItem
row("Telephone") = DirectCast(gvRow.Cells(4).FindControl("tel"), TextBox).Text
row("General Clinic") = DirectCast(gvRow.Cells(6).FindControl("chkdelete"), CheckBox).Checked
row("Dental Clinic") = DirectCast(gvRow.Cells(7).FindControl("chkdental"), CheckBox).Checked
row("Visit date") = strtDate.Text

If (row("General Clinic").ToString = True) Then
row("General Clinic") = "*"
Else
row("General Clinic") = "-"
End If
If (row("Dental Clinic").ToString = True) Then
row("Dental Clinic") = "*"
Else
row("Dental Clinic") = "-"
End If
Try
If (row("Employee code").Length <> 0) Then
If (row("Employee code").StartsWith(0)) Then

dr = conn.MyReader("SELECT DAYEMPNBR, DEMPNAM, DBRTDAT, DPRJCDE, DEMPBRN FROM DAYBAS WHERE DAYEMPNBR = '" + DirectCast(gvRow.Cells(0).FindControl("empnum"), TextBox).Text + "' and ddayoff ='1900-01-01' ")
'cmd.Parameters.Add("@EMPNBR", SqlDbType.VarChar).Value = box1.Text
If dr.HasRows Then
While dr.Read()
strVSTDTE = DateTime.Now.ToShortDateString
row("Employee Name") = dr(0).ToString
strEMPBRTDAT = dr(1).ToString
strEMPPRJCDE = dr(2).ToString
strEMPBRN = dr(3).ToString
strBRNCDE = row("Branch(job)").ToString 'last added 9/5 2:40
strEMPBRN = dr(4).ToString

'the next step the birthday in correct dormat
strEMPAGE = Now.Year - Convert.ToDateTime(strEMPBRTDAT).Year
row("Emp.Age") = strEMPAGE

End While

Else
strEMPBRN = DirectCast(gvRow.Cells(0).FindControl("empnum"), TextBox).Text
row("Employee Name") = "please check the employee codfgdfde"

End If
dt.Columns(4).ColumnMapping = MappingType.Hidden
Else
dr = conn.MyReader("SELECT EMPNAM , EMPBRTDAT , EMPPRJCDE , EMPBRN, EMPNBR FROM EMPBAS where EMPNBR ='" + DirectCast(gvRow.Cells(0).FindControl("empnum"), TextBox).Text + "' and empmra !='12'")
If dr.HasRows Then
While dr.Read()
strVSTDTE = DateTime.Now.ToShortDateString
row("Employee Name") = dr(0).ToString
strEMPBRTDAT = dr(1).ToString
strEMPPRJCDE = dr(2).ToString
strEMPBRN = dr(3).ToString
strBRNCDE = row("Branch(job)").ToString 'last added 9/5 2:40
strEMPBRN = dr(4).ToString

'the next step the birthday in correct dormat
strEMPAGE = Now.Year - Convert.ToDateTime(strEMPBRTDAT).Year
row("Emp.Age") = strEMPAGE
End While
Else
strEMPBRN = DirectCast(gvRow.Cells(0).FindControl("empnum"), TextBox).Text
row("Employee Name") = "please check the employee dfgdfgcode"
'DirectCast(gvRow.Cells(0).FindControl("empnum"), TextBox).Focus()
End If
End If

dt.Columns(7).ColumnMapping = MappingType.Hidden

End If

Catch ex As Exception
Throw (ex)
End Try
dt.Rows.Add(row)
Next
Session("ProductsTable") = dt
Response.Redirect("preview.aspx")

End Sub

hidding column in gride view

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0