我有一个我无法解决的问题。

我已经用 C# 构建了一个 ASP.NET webforms 应用程序，它将被不同的公司使用，每个公司都有自己的数据库。

当用户在网站上成功注册时，数据库创建过程就开始了，每个公司可能会有几个用户。

该应用程序包含一个主数据库，我在其中存储订阅者信息：

|ID| |SubscriberName| |SubscriberEmail| |SubscribedDate|

然后将使用以下代码为该特定用户创建一个数据库：

cmd.CommandText = "select * form Subscriber";

DataTable customerscount = new DataTable();
sda.Fill(customerscount);

var createcmd = con.CreateCommand();

string dbname;

if (customerscount.Rows.Count > 0)
{
    int subcount = customerscount.Rows.Count;
    dbname = "User" + subcount.ToString();
}
else
{
    dbname = "User1";
}

createcmd.CommandText = "CREATE DATABASE " + dbname + " COLLATE ARABIC_CI_AI_KS";
createcmd.ExecuteNonQuery();

SqlConnection newcon = new SqlConnection();
string oldconnetion = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

SqlConnectionStringBuilder scb = new SqlConnectionStringBuilder(oldconnetion);
scb.InitialCatalog = dbname;

newcon.ConnectionString = scb.ConnectionString;

SqlCommand newcmd = new SqlCommand();
cmd.Connection = newcon;

newcon.Open();

newcmd.CommandText = "CREATE TABLE [Users] ([ID][int] IDENTITY(1, 1) NOT NULL," +
            "[Fullname] [nvarchar] (max) NULL," +
            "[Username] [nvarchar] (max) NULL," +
            "[Password] [nvarchar] (max) NULL," +
            "[Type] [nvarchar] (max) NULL," +
            "CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED([ID] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]";
newcmd.ExecuteNonQuery();

与我没有包括的其他表格。

我的问题是如何在登录时找出用户的数据库？

Users表将在新创建的表内：

|ID| |Fullname| |Username| |Password|

很抱歉文字太长