473,320 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

display data to user question

I'm stuck on something and I've been trying to find some examples on it. I'm
trying to show the data to my users as such:

year1 year2
Q1 Q2 Q1 Q2
Smith

my dataset looks like this:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<year>2006</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
<Table>

is there any possible way with either the gridview, repeater, datalist,
anything, that I can use to to show my data side by side? Any examples would
help as well and be greatly apprecaited.



Feb 13 '08 #1
7 1542
I can't pinp point you problem. The answer is yes to all of the above. The
trick is to you use template to shape how your data is display. a Repeater
would work also a datalist is even easier.

But since I do not understand your problem is difficult for me to help. For
example
This simple way is to use SQLServerControl or ObjServerControl and follow
instruction. You can drop a datalist click on smart tag select choose Data
Source
and follow wizard instructions.

Suggest you start when you get stuck give us a sample of your code and what
you were trying to achieve then we will be able to help.

Regards,
--
aaa
"Dave" wrote:
I'm stuck on something and I've been trying to find some examples on it. I'm
trying to show the data to my users as such:

year1 year2
Q1 Q2 Q1 Q2
Smith

my dataset looks like this:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<year>2006</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
<Table>

is there any possible way with either the gridview, repeater, datalist,
anything, that I can use to to show my data side by side? Any examples would
help as well and be greatly apprecaited.



Feb 14 '08 #2
I'm just trying to figure out how to do it. I'm calling my stored procedure
and returning a dataset if the format as I described above. So I'm just
trying to figure out how to get my data to show as I need it with the output
format I'm getting from my stored procedure.

I'm not using a SQLServerControl or a ObjServerControl to get my data.
"Angel" <ro******@hotmail.comwrote in message
news:94**********************************@microsof t.com...
>I can't pinp point you problem. The answer is yes to all of the above.
The
trick is to you use template to shape how your data is display. a
Repeater
would work also a datalist is even easier.

But since I do not understand your problem is difficult for me to help.
For
example
This simple way is to use SQLServerControl or ObjServerControl and follow
instruction. You can drop a datalist click on smart tag select choose
Data
Source
and follow wizard instructions.

Suggest you start when you get stuck give us a sample of your code and
what
you were trying to achieve then we will be able to help.

Regards,
--
aaa
"Dave" wrote:
>I'm stuck on something and I've been trying to find some examples on it.
I'm
trying to show the data to my users as such:

year1 year2
Q1 Q2 Q1 Q2
Smith

my dataset looks like this:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<year>2006</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
<Table>

is there any possible way with either the gridview, repeater, datalist,
anything, that I can use to to show my data side by side? Any examples
would
help as well and be greatly apprecaited.



Feb 14 '08 #3
Dave,

I just realized what you were trying to do. What you want to do is to turn
the table on its side basically to display rows as columns. There is no
simple way of forcing the controls to do this. You can shape the data with a
SQL query that actually perform the rotation.

I am working on the example anyway but it would not be as trivial as I first
thought because I misunderstood the problem. So I am not going to be ready
today with this solution as I promise so in the mean-time you can help you
self by reviewing some the info below.

Definition

A pivot table is a data summarization tool found in data visualization
programs such as spreadsheets (e.g. Excel sheet). Among other functions, it
can automatically sort, count, and total the data stored in one table or
spreadsheet and create a second table displaying the summarized data. Pivot
tables are useful to create crosstabs quickly. The user sets up and changes
the summary's structure by dragging and dropping fields graphically. This
"rotation" or pivoting of the summary table gives the concept its name

Checkout these links

http://technet.microsoft.com/en-us/l.../ms177410.aspx

http://jdixon.dotnetdevelopersjourna...0_and_2005.htm

http://www.sqlteam.com/article/dynam...s-pivot-tables

http://www.databasejournal.com/featu...le.php/3516331

Once I have a sample I will posted (if you still need it)

Hope this helps
--
aaa
"Dave" wrote:
I'm stuck on something and I've been trying to find some examples on it. I'm
trying to show the data to my users as such:

year1 year2
Q1 Q2 Q1 Q2
Smith

my dataset looks like this:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<year>2006</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
<Table>

is there any possible way with either the gridview, repeater, datalist,
anything, that I can use to to show my data side by side? Any examples would
help as well and be greatly apprecaited.



Feb 15 '08 #4
I'm doing the pivot table on SQL already.

the data is coming out like this

YEAR Lastname Q1 Q2
-------------------------------------------------------------------

1995 Smith 125,000.90 136,000.75
1996 Smith 328,000.82 422,000.13
so I have the data "flipped" on the SQL side already, so it comes out with
the columns named instead of of the normal output format

year
name
q1
q2

"Angel" <ro******@hotmail.comwrote in message
news:DA**********************************@microsof t.com...
Dave,

I just realized what you were trying to do. What you want to do is to
turn
the table on its side basically to display rows as columns. There is no
simple way of forcing the controls to do this. You can shape the data
with a
SQL query that actually perform the rotation.

