log4net Ado net

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using log4net;
using log4net.Appender;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            log4net.Config.BasicConfigurator.Configure(

            new log4net.Appender.ConsoleAppender(new

            log4net.Layout.SimpleLayout()));

            AdoNetAppender appender = new AdoNetAppender();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            LogManager.GetLogger(this.GetType()).Debug("test");
        }

       void Application_Start(object sender, EventArgs e)     {    
           //在应用程序启动时运行的代码       
           log4net.Config.DOMConfigurator.Configure();
           ConfigureLog4Net();
       } 
        private static void ConfigureLog4Net()  
        {
            log4net.Repository.Hierarchy.Hierarchy hierarchy =  log4net.LogManager.GetRepository() as log4net.Repository.Hierarchy.Hierarchy;
            if (hierarchy != null && hierarchy.Configured) 
            {
                foreach (log4net.Appender.IAppender appender in hierarchy.GetAppenders())
                    if (appender is log4net.Appender.AdoNetAppender)                {            
                        var adoNetAppender = (log4net.Appender.AdoNetAppender)appender;           
                        adoNetAppender.ConnectionString = "";
                        adoNetAppender.ActivateOptions();
                        //Refresh AdoNetAppenders Settings          
                    }
            }
        }  
       
    }
}