public class DataGridViewComboEditBoxCell : DataGridViewComboBoxCell
    {
        /// <summary>
        /// 重写初始化控件的编辑状态
        /// </summary>
        public override void InitializeEditingControl(int rowIndex, object initialFormattedValue, DataGridViewCellStyle dataGridViewCellStyle)
        {
            base.InitializeEditingControl(rowIndex, initialFormattedValue, dataGridViewCellStyle);

            ComboBox comboBox = base.DataGridView.EditingControl as ComboBox;
            if (comboBox != null)
            {
                comboBox.DropDownStyle = ComboBoxStyle.DropDown;
                comboBox.Leave += new EventHandler(comboBox_Leave);
                this.Value = comboBox.Text;
            }
        }
        /// <summary>
        /// 绑定事件，处理当用户输入的数据在原ComboBox列表中不存在时，增加数据
        /// </summary>
        private void comboBox_Leave(object sender, EventArgs e)
        {
            ComboBox comboBox = sender as ComboBox;
            comboBox.Leave -= new EventHandler(comboBox_Leave);
            if (base.DataGridView.CurrentCell != null && base.DataGridView.CurrentCell.OwningColumn is DataGridViewComboEditBoxColumn)
            {
                DataGridViewComboEditBoxColumn col = base.DataGridView.CurrentCell.OwningColumn as DataGridViewComboEditBoxColumn;
                if (!col.Items.Contains(comboBox.Text))
                {
                    col.Items.Add(comboBox.Text);
                }
                base.DataGridView.CurrentCell.Value = comboBox.Text;
            }
        }
    }

    public class DataGridViewComboEditBoxColumn : DataGridViewComboBoxColumn
    {
        public DataGridViewComboEditBoxColumn()
        {
            DataGridViewComboEditBoxCell objCell = new DataGridViewComboEditBoxCell();
            this.CellTemplate = objCell;
        }
    }

    public class DataGridViewEx : DataGridView
    {
        protected override void OnEditingControlShowing(DataGridViewEditingControlShowingEventArgs e)
        {
            if (CurrentCell != null && CurrentCell.OwningColumn is DataGridViewComboBoxColumnEx)
            {
                DataGridViewComboBoxColumnEx col = CurrentCell.OwningColumn as DataGridViewComboBoxColumnEx;
                //修改组合框的样式
                if (col.DropDownStyle != ComboBoxStyle.DropDownList)
                {
                    ComboBox comboBox = e.Control as ComboBox;
                    comboBox.DropDownStyle = col.DropDownStyle;
                    comboBox.Leave += new EventHandler(comboBox_Leave);
                }
            }
            base.OnEditingControlShowing(e);
        }

        /// <summary>
        /// 当焦点离开时，需要将新输入的值加入到组合框的 Items 列表中
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void comboBox_Leave(object sender, EventArgs e)
        {
            ComboBox comboBox = sender as ComboBox;
            comboBox.Leave -= new EventHandler(comboBox_Leave);
            if (CurrentCell != null && CurrentCell.OwningColumn is DataGridViewComboBoxColumnEx)
            {
                DataGridViewComboBoxColumnEx col = CurrentCell.OwningColumn as DataGridViewComboBoxColumnEx;
                col.Items.Add(comboBox.Text);
                CurrentCell.Value = comboBox.Text;
            }
        }

    }

    public class DataGridViewComboBoxColumnEx : DataGridViewComboBoxColumn
    {
        private ComboBoxStyle dropDownStyle;
        /// <summary>
        /// 控制组合框的外观和功能
        /// </summary>
        [Category("外观"),Description("控制组合框的外观和功能"), DefaultValue(ComboBoxStyle.DropDownList)]
        public ComboBoxStyle DropDownStyle
        {
            get { return dropDownStyle; }
            set { dropDownStyle = value; }
        }

        public DataGridViewComboBoxColumnEx()
        {
            dropDownStyle = ComboBoxStyle.DropDownList;
        }
    }

