将GridView的数据生成DataTable代码,Asp.NET代码库,德仔网

代码语言

代码分类

【Asp.NET】将GridView的数据生成DataTable

作者:乾坤 / 发布于2016/9/13/ 583

/// <summary>  
/// 获取单元格中的值  
/// </summary>  
/// <param name="cell"></param>  
/// <returns></returns>  
public string GetCellText(TableCell cell)  
{  
    string text = cell.Text;  
    if (!string.IsNullOrEmpty(text))  
    {  
        return text;  
    }  
    foreach (Control control in cell.Controls)  
    {  
        if (control != null && control is IButtonControl)  
        {  
            IButtonControl btn = control as IButtonControl;  
            text = btn.Text.Replace("?r?n", "").Trim();  
            break;  
        }  
        if (control != null && control is ITextControl)  
        {  
            LiteralControl lc = control as LiteralControl;  
            if (lc != null)  
            {  
                continue;  
            }  
            ITextControl l = control as ITextControl;  
            text = l.Text.Replace("?r?n", "").Trim();  
            break;  
        }  
    }  
    return text;  
}  
/// <summary>   
/// 将 GridView 的数据生成 DataTable   
/// </summary>   
/// <param name="gv">GridView 对象</param>   
public  DataTable GridViewToDataTable(GridView gv)  
{  
    DataTable table = new DataTable();  
    int rowIndex = 0;  
    List<string> cols = new List<string>();  
    if (!gv.ShowHeader && gv.Columns.Count == 0)  
    {  
        return table;  
    }  
    GridViewRow headerRow = gv.HeaderRow;  
    int columnCount = headerRow.Cells.Count;  
    for (int i = 0; i < columnCount; i++)  
    {  
        string text = GetCellText(headerRow.Cells[i]);  
        cols.Add(text);  
    }  
    foreach (GridViewRow r in gv.Rows)  
    {  
        if (r.RowType == DataControlRowType.DataRow)  
        {  
            DataRow row = table.NewRow();  
            int j = 0;  
            for (int i = 0; i < columnCount; i++)  
            {  
                string text = GetCellText(r.Cells[i]);  
                if (!String.IsNullOrEmpty(text))  
                {  
                    if (rowIndex == 0)  
                    {  
                        string columnName = cols[i];  
                        if (String.IsNullOrEmpty(columnName))  
                        {  
                            continue;  
                        }  
                        if (table.Columns.Contains(columnName))  
                        {  
                            continue;  
                        }  
                        DataColumn dc = table.Columns.Add();  
                        dc.ColumnName = columnName;  
                        dc.DataType = typeof(string);  
                    }  
                    row[j] = text;  
                    j++;  
                }  
            }  
            rowIndex++;  
            table.Rows.Add(row);  
        }  
    }  
    return table;  
}

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　GridView　　GridView　

同语言下

可能有用的

乾坤贡献的其它代码(11)