Dear Members,
I am using asp.net application C#. In an application i have use "DATATABLE" for binding grid. I have avoid "VIEWSTATE" for stored "DATATABLE" for handling pagination. For that purpose i create a "Public Class", into that class i define "public static DataTable dt_GetMenus = new DataTable()" and use in entire application properly.
I have create services for database manipulation which is act as database layer in our application.
I have create two different databases "SAMPLE1" AND "SAMPLE2" with different data and hosted site in IIS. I have two uses "USER1" for "SAMPLE1" and "USER2" for "SAMPLE2".
Issue :
while "USER1" login to application with "SAMPLE1" database and "USER2" with "SAMPLE2" (send database name dynamically by using login page.) then after refresh or paging first user automatically find details of USER2 for same page.
Exa:
We have grid view
For USER1 details
ON FISRT PAGE
Country Name | Status | Default Country
-------------------------------------------------
India | Activated | Yes
US | Activated | No
ABC1 | Activated | No
ABC2 | Activated | No
ABC3 | Activated | No
ON SECOND PAGE
Country Name | Status | Default Country
--------------------------------------------------
ABC4 | Activated | No
ABC5 | Activated | No
ABC6 | Activated | No
ABC7 | Activated | No
ABC8 | Activated | No
For USER2 details
N FISRT PAGE
Country Name | Status | Default Country
-------------------------------------------------
XYZ1 | Activated | Yes
XYZ2 | Activated | No
XYZ3 | Activated | No
XYZ4 | Activated | No
After refresh or paging USER1 automatically see details of user 2 on his page if both using browsing same page for different database vice versa.
Session id for the both user are different because session variable does not changes i have checked for the session.
I am not able to find out solution for the same. Please guide me or provide any solution for the same.
Thanks
Chetan Chopkar