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. 7 1568
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.
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" <ro******@hotma il.comwrote in message
news:94******** *************** ***********@mic rosoft.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.
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>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.
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******@hotma il.comwrote in message
news:DA******** *************** ***********@mic rosoft.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>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.
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******@hotma il.comwrote in message
news:DA******** *************** ***********@mic rosoft.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>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.
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******@hotma il.comwrote in message
news:DA******** *************** ***********@mic rosoft.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>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.
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******@hotma il.comwrote in message
news:62******** *************** ***********@mic rosoft.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******@hotma il.comwrote in message news:DA******* *************** ************@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/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>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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 this ?
1./ Is each "display" must responsible to acquire/read the data ?
|
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 in multiple
languages. EX:
NAME LANGUAGE
Trade Show English
商业展览 Chinese
|
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 child window, an ASP
page is generated from server and displayed with data in parent
window, rather than child window. Right now, I can display in child
window. But do not know how to display in parent.
TIA
|
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 JavaScript
in this code from a couple different sites but I'm not 100% sure what
each line is doing...This is the ASP code that I'm using for the
page....Take a look at the JavaScript code and please let me know what
each line is doing....I have been...
|
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 better way to display this field. I thought
the number assigned to this record should be displayed while the user is
entering the rest of the form data.
Thanks,
Paula
| |
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 database. Searching through
the Framework documentation, everything I've seen reggarding a grids and
tables seems to require a connection to a database. My guess is I'm just
missing something. What classes can I use to display sortable data in a...
|
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 columns, "scode" and "sname", as 1 column
(if not possible then 2 columns will be fine) in the listbox. Can the
listbox display 2 columns information from the dataset and how can I do that?
Also, I set the property of the listbox to selectionmode...
|
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 found is to write it to a temp file and then use
the Navigate method to load it. As the control is capable of loading it from
disk, I would like to find a way to skip the save/load and just inject.
Thanks,
Dave
|
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 onto some stack, where it would
continue to be processed asynchronously (most importantly preserving
things like view state, form post data, etc). In the interim, while the
main request is processed, a friendly page will be displayed to the
user....
|
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
displayed (I put a max limitation of 500 lines). Ex. list of cars Fiat
to buy in UK.
A clic on a line will bring me to the display page disp.php Ex. I will
clic on the car n° 5 =<a href="disp.php?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |