基于不同公司登录的不同数据库使用 [英] Different Database Use Based on Different Company Login

问题描述

我通过公司登录页面。如果我选​​择一家公司然后它使用了公司数据库seprate.if我选择第二家公司然后它使用第二公司数据库。



我该怎么办...？帮帮我...先谢谢

I have Login Page through Company .If i Select One Company Then It used its Company Database seprate.if i select second Company Then it Used Second Company Database.

How Can i Do...?Help Me...Thanx In Advance

推荐答案

Delcare web.config中的所有公司数据库连接字符串，如下所示，



< add name =ConnectionStringconnectionstring =Data Source = xxxx; Initial Catalog = database1;用户ID = sa;密码= saprovidername =System.Data.SqlClient/>

< add name =ConnectionString1connectionstring =Data Source = yyyy; Initial Catalog = database2;用户ID = sa;密码= saprovidername =System.Data.SqlClient/>



当您的登录名与公司名称一起存储时名称。



当您尝试获取连接字符串时，请使用以下代码，



string CompanyName =Sam;

string conn_str = string.Empty;

if（CompanyName.Equals（Sam））

ConfigurationSettings.AppSettings.Get（ConnectionString） ;

else

ConfigurationSettings.AppSettings.Get（ConnectionString1）;



SqlConnection conn = new SqlConnection （conn_str）;

conn.Open（）;

Hi,

Delcare all the company database connection strings in web.config like below,

<add name="ConnectionString" connectionstring="Data Source=x.x.x.x ;Initial Catalog=database1;User ID=sa;Password=sa" providername="System.Data.SqlClient" />
<add name="ConnectionString1" connectionstring="Data Source=y.y.y.y;Initial Catalog=database2;User ID=sa;Password=sa" providername="System.Data.SqlClient" />

When your login store the Company name along with user name.

When you are trying to get the connection string, use the following code,

string CompanyName = "Sam";
string conn_str = string.Empty;
if(CompanyName.Equals("Sam"))
ConfigurationSettings.AppSettings.Get("ConnectionString");
else
ConfigurationSettings.AppSettings.Get("ConnectionString1");

SqlConnection conn = new SqlConnection(conn_str);
conn.Open();

这篇关于基于不同公司登录的不同数据库使用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！