//解决使用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;
}