I am working on the example anyway but it would not be as trivial as I
first
thought because I misunderstood the problem. So I am not going to be
ready
today with this solution as I promise so in the mean-time you can help you
self by reviewing some the info below.

Definition

A pivot table is a data summarization tool found in data visualization
programs such as spreadsheets (e.g. Excel sheet). Among other functions,
it
can automatically sort, count, and total the data stored in one table or
spreadsheet and create a second table displaying the summarized data.
Pivot
tables are useful to create crosstabs quickly. The user sets up and
changes
the summary's structure by dragging and dropping fields graphically. This
"rotation" or pivoting of the summary table gives the concept its name

Checkout these links

http://technet.microsoft.com/en-us/l.../ms177410.aspx

http://jdixon.dotnetdevelopersjourna...0_and_2005.htm

http://www.sqlteam.com/article/dynam...s-pivot-tables

http://www.databasejournal.com/featu...le.php/3516331

Once I have a sample I will posted (if you still need it)

Hope this helps
--
aaa
"Dave" wrote:
>I'm stuck on something and I've been trying to find some examples on it.
I'm
trying to show the data to my users as such:

year1 year2
Q1 Q2 Q1 Q2
Smith

my dataset looks like this:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<year>2006</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
<Table>

is there any possible way with either the gridview, repeater, datalist,
anything, that I can use to to show my data side by side? Any examples
would
help as well and be greatly apprecaited.




Feb 15 '08 #5
Angel,
Using the sql pivot still won't allow me to show my data side by
side. this thing is driving me nuts

"Angel" <ro******@hotmail.comwrote in message
news:DA**********************************@microsof t.com...
Dave,

I just realized what you were trying to do. What you want to do is to
turn
the table on its side basically to display rows as columns. There is no
simple way of forcing the controls to do this. You can shape the data
with a
SQL query that actually perform the rotation.

I am working on the example anyway but it would not be as trivial as I
first
thought because I misunderstood the problem. So I am not going to be
ready
today with this solution as I promise so in the mean-time you can help you
self by reviewing some the info below.

Definition

A pivot table is a data summarization tool found in data visualization
programs such as spreadsheets (e.g. Excel sheet). Among other functions,
it
can automatically sort, count, and total the data stored in one table or
spreadsheet and create a second table displaying the summarized data.
Pivot
tables are useful to create crosstabs quickly. The user sets up and
changes
the summary's structure by dragging and dropping fields graphically. This
"rotation" or pivoting of the summary table gives the concept its name

Checkout these links

http://technet.microsoft.com/en-us/l.../ms177410.aspx

http://jdixon.dotnetdevelopersjourna...0_and_2005.htm

http://www.sqlteam.com/article/dynam...s-pivot-tables

http://www.databasejournal.com/featu...le.php/3516331

Once I have a sample I will posted (if you still need it)

Hope this helps
--
aaa
"Dave" wrote:
>I'm stuck on something and I've been trying to find some examples on it.
I'm
trying to show the data to my users as such:

year1 year2
Q1 Q2 Q1 Q2
Smith

my dataset looks like this:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<year>2006</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
<Table>

is there any possible way with either the gridview, repeater, datalist,
anything, that I can use to to show my data side by side? Any examples
would
help as well and be greatly apprecaited.



Feb 17 '08 #6
That's interesting because I have something here that I started whre I used
sql to do it. I stop because I figured we had the answer but I will look it
up a gaind and send it to you. The problem is that you want to show the
years followed by name and the Quaters side by side in the appropriate slot
with the years. The Grid will not do this easily. We can pump code to it
manipulate the datatable to provide us the right format but it will not be
simple.

Think if we can do it in t-sql we can do it in code but no matter how you
slice it it will require a significant amount of coding it will not be
trivial.
--
aaa
"Dave" wrote:
Angel,
Using the sql pivot still won't allow me to show my data side by
side. this thing is driving me nuts

"Angel" <ro******@hotmail.comwrote in message
news:DA**********************************@microsof t.com...
Dave,

I just realized what you were trying to do. What you want to do is to
turn
the table on its side basically to display rows as columns. There is no
simple way of forcing the controls to do this. You can shape the data
with a
SQL query that actually perform the rotation.

I am working on the example anyway but it would not be as trivial as I
first
thought because I misunderstood the problem. So I am not going to be
ready
today with this solution as I promise so in the mean-time you can help you
self by reviewing some the info below.

Definition

A pivot table is a data summarization tool found in data visualization
programs such as spreadsheets (e.g. Excel sheet). Among other functions,
it
can automatically sort, count, and total the data stored in one table or
spreadsheet and create a second table displaying the summarized data.
Pivot
tables are useful to create crosstabs quickly. The user sets up and
changes
the summary's structure by dragging and dropping fields graphically. This
"rotation" or pivoting of the summary table gives the concept its name

Checkout these links

http://technet.microsoft.com/en-us/l.../ms177410.aspx

http://jdixon.dotnetdevelopersjourna...0_and_2005.htm

http://www.sqlteam.com/article/dynam...s-pivot-tables

http://www.databasejournal.com/featu...le.php/3516331

