Arg81
Well-known member
Hey,
I've now started venturing into ASP.net, and am trying to put together my VB.net app into ASP (2.0)
I have created users, and 3 roles, specifically UK, Aus, Thai.
I want all 3 sites to use the same application (all the same pages, etc) but I want the connection string to change accordingly to their location, i.e. their role.
So I have 1 front end application and 3 back end databases (MS SQL 2000). I've got this working in my VB.net app, by using a global variable of UKUser, AusUser, ThaiUser and setting the relevant one to True, and the other 2 to False. Then on each form load, I run a sub that will set all the dataAdapter connection strings to the correct database.
...Just wondered if there was some similar way to do this in ASP.net, as I need to make the app accessible to all 3 sites, and I'd prefer just to have the one application controlling it all.
Kind Regards
Luke
I've now started venturing into ASP.net, and am trying to put together my VB.net app into ASP (2.0)
I have created users, and 3 roles, specifically UK, Aus, Thai.
I want all 3 sites to use the same application (all the same pages, etc) but I want the connection string to change accordingly to their location, i.e. their role.
So I have 1 front end application and 3 back end databases (MS SQL 2000). I've got this working in my VB.net app, by using a global variable of UKUser, AusUser, ThaiUser and setting the relevant one to True, and the other 2 to False. Then on each form load, I run a sub that will set all the dataAdapter connection strings to the correct database.
...Just wondered if there was some similar way to do this in ASP.net, as I need to make the app accessible to all 3 sites, and I'd prefer just to have the one application controlling it all.
Kind Regards
Luke
