473,324 Members | 2,124 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

how to approach unique user views

I currently have 2 databases with one website per DB. The databases are
simple collections of views and some tables holding keys for the views -
these DBs are exact copies of eachother, other than the item values needed
to generate different views. The two websites are also identical but simply
require different ConnectionString items to point to the relevant database.

I am happy keeping the separate databases as some of the views, whilst
returning the same columns, may often require a bit of tweaking to satisfy
customer needs.

What I plan on doing is consolidating the web interfaces. It seems that all
I really need to do is assign the appropriate ConnectionString based on the
user logging in. Currently the pages hold the connectionstring info with the
SqlDataSource control:

<asp:SqlDataSource ID="mySqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"
SelectCommand="SELECT * FROM [view1]">
</asp:SqlDataSource>

Q1. would it be possible to store the connectionstring id in a session
variable and have that used at runtime such that ConnectionString points to
a user defined variable?

Q2. what other approaches would be feasible (I'm guessing this nut has been
cracked once or twice before)?

Thanks,
n

Jun 27 '08 #1
1 965
oookay. so I think I am barking up the wrong tree. Membership, Roles &
Profiles seems to be what I am looking for.

Cheers,
n

"Neil Chambers" <no****@nospam.comwrote in message
news:OP**************@TK2MSFTNGP03.phx.gbl...
>I currently have 2 databases with one website per DB. The databases are
simple collections of views and some tables holding keys for the views -
these DBs are exact copies of eachother, other than the item values needed
to generate different views. The two websites are also identical but simply
require different ConnectionString items to point to the relevant database.

I am happy keeping the separate databases as some of the views, whilst
returning the same columns, may often require a bit of tweaking to
satisfy customer needs.

What I plan on doing is consolidating the web interfaces. It seems that
all I really need to do is assign the appropriate ConnectionString based
on the user logging in. Currently the pages hold the connectionstring info
with the SqlDataSource control:

<asp:SqlDataSource ID="mySqlDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"
SelectCommand="SELECT * FROM [view1]">
</asp:SqlDataSource>

Q1. would it be possible to store the connectionstring id in a session
variable and have that used at runtime such that ConnectionString points
to a user defined variable?

Q2. what other approaches would be feasible (I'm guessing this nut has
been cracked once or twice before)?

Thanks,
n
Jun 27 '08 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: luc wastiaux | last post by:
Hello, I am writing an application to handle support requests, and the user needs to have his request number printed out in front of him even before he hits the "submit" button. I have no idea how...
10
by: BuddhaBuddy | last post by:
Platform is DB2/NT 7.2.9 The table was created like this: CREATE TABLE MYTEST ( MYTESTOID bigint not null primary key, FK_OTHEROID bigint not null references other, FK_ANOTHEROID bigint not...
3
by: KemperR | last post by:
Hello Experts outhere, may be someone can tell me whats going wrong with my ADOX trial. I have an Access 2002 database with some tables and queries (views) The code listed below works well up...
2
by: Colleyville Alan | last post by:
I have been working on a project that uses MS Access to get mutual fund performance and write it to a spreadsheet in a formatted manner. The user inputs the company name, the database looks at the...
20
by: Steve Jorgensen | last post by:
Hi all, I've just finished almost all of what has turned out to be a real bear of a project. It has to import data from a monthly spreadsheet export from another program, and convert that into...
2
by: Bill Holmes | last post by:
I have an A2003 front end (mdb) using ado to link the form/subforms to SQL server 2k tables and views. In SQL server, there is a view between 2 tables with a 1-1 relationship. I can edit records...
1
by: Mr Gordonz | last post by:
Hi All, I am building a site that will be used by different types of users, and each type of user will do similar, but substantially different, things. My question is a general one: what is the...
2
by: Kiran | last post by:
Hi, I use a lot of web user controls for web development. And I need all your views on this. (1)Does the functionality(Logic part) of a web user control should be included in the aspx page...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.