Forms Data Controls :: Merge And Sort Selected GridView Cells
Apr 9, 2010
I have a GridView known as GV_R001 with IssueType, ActID, IssueID cells. I want to Merge the similar IssueType cell accordingly. How do i merge and also sort the IssueType cell accordingly. The following is my codes:
Protected Sub GV_R001_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GV_R001.DataBound
For rowIndex As Integer = GV_R001.Rows.Count - 2 To 0 Step -1
Dim gvRow As GridViewRow = GV_R001.Rows(rowIndex)
Dim gvPreviousRow As GridViewRow = GV_R001.Rows(rowIndex + 1)
Dim cellCount As Integer = 0
If gvRow.Cells(cellCount).Text = gvPreviousRow.Cells(cellCount).Text Then
If gvPreviousRow.Cells(cellCount).RowSpan < 2 Then
gvRow.Cells(cellCount).RowSpan = 2
gvRow.Cells(cellCount).RowSpan = gvPreviousRow.Cells(cellCount).RowSpan + 1
gvPreviousRow.Cells(cellCount).Visible = False
Apart from that, after sorting i want to calculate the amount of IssueID are in a particular IssueType and display in a cell called "Total". Is it possible to do so? By the way, I am using Web Developer 2008, VB.net.
i have a gridview in my website and i want to merge two cell of that in same column but in different row , for example i have a data about tours in an agency , now i define a tour that has two hotel with difference grade , i want tow show my grid view in this manner :
I'm working on a project in vb.net framework 2.0 and have a column that has server names. I have the accessdb sql setup to order by the db, what I would like to do is to have it look like the following picture below. I'm pretty stumped on how to do it as the methods I've found online haven't worked so well. Also just a small tid-bit the gridview is bound to a ddl which selects the application and the gridview refreshes with server data. Country would be server name and state would be the environment.
I'm working on a project in vb.net framework 2.0 and have a column that has server names. I have the accessdb sql setup to order by the db, what I would like to do is to have it look like the following picture below. I'm pretty stumped on how to do it as the methods I've found online haven't worked so well. Also just a small tid-bit the gridview is bound to a ddl which selects the application and the gridview refreshes with server data. It is sorted by server than environment so the columns contain much of the same info for those over and over. Country would be server name and state would be the environment.
I am working on ASP.NET 4.0 application.I want to bind the data in a datatable to a grid control and i want to do some formatting. I want to merge the cells or hide the cell border in the first three columns (Merge every 5 cells in a column). And Vertical align the text to center. Also i need row border at the end of every 5 rows.
For example, If i am binding 10 rows to the Grid i need row border only at the end of 5th and 10th row. And merge every five cells only in the first three columns. All the other columns should not be changed. I also want to change the background color of the cells in all rows based on the value in that cell. How to achieve this in ASP.NET 4.0 and which control can be used to display in this format?
i am still stumped with this operation: i am trying to retrieve a GridView selected row data..here is my code.. the commented part that gives me the selectedindex works just fine....but the one giving the selected row cell value does't work and there is no error.. The update operation is done successfully...weired. i need to assigned selected row cells values to variables ..do some calculations and then re-assign the result calculation to cell..
Just spent about 8 hours googling and looking through this forum for a solution on how to make sure that I can dynamically sort. Here is the situation.
I have 1 Gridview that displays 10 different scenarios based on what button is clicked.
I am also returning only top 10 records. I am doing all of the data binding pragmatically. So I have BoundFields, HyperLinkFields etc.
I also want to sort some records. When I change DataSource SQL statement the gridview somehow remembers what the last sort value was and it errors out saying that value "x" cannot be sorted because it does not exists.
I'm new to ASP.net (and coding in general) and I was very impressed about how easy is to learn enough to create something useful :)
Unfortunately, now I'm stuck on a problem involving gridview sorting and paging: I created a master gridview bound to an sqldatasource, I enabled sorting and paging and then I linked it to a detailsview to enable editing and inserting.
In addition, I set up two other gridviews whose datasources depend on the master gridview.
When a user selects a row and modifies it in the detailsview, the sort takes place and the row is often moved to another page. This can be a little confusing, especially because there are other controls relying on the selected row of the master gridview.
There's a way to find and select the page of the selected row after gridview's databind and sort take place? I tried creating a dataview to search the index of the selected datakey in the databound event of my gridview, but it doesn't work, because it seems that the rows aren't sorted yet. Maybe I should choose another event?
I've created a DataTable by programming and I'v inserted a new DataRow into it, I binded it with a gridview (It's ok), but that new row has many columns, how can I merge all columns of that new row and set the value will be show of that row.
Here is my snipet:
Store2 (new row I've created and I want to merge all columns and show the value is Store2)
want to merge the columns into gridview example SELECT b.TableName,c.ColumnName,a.DataProfileAction,(a.ForeignTable+'/'+a.DataProfileAction) As MergeRecords From DataProfiling As a Inner Join TableList As b ON a.TableId= b.TableId Inner Join MetaDataTable As c ON a.ColumnId=c.ColumnIdquery working.. suppose if any one column empty while binding times it come as empty..
I am able to display it in gridview but not in the above style, that is the columns in excel above are merged, but I have fail to merge gridview column. I have searched google for solution but what I found is that of merging row or header, but what about this one? Note, I can not fixed this style as user can upload excel routine files to server of different style.
specially VB code behind pages.I am writing an app with a colleague and I am stuck on something.he app is a holiday booking calendar. I have a gridview that shows the total number of days booked for each month of the year. When you click the cell for say January another gridview is populated below showing each day of january.My problem is that I want to change the formatting of the cells in the second gridview depending upon if any of the cells have a 1 or a 0.
we're creating a GridView to display news articles programmatically (not using a SQL database).
We can create & display the GridView, but are having a devil of the time to get the hyperlinks in SetupGrid() attached to the titles
of the articles in the GridView. Below is our .aspx code and .vb code of how we create the GridView. Any ideas on what we should do to get the hyperlinks array of strHyperlinks() in SetupGrid() to be applied to the titles in column 1 of the GridView?