从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
        }

 

posted @ 2012-03-26 15:31  天黑了  阅读(644)  评论(1编辑  收藏  举报