//解决使用tableLayoutPanel1窗体闪烁的语句
            this.tableLayoutPanel1.GetType()
    .GetProperty("DoubleBuffered", BindingFlags.Instance | BindingFlags.NonPublic)
    .SetValue(this.tableLayoutPanel1, true, null);

//数组中去掉重复值
 public static string[] GetString(string[] values)
        {
            List<string> list = new List<string>();
            for (int i = 0; i < values.Length; i++)//遍历数组成员
            {
                if (list.IndexOf(values[i].ToLower()) == -1)//对每个成员做一次新数组查询如果没有相等的则加到新数组
                    list.Add(values[i]);

            }
            return list.ToArray();
        }

 //数组中去掉重复值
public static string[] GetString(string[] values)
        {
            List<string> list = new List<string>();
            for (int i = 0; i < values.Length; i++)//遍历数组成员
            {
                if (list.IndexOf(values[i].ToLower()) == -1)//对每个成员做一次新数组查询如果没有相等的则加到新数组
                    list.Add(values[i]);

            }
            return list.ToArray();
        }

 //数组转DateTable
 public static DataTable ArrToDateTable(string ColumnName, string[] Array)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add(ColumnName, typeof(string));

            for (int i = 0; i < Array.Length; i++)
            {
                DataRow dr = dt.NewRow();
                dr[ColumnName] = Array[i].ToString();
                if (string.IsNullOrEmpty(dr[ColumnName].ToString()))
                { }
                else
                {
                    dt.Rows.Add(dr);
                }
            }

            return dt;
        }

 //根据现有的表 创建新的表 列名
DataTable dt1 = dtAll.DefaultView.ToTable(false, new string[] { "a", "b", "c", "d"});

//清空datgridview里面的数据
  private void RemoveAllDGV()
        {
            //dataGridPaiBan.  //清空数据表
            for (int i = 0; i < dataGridPaiBan.Rows.Count; i++)
            {
                for (int j = 0; j < dataGridPaiBan.Columns.Count; j++)
                {
                    dataGridPaiBan[j, i].Value = "";
                }
            }
        }

//DataGridView 转DataTable 
 public DataTable GetDgvToTable(DataGridView dgv)
        {
            DataTable dt = new DataTable();

            // 列强制转换
            for (int count = 0; count < dgv.Columns.Count; count++)
            {
                DataColumn dc = new DataColumn(dgv.Columns[count].Name.ToString());
                dt.Columns.Add(dc);
            }

            // 循环行
            for (int count = 0; count < dgv.Rows.Count; count++)
            {
                DataRow dr = dt.NewRow();
                //去掉空行

                if (dr == null)
                { }
                else
                {
                    for (int countsub = 0; countsub < dgv.Columns.Count; countsub++)
                    {
                        dr[countsub] = Convert.ToString(dgv.Rows[count].Cells[countsub].Value);
                    }
                    dt.Rows.Add(dr);
                }

            }
            return dt;
        }