private void btnSignIn_Click(object sender, EventArgs e)
{
//Kiểm tra đã nhập đủ các dữ liệu
if (txtUsername.TextLength > 0 && txtPassword.TextLength > 0 && txtIP.TextLength > 0)
{
this.userName = this.txtUsername.Text;
this.ip = this.txtIP.Text;
this.passWord = this.txtPassword.Text;
string conn = "Data Source=" + this.ip + ";" + "User ID="
+ this.userName + ";" + "Password="******";";
DynamicConnection.connectstr = conn;
DB = new DBMSQuanTraSuaDataContext(DynamicConnection.connectstr);
DB.Connection.ConnectionString = conn;
try
{
DB.Connection.Open();
}
catch
{
MessageBox.Show("KHÔNG THỂ KẾT NỐI ĐẾN SERVER NÀY!");
return;
}
if (DB.Connection.State == ConnectionState.Open)
{
this.pnlFirstTextBox.Visible = false;
this.pnlSecondTextBox.Visible = true;
this.AcceptButton = this.btnConnect;
DataTable databases = DB.Connection.GetSchema("databases");
if (databases != null)
{
foreach (DataRow database in databases.Rows)
{
string databaseName = database.Field <string>("Database_Name");
if (databaseName != "master" && databaseName != "model" &&
databaseName != "tempdb" && databaseName != "msdb" &&
databaseName != "ReportServer$SQLEXPRESS" &&
databaseName != "ReportServer$SQLEXPRESSTempDB")
{
this.cbxDatabase.Items.Add(databaseName);
}
}
}
}
}
else
{
MessageBox.Show("Vui lòng nhập đầy đủ thông tin!");
return;
}
}
private void FormMain_Load(object sender, EventArgs e)
{
dangNhap.ShowDialog();
DB = new DBMSQuanTraSuaDataContext(DynamicConnection.connectstr);
this.pnlMain.Controls.Clear();
}
