I am displaying a table of information on a web page, using an asp:table
that I populate dynamically. On this page I give the user the options to
group the rows by certain fields, and/or filter the contents on certain
fields. The grouping/filtering is "remembered " for each user via a cookie.
The problem is works like this:
User A applies a filter on Project Manager.
User B filters by Department.
User B groups by Project Manager (NOTE - this is the key - they are grouping
by what user A filters on)
When the page refreshes, User B's table correctly grouped by Project
manager, but is also FILTERED by project manager (even tho user B's cookie
correctly says filter by department).
Is DataTable.selec t NOT unique between separate users?? Or is asp:table not
unique??
Here's how I build things:
I have a dataview object that I populate from 2 different databases.
I then read the user's cookies for filtering and grouping.
I then create and popluate a DataTable using DataView.Table.
I then apply the filter/grouping on the DataTable using
DataTable..Sele ct(filterBy,gro upBy)
I then populate the asp:table row by row, with the proper grouping/filter.
This all works just fine (grouping/filtering) with a single user using the
web site. However, as described above, it appears that one user's filter
settings are getting applied to a subsequent user. (We can replicate this at
will.)
This doesn't seem to be a problem with grouping, just filtering. (That is,
User A's grouping is not getting applied to User B, just the filtering)
Can someone help me understand what is going on? Shouldn't each user be in
their own IIS session, with their own objects? It appears that either the
DataTable, or the asp:table are being shared across sessions, which I just
don't understand.
Any help at all would be most appreciated!
Thanks!
--
Kris Rudin, MS, MCP
Aurora Consulting Group, Inc.
4  2575 
Kris,
What does your database logic look like (stored proc,
etc.)? Are you using any temp tables or global temp
tables? Is it a SQL Server backend?
Server controls are instantiated for each request to the
page, but connections to your database are pooled by
default. If you have any database objects that are tied
to the connection, it is possible that one user might
create them and another user might use them.
Just a thought.
Frank -----Original Message-----
I am displaying a table of information on a web page,
using an asp:tablethat I populate dynamically. On this page I give the
user the options togroup the rows by certain fields, and/or filter the
contents on certainfields. The grouping/filtering is "remembered " for each
user via a cookie.
The problem is works like this:
User A applies a filter on Project Manager.
User B filters by Department.
User B groups by Project Manager (NOTE - this is the
key - they are groupingby what user A filters on)
When the page refreshes, User B's table correctly
grouped by Projectmanager, but is also FILTERED by project manager (even
tho user B's cookiecorrectly says filter by department).
Is DataTable.selec t NOT unique between separate users??
Or is asp:table notunique??
Here's how I build things:
I have a dataview object that I populate from 2
different databases.I then read the user's cookies for filtering and
grouping.I then create and popluate a DataTable using
DataView.Table.I then apply the filter/grouping on the DataTable using
DataTable..Sel ect(filterBy,gr oupBy)
I then populate the asp:table row by row, with the
proper grouping/filter.
This all works just fine (grouping/filtering) with a
single user using theweb site. However, as described above, it appears that
one user's filtersettings are getting applied to a subsequent user. (We
can replicate this atwill.)
This doesn't seem to be a problem with grouping, just
filtering. (That is,User A's grouping is not getting applied to User B, just
the filtering)
Can someone help me understand what is going on?
Shouldn't each user be intheir own IIS session, with their own objects? It
appears that either theDataTable, or the asp:table are being shared across
sessions, which I justdon't understand.
Any help at all would be most appreciated!
Thanks!
--
Kris Rudin, MS, MCP
Aurora Consulting Group, Inc.
.
Kris,
What does your database logic look like (stored proc,
etc.)? Are you using any temp tables or global temp
tables? Is it a SQL Server backend?
Server controls are instantiated for each request to the
page, but connections to your database are pooled by
default. If you have any database objects that are tied
to the connection, it is possible that one user might
create them and another user might use them.
Just a thought.
Frank -----Original Message-----
I am displaying a table of information on a web page,
using an asp:tablethat I populate dynamically. On this page I give the
user the options togroup the rows by certain fields, and/or filter the
contents on certainfields. The grouping/filtering is "remembered " for each
user via a cookie.
The problem is works like this:
User A applies a filter on Project Manager.
User B filters by Department.
User B groups by Project Manager (NOTE - this is the
key - they are groupingby what user A filters on)
When the page refreshes, User B's table correctly
grouped by Projectmanager, but is also FILTERED by project manager (even
tho user B's cookiecorrectly says filter by department).
Is DataTable.selec t NOT unique between separate users??
Or is asp:table notunique??
Here's how I build things:
I have a dataview object that I populate from 2
different databases.I then read the user's cookies for filtering and
grouping.I then create and popluate a DataTable using
DataView.Table.I then apply the filter/grouping on the DataTable using
DataTable..Sel ect(filterBy,gr oupBy)
I then populate the asp:table row by row, with the
proper grouping/filter.
This all works just fine (grouping/filtering) with a
single user using theweb site. However, as described above, it appears that
one user's filtersettings are getting applied to a subsequent user. (We
can replicate this atwill.)
This doesn't seem to be a problem with grouping, just
filtering. (That is,User A's grouping is not getting applied to User B, just
the filtering)
Can someone help me understand what is going on?
Shouldn't each user be intheir own IIS session, with their own objects? It
appears that either theDataTable, or the asp:table are being shared across
sessions, which I justdon't understand.
Any help at all would be most appreciated!
Thanks!
--
Kris Rudin, MS, MCP
Aurora Consulting Group, Inc.
.
Frank,
Good thoughts.
I do a straight SQL query to populate the dataview object, initially. This
is done onPageLoad, regardless of PostBack or not. The SQL query just gets
EVERYTHING. Then I do the process I outlined, where I create the DataTable
from the DataView.Table, read the cookies, and then apply the
filtering/grouping in the select method of the DataTable object. Lastly I
build the asp:table from the rows returned from the DataTable.selec t().
Since the SQL query is not grouping/filtering, I'm not sure this is the
problem. I am filtering/grouping on the datatable, not when I first create
the DataView using the SQL query.
Any other thoughts?
Kris
"Frank Wilson" <fr************ *****@hotmail.c om> wrote in message
news:04******** *************** *****@phx.gbl.. . Kris,
What does your database logic look like (stored proc,
etc.)? Are you using any temp tables or global temp
tables? Is it a SQL Server backend?
Server controls are instantiated for each request to the
page, but connections to your database are pooled by
default. If you have any database objects that are tied
to the connection, it is possible that one user might
create them and another user might use them.
Just a thought.
Frank
-----Original Message-----
I am displaying a table of information on a web page,
using an asp:tablethat I populate dynamically. On this page I give the
user the options togroup the rows by certain fields, and/or filter the
contents on certainfields. The grouping/filtering is "remembered " for each
user via a cookie.
The problem is works like this:
User A applies a filter on Project Manager.
User B filters by Department.
User B groups by Project Manager (NOTE - this is the
key - they are groupingby what user A filters on)
When the page refreshes, User B's table correctly
grouped by Projectmanager, but is also FILTERED by project manager (even
tho user B's cookiecorrectly says filter by department).
Is DataTable.selec t NOT unique between separate users??
Or is asp:table notunique??
Here's how I build things:
I have a dataview object that I populate from 2
different databases.I then read the user's cookies for filtering and
grouping.I then create and popluate a DataTable using
DataView.Table.I then apply the filter/grouping on the DataTable using
DataTable..Sel ect(filterBy,gr oupBy)
I then populate the asp:table row by row, with the
proper grouping/filter.
This all works just fine (grouping/filtering) with a
single user using theweb site. However, as described above, it appears that
one user's filtersettings are getting applied to a subsequent user. (We
can replicate this atwill.)
This doesn't seem to be a problem with grouping, just
filtering. (That is,User A's grouping is not getting applied to User B, just
the filtering)
Can someone help me understand what is going on?
Shouldn't each user be intheir own IIS session, with their own objects? It
appears that either theDataTable, or the asp:table are being shared across
sessions, which I justdon't understand.
Any help at all would be most appreciated!
Thanks!
--
Kris Rudin, MS, MCP
Aurora Consulting Group, Inc.
.
Frank,
Good thoughts.
I do a straight SQL query to populate the dataview object, initially. This
is done onPageLoad, regardless of PostBack or not. The SQL query just gets
EVERYTHING. Then I do the process I outlined, where I create the DataTable
from the DataView.Table, read the cookies, and then apply the
filtering/grouping in the select method of the DataTable object. Lastly I
build the asp:table from the rows returned from the DataTable.selec t().
Since the SQL query is not grouping/filtering, I'm not sure this is the
problem. I am filtering/grouping on the datatable, not when I first create
the DataView using the SQL query.
Any other thoughts?
Kris
"Frank Wilson" <fr************ *****@hotmail.c om> wrote in message
news:04******** *************** *****@phx.gbl.. . Kris,
What does your database logic look like (stored proc,
etc.)? Are you using any temp tables or global temp
tables? Is it a SQL Server backend?
Server controls are instantiated for each request to the
page, but connections to your database are pooled by
default. If you have any database objects that are tied
to the connection, it is possible that one user might
create them and another user might use them.
Just a thought.
Frank
-----Original Message-----
I am displaying a table of information on a web page,
using an asp:tablethat I populate dynamically. On this page I give the
user the options togroup the rows by certain fields, and/or filter the
contents on certainfields. The grouping/filtering is "remembered " for each
user via a cookie.
The problem is works like this:
User A applies a filter on Project Manager.
User B filters by Department.
User B groups by Project Manager (NOTE - this is the
key - they are groupingby what user A filters on)
When the page refreshes, User B's table correctly
grouped by Projectmanager, but is also FILTERED by project manager (even
tho user B's cookiecorrectly says filter by department).
Is DataTable.selec t NOT unique between separate users??
Or is asp:table notunique??
Here's how I build things:
I have a dataview object that I populate from 2
different databases.I then read the user's cookies for filtering and
grouping.I then create and popluate a DataTable using
DataView.Table.I then apply the filter/grouping on the DataTable using
DataTable..Sel ect(filterBy,gr oupBy)
I then populate the asp:table row by row, with the
proper grouping/filter.
This all works just fine (grouping/filtering) with a
single user using theweb site. However, as described above, it appears that
one user's filtersettings are getting applied to a subsequent user. (We
can replicate this atwill.)
This doesn't seem to be a problem with grouping, just
filtering. (That is,User A's grouping is not getting applied to User B, just
the filtering)
Can someone help me understand what is going on?
Shouldn't each user be intheir own IIS session, with their own objects? It
appears that either theDataTable, or the asp:table are being shared across
sessions, which I justdon't understand.
Any help at all would be most appreciated!
Thanks!
--
Kris Rudin, MS, MCP
Aurora Consulting Group, Inc.
. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Sam G |
last post by:
Hi folks,
What I'd like to do for a website I'm designing with PHP/MySQL is have
a number of registered users who can make friends with each other...
so if person 1 wants to be friends with person 2, 1 can add 2 and then
they will be recognized as friends. I also want, if person 3 is
friends with 2, and goes to person 1's page, person 3 will see that 1
is friends with 2 who is 3's friend. So 3 can see the connections that
lead him to...
|
by: Randy |
last post by:
I have a DataTable in a DataGrid.
If I click on the DataGrid, HitTestInfo in dataGrid1_MouseDown returns a Row
and Column number. I can use the Row number to say:
DataRow dr = dataTable.Rows;
Of course, I get completely the wrong row of data if the user has sorted the
table by clicking any of the column headers.
|
by: Bajgon |
last post by:
Hello,
I have got a DataGrid and a DataTable, which is its DataSource.
I can use DataTable.Rows.Find(key_value) method to locate any row
in the DataTable, using values of key column. The result is a DataRow
object.
How to find and select the current position of this DataRow in
the DataGrid control?
|
by: Kris Rudin |
last post by:
I am displaying a table of information on a web page, using an asp:table
that I populate dynamically. On this page I give the user the options to
group the rows by certain fields, and/or filter the contents on certain
fields. The grouping/filtering is "remembered" for each user via a cookie.
The problem is works like this:
User A applies a filter on Project Manager.
User B filters by Department.
User B groups by Project Manager (NOTE -...
|
by: Gary |
last post by:
Hi,
I have a DataTable, which will have 2 Columns, one column holds Unique
values.
I will use DataTable.Select(Unique value) and Filter the Matching rows,
After filtering those rows I want to Delete those rows from the datatable.
Is it possible to remove the filtered rows and reflect back to the
| | |
by: Marcel Hug |
last post by:
Hi NG!
With a Inner-Join SQL I get my datas in a DataSet.
In the table are the column Entry and Version.
Like this:
Entry Version
1 1
1 2
1 3
|
by: Lars E |
last post by:
Hi all
I have a small problem.
I have a datatable with 8 columns. But it is only data in 5 of the columns.
Data for the remaing 3 columns is in another dataset.
I Want to run trough the datatable and fill out the remaining data.
My code so far:
if (this.fetch("custinfo", "fetchCustInfo", out customers, parameters))
|
by: Doug Bell |
last post by:
Hi,
I have a DataSet with a DataTable that has a number of duplicate rows
(except for one column that has a unique value).
Each row has OrderNo, OrderLineNo, etc and there are multiple rows with
the same OrderNo and OrderLineNo.
I need to display data in a DataGrid but displaying only one record for each
OrderNo OrderLineNo.
|
by: Nuno Magalhaes |
last post by:
Hello,
I have a DataTable in which the items are of type MyClass.
How can I use Select to compare a MyClass instance with the DataTable?
Is there any overriden method (like the ToString()) to use it on
Select?
Thank you,
Nuno Magalhães.
|
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: 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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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...
| |