declare @sql varchar(200);
declare @tabname varchar(20);
declare @colname varchar(50);
set @colname='msrepl_tran_version';--欲删除的字段名称
declare cur cursor for Select name From sysobjects Where xtype = 'u'
open cur;
fetch next from cur into @tabname;
while @@fetch_status=0
begin
    set @sql='if exists (select * from syscolumns where id=object_id(N'''+@tabname+''') and name='''+@colname+''') alter table ['+ @tabname +'] drop column '+@colname;
    exec(@sql);
    fetch next from cur into @tabname;
end
close cur
deallocate cur

# -*- coding: utf-8 -*-
import re,time,os
import urllib

def saveproxies(proxies, filename='proxy.txt'):
    proxies = [x for x in proxies if x not in locals()['_[1]']]
    '''过滤重复的数据，等同于“proxies = [elem for elem in proxies if porxies.count(elem) == 1]” '''
    if proxies:
        f = file(os.path.join(os.path.dirname(__file__),filename),'w+');
        f.writelines(proxies)
        f.close()

def cnproxyHttp(filename='cnproxyHttp.txt'):
    '''获取cnproxy.com的http代理'''
    proxies = []
    pattern = re.compile('<td>(\d+\.\d+\.\d+\.\d+)<SCRIPT type=text/javascript>document\.write\(":"((\+[a-z]){2,5})\)</SCRIPT></td>')
    script = re.compile('''<SCRIPT type="text/javascript">\n(([a-z]="(\d)";)+)</SCRIPT>''')

    us = [['http://www.cnproxy.com/proxyedu%s.html',4]]
    us.append(['http://www.cnproxy.com/proxy%s.html',10])
    for u in us:
        for i in range(1,u[1]+1):
            url = u[0] % i
            print url
            f = urllib.urlopen(url)
            html = f.read()
            f.close()
            scripts = re.search(script,html,re.I)
            if scripts:
                t = scripts.group(1).strip(';').replace('"','')
                s = {}
                for d in t.split(';'):
                    v = d.split('=')
                    s[v[0]]=v[1]
                searchs = re.findall(pattern,html,re.I)
                for g in searchs:
                    p = g[0]+":"
                    for d in g[1].strip('+').split('+'):
                        p = p + s[d]
                    proxies.append(p + '\n')
                    print p
    saveproxies(proxies,filename)
    return proxies

#!/usr/bin/python
# -*- coding: utf-8 -*-
import time,os
import re,random
import urllib

import socket
socket.setdefaulttimeout(3)
userAgents = ['Mozilla/5.0 (Windows; U; Windows NT 5.2; zh-CN; rv:1.9.1.5) Gecko/20091102 Firefox/3.5.5']
userAgents.append('Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.0;+.NET+CLR+3.0.04506;)')
userAgents.append('Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+5.1;+Trident/4.0;+.NET+CLR+2.0.50727;+yie8)')

def readproxy(filename,startline=0):
    proxies = []
    f = file(os.path.join(os.path.dirname(__file__),filename),'r')
    while startline>0:
        f.readline()
        startline = startline - 1
    while True:
        line = re.sub('\n','',f.readline())
        if len(line)==0:
            break
        proxies.append(line)
    f.close()
    return proxies

def votemain(proxy):
    '''投票主体部分'''
    proxies = {'http': 'http://%s' % (proxy)}
    opener = urllib.FancyURLopener(proxies)
    opener.addheader('Referer',"http://vote.xxxx.com.cn/yyyy/")
    opener.addheader('User-Agent',random.choice(userAgents))
    opener.addheader('Cookie',"JSESSIONID=9A22B1572911830AC365F9858F2D541D")
    vid = random.randrange(1,8)
    vid2 = random.randrange(1,8)
    data = '1_%s=%s&1_%s=%s&id=123' % (vid,vid,vid2,vid2)
    try:
        f = opener.open("http://vote.xxxx.com.cn/post.jsp",data)
        print(f.read())
    except :
        '''代理服务器失效或者链接超时'''
        return

def main():
    i = 0
    proxies = readproxy('proxy.txt', i)
    for proxy in proxies:
        print i+1, proxy, time.time()
        votemain(proxy)
        #time.sleep(2)
        i = i + 1

if __name__=='__main__' :
    main()