GridView转化为DataTable代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】 GridView转化为DataTable

作者:Dezai.CN / 发布于2012/6/21/ 601

GridView转化为DataTable

<div>
/**/
/// <summary>
/// 从GridView的数据生成DataTable
///  </summary>
/// <param  name="gv">GridView对象</param>
public static DataTable  GridView2DataTable(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;
}
public static 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;
}
</div>

试试其它关键字

　GridView转化为DataTable　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)