一个应用程序和不同的数据库作为masterdb和会计年度DB作为2015DB,2016DB [英] One application and diffrent database as a masterdb and fiscal year DB as 2015DB, 2016DB
问题描述
您好,
我有一个基于Web的应用程序,我需要在IIS上托管。
但我有两个或更多的数据库按照会计年度继续一个是修复MasterDB,按照年份我们创建新的一个,比如2015DB,2016DB和去。
我的问题是我登录masterDB用户凭据,但事务应按照会计年度发生,并且
请各位让我知道我该怎么做,
感谢高级>
请向我推荐任何链接,代码和其他。
我尝试过:
NO
Hello,
I have a web based application, that I need to host on IIS.
but I have 2 or more Database as per Fiscal year and going on one is Fix MasterDB and as per Year we create New One like 2015DB , 2016DB and going.
My questions is that I Login with masterDB user credentials but transaction should happen as per fiscal year and
I need to create the Dynamic Database connection string for Transaction as per Fiscal year selected on Dropdown list in Login Page.
Please guys let me know how can i do that ,
thanks in Advanced
Please refer me any link, code and other.
What I have tried:
NO
推荐答案
据我了解,您登录并连接到MasterDB并希望按下拉列表或其他选择器连接到其他数据库:
尝试U SE DATABASENAME按照此处 [ ^ ]
我假设这些数据库都是在同一个数据库服务器实例上。
As I understand it, you log in and connect to MasterDB and wish to connect to other DB's per a drop list or other selector:
Try "USE DATABASENAME" as per here[^]
I am assuming that these database are all on the same database server instance.
这篇关于一个应用程序和不同的数据库作为masterdb和会计年度DB作为2015DB,2016DB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!