现在的位置: 首页 > 综合 > 正文

ADO.NET 到XML

2011年07月25日 ⁄ 综合 ⁄ 共 1789字 ⁄ 字号 评论关闭

namespace ConsoleApplication1
{
    public class Configuration
    {

        Collection<Group> groups = new Collection<Group>();
        public Collection<Group> Groups
        {
            get { return groups; }
            set { groups = value; }
        }
    }

    public class Group
    {
        Collection<string> name=new Collection<string>();
        public Collection<string> Name
        {
            get{return name;}
            set{name=value;}
        }
        Collection<string> ip=new Collection<string>();
        public Collection<string> IP
        {
            get{return ip;}
            set{ip=value;}
        }
        Collection<string> timeout=new Collection<string>();
        public Collection<string> Timeout
        {
            get{return timeout;}
            set{timeout=value;}
        }
        Collection<string> interval=new Collection<string>();
        public Collection<string> Interval
        {
            get{return interval;}
            set{interval=value;}
        }

    }
 
    public class test
    {
        static void Main()
        {
            //序列化
            Configuration cfg = new Configuration();

            CMySql sql = new CMySql();
            string str = "select servername,ipaddress from serverconfig";
            DataTable tb = sql.SelectDt(str);
            for(int i=0;i<tb.Rows.Count;i++)
            {
                Group g = new Group();
                string server=string.Format("{0}",tb.Rows[i][0]);
                string ip=string.Format("{0}",tb.Rows[i][1]);
                g.Name.Add(server);
                g.IP.Add(ip);
                g.Interval.Add("2000");
                g.Timeout.Add("2000");
                cfg.Groups.Add(g);

            }

            XmlSerializer xs = new XmlSerializer(typeof(Configuration));
            StringWriter sw = new StringWriter();
            xs.Serialize(sw, cfg);

            Console.WriteLine(sw.ToString());
            Console.ReadLine();
        }
    }
}

抱歉!评论已关闭.