Gudorian
asked on
Make GridView display data horizontaly instead of vertically
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=[Articl eNumber]
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
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=[Articl
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;
}
}
gridView.jpg
not sure if this is going to help you but have you tried detailsview?
ASKER
Did test it out, the problem there was it put the data Like this
-------------------------- ---------- ---------- ------
Fält | Benämning ESS
-------------------------- ---------- ---------- ------
Beskrivning | Handtag ATV gummi svart/grå
-------------------------- ---------- ---------- ------
Only one value was shown in the results.
--------------------------
Fält | Benämning ESS
--------------------------
Beskrivning | Handtag ATV gummi svart/grå
--------------------------
Only one value was shown in the results.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL Reporting might help, but that's a long shot...
ASKER
It says there you could use "RepeatDirection" and "RepeatColumns", but I don't get how to apply it to the DataView.
Is it also possible to make the data From the "ARTIKEL_Field" table to be show at the top
and then add multiple rows from "ARTIKEL_Details" beneth it?
I may have to do this later.
Is it also possible to make the data From the "ARTIKEL_Field" table to be show at the top
and then add multiple rows from "ARTIKEL_Details" beneth it?
I may have to do this later.
check out DataList control which has RepeatColumn and RepeatDirection properties
you will not find it in dataview.
you will not find it in dataview.
ASKER
Ah, I got it, was trying to apply it on a DetailsView. Thanks for the help
ASKER
thx