//创建一个数据库
com.CommandText = "Create DataBase [" + strDataBaseName + "]";
com.ExecuteNonQuery();
//分配用户名和密码给刚创建的数据库
System.Text.StringBuilder builder = new System.Text.StringBuilder();
builder.AppendLine("USE [master]");
builder.AppendLine("CREATE LOGIN [" + strAccount + "] WITH PASSWORD=N'" + strPasswrod + "', DEFAULT_DATABASE=[" + strDataBaseName + "], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF");
com.CommandText = builder.ToString();
com.ExecuteNonQuery();
//把上一步创建的用户名与当前数据库关联
builder = new System.Text.StringBui
用sql语句创建数据库、登录帐号,并将帐号与该数据库关联
最新推荐文章于 2023-06-01 11:40:26 发布