Horizontally repeat data in gridview

Question

my current GridView_RowDataBound displays data like :

A B C D E

i would like to display it like :

A
B
C
D
E

is there an easy way about this?

im not sure if this is possible with Gridview, i dont have any code in my .cs end of the GridView_RowDataBound.

currently the data is being repeated vertically on the excel export, i would like it to be horizontal

thnx

<asp:Panel ID="Panel11" runat="server">
                        <span style="background-color: #">
                        <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="false" EnableModelValidation="True" 
                            onrowdatabound="GridView4_RowDataBound" ShowHeader="False" Visible="false"  
                            Width="700px">
                            <Columns>


                                 <asp:TemplateField HeaderText="Test">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Test") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                    <ItemTemplate>
                                    <asp:Label ID="Label1" runat="server" BackColor="Fuchsia" 
                                            Text='<%# Bind("Test") %>'></asp:Label>

                                    </ItemTemplate>
                                </asp:TemplateField>





                                 <asp:TemplateField HeaderText="Test2">
                                    <EditItemTemplate>
                                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("Test2") %>'></asp:TextBox>
                                    </EditItemTemplate>
                                    <ItemTemplate>
                                   <asp:Label ID="Label2" runat="server" BackColor="Fuchsia" 
                                            Text='<%# Bind("Test2") %>'></asp:Label>

                                    </ItemTemplate>
                                </asp:TemplateField>

                            </Columns>

                            <EmptyDataRowStyle Height="6px" />
                            <FooterStyle Height="4px" />
                            <HeaderStyle Font-Size="X-Small" Height="10px" />
                            <RowStyle Font-Size="X-Small" Height="6px" HorizontalAlign="Left" 
                                VerticalAlign="Top" />
                        </asp:GridView>

                    </asp:Panel>

`GridView` repeats data vertically by default, so i don't understand the question. — Tim Schmelter, Jan 08 '14 at 13:31
perhaps the op means only one row but with multiple columns which (s)he wants to transpose? — Abhitalks, Jan 08 '14 at 13:35
@TimSchmelter sorry i would like it repeated horizontally. :) — user2910569, Jan 08 '14 at 13:40
@user2910569: You can use a `DataList` which has a `RepeatDirection` property. — Tim Schmelter, Jan 08 '14 at 13:49
@ShoaibShaikh im fairly new to asp... any chance you could show me how the listview code would look? — user2910569, Jan 08 '14 at 13:50
@TimSchmelter will that effect my excel export in anyway? thnx — user2910569, Jan 08 '14 at 13:50
yes, it will affect your excel export as ListView need layout defination but user. it don't write everything in table as GridView does — Shoaib Shaikh, Jan 08 '14 at 13:52
@user2910569: i assume you're exporting html, so no, a `DataList` will also be rendered as table. But i would suggest to create real excel files anyway. For example by using the free epplus dll. — Tim Schmelter, Jan 08 '14 at 13:53
@user2910569: yes, probably by using `RenderControl` on the `GridView`/`DataList`. That works as excel understands html but you're not creating real excel files. That's why i've mentioned EPPlus. This can render real xlsx-excel files which can be opened with MS-Excel. — Tim Schmelter, Jan 08 '14 at 14:11

score 1 · Accepted Answer · edited May 23 '17 at 12:01

1

Well with GridView you can't do it.. have a look at the details below. What you want is a FlowLayout that is not supported in GridView.

enter image description here

If you are more concerned about export in excel. i would suggest to use OpenOfficeXML to export data to xls from DataTables as mentioned in the articles below:

http://openxmldeveloper.org/discussions/development_tools/f/35/t/6033.aspx

Export DataTable to Excel with Open Xml SDK in c#

edited May 23 '17 at 12:01

Community

1
1

answered Jan 08 '14 at 13:51

Shoaib Shaikh

4,565
1
27
35

will the flow layout datalist effect my excel export? – user2910569 Jan 08 '14 at 14:12
check edited answer for the export functionality. – Shoaib Shaikh Jan 08 '14 at 14:31

Horizontally repeat data in gridview

1 Answers1

Linked