I am having some trouble hiding a column in my GridView. For some reason when I do the following:
[Code]....
It hides the column correctly but also leaves an empty gray column at the end of my grid which is about 5px. Ideally I don't want to remove the column but hide it, but if I do remove it is it possible to remove the binded that column represents?
using vb.net/asp.net 2005
I have a gridview with columns (pseudo-code):
<COLUMNS>
AuthorFirstname
AuthorLastName
BookTitle
YearPublished
</COLUMNS>
what I would like to do is to only show the AuthorFirstName and AuthorLastName columns for the first row of each author. I am easily doing this with:
[Code]....
However the issue that I'm seeing now is the formatting what happens is that after the first row that the Author names are hidden but then the BookTitle and YearPublished become the new cell(0) and cell(1) respectively which means that book and year are displaying underneath the author names columns. so my goal is to do 2 things:
1 have BookTitle and YearPublished render under the correct headers and
2. For the second row and after I would like the cell to appear the same as the background, I dont want the user to be seeing what looks like an empty cell or textbox there.
I have been trying to hide a column but make use of the value in another function but the function i am trying to hide it give me and error at the embolded line. System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Public Sub FetchDetails()
Dim valtable As DataTable = New DataTable()
valtable.Columns.Add("LINK")
valtable.Columns.Add("WATCH PERIOD")
valtable.Columns.Add("DAY ENTRY")
valtable.Columns.Add("listid")
Dim seltext As String = "SELECT [Watchlistname], [Watchlisturl], [Watchlistdate],[listid] FROM [Watchlist]"
Dim madap As SqlDataAdapter = New SqlDataAdapter(seltext, Connection())
Dim mdset As DataSet = New DataSet()
Dim i As Integer = 0, pager As Integer = 0
madap.Fill(mdset, "WATCHLIST")
Session("tab") = mdset.Tables("WATCHLIST")
For Each arow As DataRow In Session("tab").Rows
Dim valrow As DataRow = valtable.NewRow()
valrow("LINK") = arow("Watchlisturl")
valrow("WATCH PERIOD") = arow("Watchlistname")
valrow("DAY ENTRY") = arow("Watchlistdate")
valrow("listid") = arow("listid")
valtable.Rows.Add(valrow)
Next
'Dim str As String = ChrW(8358)
gridWatchlist.DataSource = valtable
gridWatchlist.DataBind()
gridWatchlist.HeaderRow.Cells(1).Visible = False
gridWatchlist.HeaderRow.Cells(2).Text = "WATCH PERIOD"
gridWatchlist.HeaderRow.Cells(3).Text = "DAY ENTRY"
gridWatchlist.Columns(4).Visible = False
End Sub
[URL]
using above code i am able to print gridview directly without hidden fields.after added to hiddenfields to gridview , hiddenfield values are visible for printing.after i am using gridview.colums[i].visible=false column not visible while printingproblem is after print the gridview not visible whatever my columns set visible false.Example:at printing time i am set checkbox visible false, after printing i want reload same page with checkbox but check box not visible after printing gridview
I had a datagrid and I was hiding columns. This was working fine to show just the columns I wanted.
[Code]....
And then I realised I wasn't paging the data so I ticked that on then above code no longer worked. The Count was equalling 1 with the paging ticked on. Why would that be?
I also used the classic formatting and when I sort the columns the classic formatting goes funny, how can reapply the sorting to make it look classic?
Right now when I bind data to my gridview, I have a column MemberNo that I use in the RowDataBound in another column for creating a link. Anyways, in the DataBound event i hide the MemberNo column. But I also have a routine where I need to loop through the rows and use the MemberNo. Can I unhide the column MemberNo to use for this routine and then hide it again? I assume I cannot use the data if it is hidden right?
View 2 RepliesI have a grid view which is made up of bounded and template columns. I have a check box which i select to show all/ show non empty columns.
My issue is hidding the template columns. I have the following code:
[Code]....
My issue is with the piece of code
[Code]....
How do I find the ID of the label in grid view column for the template column?
I have 3 grid views in my ASP.net application Viewing the data from different tables and search input with button( for all 3 grid view One input field), when i give input and click on serach button only one Grid view should be appear rest of the 2 gridviews should be hide but for me when i change the input values previous Grid view also remain stationed on the screen.Gridviews are GVOpenorder,GVShip,GvSchedule and input field name is txtSearch,button name is btnSearch.
View 8 RepliesI need my gridview to display no records when the user first lands on the page. Right now it's showing all records by default based on a query I've defined in a Table Adapter in my dataset.
I have 2 web controls that the user employs to filter data (or view all records). They are working fine--I just need to have the gridview show nothing by default.
<asp:TemplateField>
<ItemTemplate>
<asp:HiddenField ID="HiddenFieldTime" runat="server" Value='<%# Bind("Time") %>' Visible="False" />
</ItemTemplate>
</asp:TemplateField>
When I load the page, it shows up as a blank cell. Is there anyway to hide it completely as it looks out place?
My gridiview is mostly templated fields.
I have searched far and wide and discovered that if you hide gridview colums in the Gridview's databound event, as per the code below,then the objectdatasource binds multiple times according to the number of columns you are hiding. This is definitely the case.
[Code]....
[Code]....
I have an image button on my gridview in one column, and in the next column, I have a nested gridview. What I am looking to do, is to use my image button as a way to show and hide my nested gridview. I do not want to use JavaScript, because my page already uses a great deal of JavaScript. Therefore, I want to use code behind on the button, this is what I have done so far:
ImageButton b = (Button)sender;
GridViewRow row = (GridViewRow)b.NamingContainer;
if (row != null) {
int rowIndex = row.RowIndex;
How do I use my selected row index to call the nested gridview to be visible and not visible?
I was wondering how to hide a control(lblPrice) in a gridview(Gridview1)'s templatefield, given certain conditions? Like:
If X condition then
-- code to hide lblPrice --
End If
Here's the background: I have a GridView with suggested meetings. A logged in member can view the suggested meetings and click button "Show" to view all suggested occasions for every meeting. What I want to do now is to hide button "Show" for a logged in member if she/he owns the meeting (i.e. is the one who suggested it = Session["memberID"]).
My problem is this: All buttons "Show" are visible. I want to hide button "Show" in those cases where Session["memberID"] is identical to dr[0]. 'ID' in the SQL statement is the ID of the meeting in the database and meetingID are the ID's of the meetings shown in the GridView.
Here's the code:
[Code]....
I have a gridview control which gets data from database. One of the column is a checkbox and based on the value of the checkbox, I need to display 2 more columns. Currently I am having 2 issues:
1. I am able to achieve this when OnDataBound event gets triggered. Basically I am checking the row state and type and if it is in Normal mode I check the status of the checkbox and based on the status I am setting the style on the columns I want to hide (columns contain checkboxes). But for some reason, I am not able to hide the header. The GridView shows the header but the text boxes which are in the columns are hidden.
2. During Edit mode, I have attached a javascript to the checkbox and when the status of the checkbox changes, it hide/unhides the columns, again header cannot be made hidden. Also, if I use the Visible property of the header, I can make the header invisibly (only using the code behind) but when javascript is invoked on the checkbox during edit mode, it cannot find the controls as they are not visible and hence does not do anything. Since TemplateField does not support style property I can't even set the style["display"].
Working on a site where a user does a search, it takes the input from the user and then runs an SQL command to return the data in a gridview for the user to see. I also have a button where the user can see all the results from the DB (this will be taken out later but for now the DB is pretty small) This is all working fine, but the problem I am having is that when you look at the page source the gridview populates everything in tables on the page. This makes it really easy to just copy and paste and get everything from my database. How can I go about displaying the information to the user in a gridview, but hiding the table information in the html page source?
View 6 RepliesI want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
View 4 Replies[Code]....
Main Gridview[Code]....
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
View 2 Replieswant to display gridview column heading when mouse over to the particular column in the gridview.
View 9 RepliesHow to add a button at first column of gridview and get cell value in another column?
For example, add a button named it as "Click me". Once user clicks will get third column cell's (ID) value.
No sense in showing a competely blank column. how to make a GridView column invisible if every cell in that column is empty?
View 3 RepliesI have a gridview with 3 columns. In second column I want to display some text in 2 rows and then a gridview.
Here is my code:
[Code]....
The problem is my third row is displayed as a row under first column. How do I make it a separate column in my girdview. Not sure what is going wrong.
I am using GridView ,I want to do a validation like if i edit any one of the Cell in that column, it will through the validation when the sum of column value is more than 100. How can i do this validation?
View 10 Repliesdisable linkbutton if gridview is empty in child pages. I have a Export to Excel LinkButton in master page and in child page I have textbox wherein I pass the input based on which the gridview loads. When the child page loads the Export linkbutton should be disabled. After entering the input in textbox on click of the button the gridview will be loaded wherein now the Export linkbutton should be enabled to export to excel.
View 1 Replies