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); }