public static SqlConnection hamketnoisqlhtkh2015()
{
CauHinhServerBE server = new CauHinhServerBE();
CauHinhServerBL serverxuly = new CauHinhServerBL();
server = serverxuly.docdulieu(Environment.CurrentDirectory + "/CauHinhServerHTKH2015.xml");
return(new SqlConnection("server=" + server.Namer1 + ";database=" + server.Data1 + ";user id=" + server.User1 + ";password="******""));
}
public static void sqlDependency()
{
CauHinhServerBE server = new CauHinhServerBE();
CauHinhServerBL serverxuly = new CauHinhServerBL();
server = serverxuly.docdulieu(Environment.CurrentDirectory + "/CauHinhServer.xml");
string m_connect = "server=" + server.Namer1 + ";database=" + server.Data1 + ";user id=" + server.User1 + ";password="******"";
try
{
SqlClientPermission ss = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
ss.Demand();
}
catch (Exception)
{
throw;
}
SqlDependency.Stop(m_connect);
SqlDependency.Start(m_connect);
}
