Forms Data Controls :: Merge Columns Like Excel In Gridview

Sep 29, 2010

I have a excel file which is in structure a class routine:

| 9-10 | 10-11 | 11-12 | 12-01 | 01-02 | 02-03 | 03-04 | 04-05 |


tue | subject1 | subject2 | subject3 |

wed | subject2 | subject3 | subject1 |

thu | subject3 | subject2 | subject1 |

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.

View 2 Replies


Similar Messages:

Forms Data Controls :: Merge All Columns Of A Row In Gridview

Jan 15, 2010

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:

Store1

row [Column1],[Column2],[Column3]

row [Column1],[Column2],[Column3]

Store2 (new row I've created and I want to merge all columns and show the value is Store2)

row [Column1],[Column2],[Column3]

row [Column1],[Column2],[Column3]

View 2 Replies

Forms Data Controls :: Merge The Columns Into Gridview?

Oct 1, 2010

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..

View 2 Replies

Forms Data Controls :: How To Merge Gridview Columns (cells)

Nov 5, 2010

How to merge gridview columns in a grid when the items in the grid are duplicate. i mean in one row four columns are there i need to merge the columns which are repeating

eg: Mango Mango Mango Apple

i want like: Mango Apple

i the columns mango is getting repeated i need to merge it into one

View 14 Replies

Forms Data Controls :: Merge Merger Header Columns In Gridview?

Nov 16, 2010

How can I create below type of gridview with merge merged header columns? If anybody have example share with me.

View 2 Replies

Forms Data Controls :: How To Merge Columns In DetailsView Control

Oct 8, 2010

I have a DetailsView control with two columns and 7 rows. I need the two columns to merge in row two and get rid of the header. I only the data from the DB to display no the header name in row two. How do I merge it in DetailsView control?

View 2 Replies

Forms Data Controls :: Export Only A Subset Of Columns From Gridview To Excel?

Jan 25, 2010

how to export only a subset of columns from Gridview to excel? i'm sure there are examples online, but have not been able to get the right kinda examples.

View 1 Replies

Forms Data Controls :: Remove Multiple Gridview Columns Before Excel Export?

Mar 29, 2011

I'm trying to find a code to delete multiple columns because when you delete a column the next column takes his place so for example:

If you delete column 6 then column 7 becomes column six.

I tried the following code with an for loop & a while loop:

Dim field As DataControlField = gv.Columns(i)
gv.Columns.Remove(field)
&
gv.columns.removeat(i)

But same case that the column 7 becomes column 6

The variable removeColumns is an array with the column number that need to be deleted.

If wanted I can also provide the Header Names

[Code]....

View 6 Replies

Forms Data Controls :: Webform - Highlight Two Columns In Excel Category - Weight And Then Past Them From Clipboard To Gridview

Mar 23, 2011

I have a gridview that has the following colums Category, Weight , and an option to delete row. I user would like to be able to highlight two columns in excel Category, Weight and then past them from clipboard to gridview.

View 1 Replies

Data Controls :: Dynamically Insert Rows And Columns To GridView Like Excel?

Sep 20, 2015

I have 2 textboxes , one for Rows and one for Columns...

in my query, if i enter Rows as 4, Columns as 3 then i want display gridview with 4x3 like

A  B   C --- Header1 A1 B1 C12 A2 B2 C23 A3 B3 C34 A4 B4 C4

if i enter Rows as 7, Columns as 4 then i want display gridview with 7x4 like

A  B   C  D --- Header1 A1 B1 C1 D12 A2 B2 C2 D23 A3 B3 C3 D34 A4 B4 C4 D45 A5 B5 C5 D56 A6 B6 C6 D67 A7 B7 C7 D7

how to write complete code for above query

View 1 Replies

Forms Data Controls :: Merge Cells In Gridview

May 4, 2010

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 :

tour a
hotel a1
100 $
2010 / 5 / 5
hotel a2
200 $

View 2 Replies

Forms Data Controls :: Hide Columns When Export To Excel

Nov 10, 2010

I have a gridview containing 10 columns. Three of them are set to visible="false' by default. When I click on 'Export to excel' Button, I can hide those invisible columns.

[Code]....

There must be more efficient way than this. How can I find the invisible columns and store their information in array and then only do a loop once?

View 3 Replies

Forms Data Controls :: In Page User Able To Select Gridview Columns And It Will Hide Remaining Columns

Mar 18, 2010

in asp.net page user able to select gridview Columns, and it will hide remaining columns and that selection done by check box with column list bellow is Image link , what exactly I am looking for [URL] it look bellow after selection of column done [URL]

View 1 Replies

Forms Data Controls :: Merge Like Cells In Column In Gridview

Mar 18, 2010

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.

View 5 Replies

Forms Data Controls :: Gridview Templatefield Merge Header?

Dec 3, 2010

How can I merge three of the templatefields header of gridview?

I want to just merge the header not creating new header such as "l Modify l PO l Arranging l" --> "l Action l"

Could you give me the answer for me?

I have some code behind.

--Grid View--

<asp:GridView ID="GridItem" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False"
DataSourceID="itemSql" EmptyDataText="THERE IS NO PROPER ITEM" Width="980px"[code]....

View 10 Replies

Forms Data Controls :: Merge Cell Or Rowspan In Gridview?

Jun 16, 2010

I Want To Merge The Rows Of Grid View My Codding is Row data Bound

if (e.Row.RowType == DataControlRowType.DataRow)
{
int row1 = e.Row.RowIndex;
Label grouplabel = (Label)e.Row.FindControl("lblgroupname");
int count = 0;

[Code]....

My Out put comes Likes

groupname itemname
4 3
2

I want To need 4 comes in middle and rows merge .

View 1 Replies

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
Else
gvRow.Cells(cellCount).RowSpan = gvPreviousRow.Cells(cellCount).RowSpan + 1
End If
gvPreviousRow.Cells(cellCount).Visible = False
End If
Next
End Sub

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.

View 2 Replies

Forms Data Controls :: Merge Gridview Cells That Have Same Data In Column

Mar 18, 2010

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.

View 3 Replies

Web Forms :: Export Only Specific Columns Of GridView To Excel

May 27, 2012

I know how to export GridView to excel but it exports all Columns

I want to export only some columns and not all of ASP.Net GridView to excel.

View 1 Replies

Forms Data Controls :: Gridview - Export To Excel And Formatting Excel From Right To Left

Jun 10, 2010

How can I export data from a Gridview to excel and once exported the data should be formatted in right to left (arabic) manner. How can I achieve this?

View 2 Replies

Forms Data Controls :: Export Gridview To Ms Excel - Set Excel Page Orientation As Landscape

Jan 22, 2010

I am exporting a gridview in MS Excel as mentioned in the following link:

[URL]

I want to set orientation of excel pages as landscape. Is there any way to do that? Any header information to be added for file being exported to set orientation of pages as landscape?

View 2 Replies

Forms Data Controls :: Exporting Gridview Into Excel Is Not Generating The Result On Excel File?

Apr 1, 2010

when I used a code of exporting gridview into excel this code worked for a new website which is without masterpage.

my code:

public override void VerifyRenderingInServerForm(Control control) { }
protected void BtnGenerateReport_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition",
"attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
StringWriter sw = new StringWriter();.....

Now the same code when I copy it in my project having masterpage . there is no compiler error but it is genereating excel file withno data in it but in fact there is data in the grid view at runtime.

View 2 Replies

Forms Data Controls :: GridView Header Column Merge Is Not Working / Fire Row Command Event

Mar 10, 2011

I have made Gridview and it has 5 columns.

Col1 Col 2 Col3 Col4 Col5

I try to make like below:

Col1 Col2
col2 col3 col4 col5

First column is as it is. But next 4 columns I try to make merge from Gridview Row Databound Event. It's working.

I have a link button in column1 and when I click on it, Row Command is fire and at that time the merge is gone. And Last row comes in footer row.

View 4 Replies

Data Controls :: Merge Row Cells In GridView Using C#

Jun 2, 2013

In datagridview records as follows;

Date     Session

6-jun     1 6-jun     2 6-jun    3 6-jun    4

from the above datagridview records i want as follows

  Date     Session

                 1

                 2

 6-jun        3

                 4

for that how can i merge the date in datagridview make it into single column.

Note it is windows application.

View 1 Replies

Data Controls :: Merge Table Cells And Rows In Gridview

Jan 3, 2013

how to merge cell in gridview?

let say :

name  | age |  sex           |

          |        |male|female|

i will merge column sex .

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved