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  2577 
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: 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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
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...
| |
