Hi,

I want to make a GridView display data horizontaly instead of vertically. Normally if the column names are is what the header should be it would be right as it is, but in my case the column names is in one table and the values in another table.

I've attached a image that shows how I want it to be displayed and how it looks like now, and also the structure of the tables in the Database.

The SQL Query looks like this:

---------------------------------------------------------

SELECT p.name, a.val

FROM [ARTIKEL_Details] a

LEFT OUTER JOIN ARTIKEL_Fields p

ON a.id_field = p.id_field

WHERE a.ARTNR = @ArtGet

---------------------------------------------------------

I have a queryString from that's linked from another page with the Article number like this:

- article.aspx?artnr=[ArticleNumber]

Have attached the code to the page so you could look on.

So, is there a way of doing this with the grid view or any other way?

The reason I want to do it this way is becouse the table with the column names (ARTIKEL_Field) have about 480 values, and having all values doesn't have a value in ARTIKEL_Details.

And a table with 480 Columns wouldn't be any good at all.

Hope you getting the idea of what I'm trying to do and please ask if there's any questions.

// Tobias

//article.aspx
 
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="article.aspx.cs" Inherits="article" %>
 
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
    .style1
    {
        text-decoration: underline;
    }
</style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentHolder" Runat="Server">
    <p>
        <span class="style1">Visar Artikel</span><b>
        <asp:Label ID="ArticleLabel" runat="server" Text="[Artnr]"></asp:Label>
        </b>
     </p>
    <p>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" DataSourceID="ViewArticle" ForeColor="#333333" 
            GridLines="None" AllowSorting="True">
            <RowStyle BackColor="#EFF3FB" />
            <Columns>
                <asp:BoundField DataField="name" HeaderText="Fält" SortExpression="name" >
                <ControlStyle Font-Bold="True" />
                <ItemStyle Font-Bold="True" HorizontalAlign="Right" />
                </asp:BoundField>
                <asp:BoundField DataField="val" HeaderText="Värde" SortExpression="val" />
            </Columns>
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#2461BF" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>
        <asp:SqlDataSource ID="ViewArticle" runat="server" 
            ConnectionString="<%$ ConnectionStrings:DuellsCM5ConnectionString %>" SelectCommand="SELECT p.name, a.val 
 
FROM [ARTIKEL_Details] a 
 
LEFT OUTER JOIN ARTIKEL_Fields p
 
ON a.id_field = p.id_field
 
WHERE a.ARTNR = @ArtGet">
            <SelectParameters>
                <asp:QueryStringParameter ConvertEmptyStringToNull="False" Name="ArtGet" 
                    QueryStringField="artnr" Size="50" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    </p>
</asp:Content>
 
//article.aspx.cs
 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
 
public partial class article : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        String artnr = Request.QueryString["artnr"].ToString();
        ArticleLabel.Text = artnr;
    }
}

Select allOpen in new window

gridView.jpg