display data to user question

[Dave]

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>Smit h</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>

</Table>
<Table>
<year>2005</year>
<SalesName>Smit h</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.

[=?Utf-8?B?QW5nZWw=?=]

RE: display data to user question

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 SQLServerContro l or ObjServerContro l 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>Smit h</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
>
</Table>
<Table>
<year>2005</year>
<SalesName>Smit h</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.
>
>
>
>
>
>
>
>

[Dave]

Re: display data to user question

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 SQLServerContro l or a ObjServerContro l to get my data.


"Angel" <rodoopus@hotma il.comwrote in message
news:947BD42B-7337-4CDC-B31B-55BDA91CC7EE@mi crosoft.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 SQLServerContro l or ObjServerContro l 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>Smit h</SalesName>
> <Q1>25</Q1>
> <Q2>50</Q2>
>>
> </Table>
> <Table>
> <year>2005</year>
> <SalesName>Smit h</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.
>>
>>
>>
>>
>>
>>
>>
>>

[=?Utf-8?B?QW5nZWw=?=]

RE: display data to user question

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/library/ms177410.aspx

http://jdixon.dotnetdevelopersjournal.com/pivot_table_data_in_sql_server_2000_and_2005.htm

http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables

http://www.databasejournal.com/features/mssql/article.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>Smit h</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
>
</Table>
<Table>
<year>2005</year>
<SalesName>Smit h</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.
>
>
>
>
>
>
>
>

[Mike]

Re: display data to user question

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" <rodoopus@hotma il.comwrote in message
news:DAF41379-5B4A-4FF4-BFE8-3E64D5D7E16E@mi crosoft.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/library/ms177410.aspx

>

http://jdixon.dotnetdevelopersjournal.com/pivot_table_data_in_sql_server_2000_and_2005.htm

>

http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables

>

http://www.databasejournal.com/features/mssql/article.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>Smit h</SalesName>
> <Q1>25</Q1>
> <Q2>50</Q2>
>>
> </Table>
> <Table>
> <year>2005</year>
> <SalesName>Smit h</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.
>>
>>
>>
>>
>>
>>
>>
>>

[Dave]

Re: display data to user question

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

"Angel" <rodoopus@hotma il.comwrote in message
news:DAF41379-5B4A-4FF4-BFE8-3E64D5D7E16E@mi crosoft.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/library/ms177410.aspx

>

http://jdixon.dotnetdevelopersjournal.com/pivot_table_data_in_sql_server_2000_and_2005.htm

>

http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables

>

http://www.databasejournal.com/features/mssql/article.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>Smit h</SalesName>
> <Q1>25</Q1>
> <Q2>50</Q2>
>>
> </Table>
> <Table>
> <year>2005</year>
> <SalesName>Smit h</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.
>>
>>
>>
>>
>>
>>
>>
>>

[=?Utf-8?B?QW5nZWw=?=]

Re: display data to user question

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" <rodoopus@hotma il.comwrote in message
news:DAF41379-5B4A-4FF4-BFE8-3E64D5D7E16E@mi crosoft.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/library/ms177410.aspx

http://jdixon.dotnetdevelopersjournal.com/pivot_table_data_in_sql_server_2000_and_2005.htm

http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables

http://www.databasejournal.com/features/mssql/article.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>Smit h</SalesName>
<Q1>25</Q1>
<Q2>50</Q2>
>
</Table>
<Table>
<year>2005</year>
<SalesName>Smit h</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.
>
>
>
>
>
>
>
>

>
>

[Dave]

Re: display data to user question

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" <rodoopus@hotma il.comwrote in message
news:620D03D3-07AE-4602-B99A-908E07C8A5D5@mi crosoft.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" <rodoopus@hotma il.comwrote in message
>news:DAF4137 9-5B4A-4FF4-BFE8-3E64D5D7E16E@mi crosoft.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/library/ms177410.aspx

>

http://jdixon.dotnetdevelopersjournal.com/pivot_table_data_in_sql_server_2000_and_2005.htm

>

http://www.sqlteam.com/article/dynamic-cross-tabs-pivot-tables

>

http://www.databasejournal.com/features/mssql/article.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>Smit h</SalesName>
> <Q1>25</Q1>
> <Q2>50</Q2>
>>
> </Table>
> <Table>
> <year>2005</year>
> <SalesName>Smit h</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.
>>
>>
>>
>>
>>
>>
>>
>>

>>
>>