2. ASPRunner.NET General questions
  3. [SOLVED]  Login Page / SQL Connection String
This topic is locked
[SOLVED]

 Login Page / SQL Connection String

 		11/12/2020 16:04:33
ASPRunner.NET General questions
Lowkeck authorDevClub member

Hi,
Just wondering if it is possible to prompt the end user to enter in the SQL database name on the login page so it can direct the end user to a specific SQL database. Has anyone done anything like this? Obviously the username and password would have to have access to the db in question.
Thanks,

Jason
N
 		Nir Frumer 11/12/2020

hi

take a look at this one

https://xlinesoft.com/blog/2019/10/03/saas-application-design/
you will need the enterprise version
hope it helps.
Sergey Kornilov admin 11/13/2020

ASPRunner.NET allows to add extra fields to the login page and database name can be one of them, just make sure you make it a dropdown as they can mistype the database name.
In regards to implementing the dynamic connection switching check this article:

https://xlinesoft.com/blog/2019/10/03/saas-application-design/
Instead of reading database name from the table you will need to read it from that extra field on the login page.
Check this article that explains how to access additional fields added to the login page:

https://xlinesoft.com/asprunnernet/docs/before_login.htm