public bool ConnectDB(string ServerName, string DatabaseName, string UserID, string Password)
{
ConnectDTO connectDTO = new ConnectDTO();
try
{
connectDTO.ServerName = ServerName;
connectDTO.DatabaseName = DatabaseName;
connectDTO.UserID = UserID;
connectDTO.Password = Password;
}
catch (Exception)
{
return(false);
}
return(ConnectDAO.Instance.connectDB(connectDTO));
}
//Kết nối
public bool connectDB(ConnectDTO connectDTO)
{
string strCon = "Data Source=" + connectDTO.ServerName + ";" +
"Initial Catalog=" + connectDTO.DatabaseName + ";" +
"User id=" + connectDTO.UserID + ";" +
"Password="******";";
con = new SqlConnection(strCon);
cmd = con.CreateCommand();
try
{
con.Open();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message);
con.Dispose();
return(false);
}
return(true);
}
