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