从dataGridView中检索数据并放到一个DataTable中 (转)
/// <summary> /// 从dataGridView中检索数据并放到一个新表中 /// </summary> /// <param ></param> /// <param >要添加的列名</param> /// <returns>datatable</returns> private DataTable StructrueDataTable(DataGridView dataGridView,ArrayList StructrueColumnsName) { #region 从dataGridView中检索数据并放到一个新表中,然后再绑定到dataGridView中 DataTable dataTable = new DataTable(); for (int col = 0; col < dataGridView.Columns.Count; col++) { string columnName = dataGridView.Columns[col].Name; if (StructrueColumnsName.Contains(columnName)) { dataTable.Columns.Add(dataGridView.Columns[col].Name); keyField[col]= dataGridView.Columns[col].Name; } } for (int r = 0; r < dataGridView.Rows.Count; r++) { DataRow dataRow = dataTable.NewRow(); for (int c = 0; c < dataGridView.Columns.Count; c++) { if (StructrueColumnsName.Contains(dataGridView.Columns[c].Name)) dataRow[c] = dataGridView.Rows[r].Cells[c].Value.ToString(); } dataTable.Rows.Add(dataRow); } return dataTable; #endregion }