Once I have a sample I will posted (if you still need it)

Hope this helps
--
aaa
"Dave" wrote:
I'm stuck on something and I've been trying to find some examples on it.
I'm
trying to show the data to my users as such:

year1 year2
Q1 Q2 Q1 Q2
Smith

my dataset looks like this:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<year>2006</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
<Table>

is there any possible way with either the gridview, repeater, datalist,
anything, that I can use to to show my data side by side? Any examples
would
help as well and be greatly apprecaited.




Feb 17 '08 #7
Yeah that's the point I'm at. I have my data pivoted in SQL, I created a
datatable in code, but getting it to show on the GUI side by side isn't
happening very easy or at all.

"Angel" <ro******@hotmail.comwrote in message
news:62**********************************@microsof t.com...
That's interesting because I have something here that I started whre I
used
sql to do it. I stop because I figured we had the answer but I will look
it
up a gaind and send it to you. The problem is that you want to show the
years followed by name and the Quaters side by side in the appropriate
slot
with the years. The Grid will not do this easily. We can pump code to it
manipulate the datatable to provide us the right format but it will not be
simple.

Think if we can do it in t-sql we can do it in code but no matter how you
slice it it will require a significant amount of coding it will not be
trivial.
--
aaa
"Dave" wrote:
>Angel,
Using the sql pivot still won't allow me to show my data side by
side. this thing is driving me nuts

"Angel" <ro******@hotmail.comwrote in message
news:DA**********************************@microso ft.com...
Dave,

I just realized what you were trying to do. What you want to do is to
turn
the table on its side basically to display rows as columns. There is
no
simple way of forcing the controls to do this. You can shape the data
with a
SQL query that actually perform the rotation.

I am working on the example anyway but it would not be as trivial as I
first
thought because I misunderstood the problem. So I am not going to be
ready
today with this solution as I promise so in the mean-time you can help
you
self by reviewing some the info below.

Definition

A pivot table is a data summarization tool found in data visualization
programs such as spreadsheets (e.g. Excel sheet). Among other
functions,
it
can automatically sort, count, and total the data stored in one table
or
spreadsheet and create a second table displaying the summarized data.
Pivot
tables are useful to create crosstabs quickly. The user sets up and
changes
the summary's structure by dragging and dropping fields graphically.
This
"rotation" or pivoting of the summary table gives the concept its name

Checkout these links

http://technet.microsoft.com/en-us/l.../ms177410.aspx

http://jdixon.dotnetdevelopersjourna...0_and_2005.htm

http://www.sqlteam.com/article/dynam...s-pivot-tables

http://www.databasejournal.com/featu...le.php/3516331

Once I have a sample I will posted (if you still need it)

Hope this helps
--
aaa
"Dave" wrote:

I'm stuck on something and I've been trying to find some examples on
it.
I'm
trying to show the data to my users as such:

year1 year2
Q1 Q2 Q1 Q2
Smith

my dataset looks like this:
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table>
<year>2006</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smith</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
<Table>

is there any possible way with either the gridview, repeater,
datalist,
anything, that I can use to to show my data side by side? Any examples
would
help as well and be greatly apprecaited.




Feb 17 '08 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: StepH | last post by:
Hi, I'm building a little application, which the goal is to: 1./ Collect data via Serial line and or via a file (for playback). 2./ Display these data as graph, oscilloscope, ... How manage...
4
by: Scott Vercuski | last post by:
Hello All, I'm having a problem saving/displaying multiple lanaguages on an ASP page. Here's the general problem I'm having. I have an admin area of a website that allows a user to enter items...
1
by: Joe D | last post by:
I think this is a simple question. But I am new to JS. Here is what I want to do: From a parent window, open a popup window (child) to get data from user, then user submit the request, close the...
19
by: dmiller23462 | last post by:
Hi guys....I have absolutely NO IDEA what I'm doing with Javascript but my end result is I need two text boxes to stay hidden until a particular option is selected....I've cobbled together the...
2
by: Irwinsp | last post by:
Hi All, I have a form with an auto number field displayed. The field looks great except when the user is entering a new record. The field then has the text "auto number" in it. Is there a...
5
by: Will | last post by:
I've got a simple form that collects data from a user and I want to display that data in a sortable grid or table. The nature of this data is rather temporary, so there's no need to persist it to a...
18
by: Alpha | last post by:
Hi, I'm working on a Windows applicaton with VS 2003 on windows 2000. I have a listbox that I have binded to a dataset table, "source" which has 3 columns. I would like to display 2 of those...
11
by: Webbert | last post by:
I am trying to display XML in a WebBrowser Control. I receive a data feed of XML and am trying to inject it into the control. I have not been successful in doing so. The only solution I have...
4
by: Jono | last post by:
Hi Everyone, As it says in the title, I'm looking for a way to display a page while long running operations are performed on the server. Ideally, I'd like some way to push the current request...
3
by: phil67b | last post by:
Hello everybody, I have a page rech.php where I'm doing a multi-criteria research Ex. choose your car model, choose your country. After validation of my form, on the same page, the lines will be...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.