private void GetSubServer(TreeNode node) { NetbarServer dbser = (NetbarServer)node.Tag; using (SqlConnection con = new SqlConnection(string.Format("server={0};database=master;uid={1};pwd={2};", dbser.IP, dbser.UN, dbser.PW))) { using (SqlCommand cmd = new SqlCommand("select * from netbar..s_center_ip where flag=1", con)) { con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); if (sdr.HasRows) { string sname; while (sdr.Read()) { sname = dbser.ServerName(sdr.GetValue(0).ToString()); if (!sname.Equals(string.Empty)) { TreeNode newnode = new TreeNode(); newnode.Text = sname; newnode.Name = sdr.GetValue(0).ToString(); NetbarServer subserv = new NetbarServer(sdr.GetValue(1).ToString(), "sa", dbser.PW); newnode.Tag = subserv; tvSubServers.Nodes.Add(newnode); } } } } } }
private void tvSubServers_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e) { NetbarServer serv = (NetbarServer)e.Node.Tag; this.Text = string.Format("{0}-[{1}]", e.Node.Text, serv.IP); instance.Text = serv.IP; user.Text = serv.UN; pwd.Text = serv.PW; }
private void GetServerList() { XmlDocument doc = new XmlDocument(); doc.Load("Config.xml"); XmlNode cons = doc.SelectSingleNode("connections"); XmlNodeList servers = cons.SelectNodes("server"); foreach (XmlNode server in servers) { TreeNode newnode = new TreeNode(); newnode.Text = server.Attributes["name"].Value; newnode.Name = server.Attributes["name"].Value; NetbarServer newserv = new NetbarServer(server["ip"].InnerText, server["un"].InnerText, server["pw"].InnerText); newnode.Tag = newserv; tvServers.Nodes.Add(newnode); } }