1-) C# RMOS - gridview to datatable gridcontrol to datatable
public DataTable gridviewToDatatable(GridView gridView)
{
DataRow dr;
DataTable dt = new DataTable();
for (int i = 0; i < gridView.Columns.Count; i++)
{
dt.Columns.Add(gridView.Columns[i].FieldName, typeof(string));
}
for (int i = 0; i < gridView.DataRowCount; i++)
{
dr = dt.NewRow();
for (int k = 0; k < gridView.Columns.Count; k++)
{
string fieldName = gridView.Columns[k].FieldName;//.Replace(" ", "_");
var item = gridView.GetRowCellValue(i, fieldName);
if (item == null || item.Equals(""))
{
item = "";
}
dr[k] = item.ToString();
}
dt.Rows.Add(dr);
}
return dt;
}
2-) DİĞER 1
public DataTable GetDataTable()
{
DataTable dt = new DataTable();
foreach (GridColumn column in gridView1.VisibleColumns)
{
dt.Columns.Add(column.FieldName, column.ColumnType);
}
for (int i = 0; i < gridView1.DataRowCount; i++)
{
DataRow row = dt.NewRow();
foreach (GridColumn column in gridView1.VisibleColumns)
{
row[column.FieldName] = gridView1.GetRowCellValue(i, column);
}
dt.Rows.Add(row);
}
return dt;
}
2-) DİĞER
DataTable md = new DataTable();
try
{
foreach (GridColumn column in gridView3.Columns)
{
if (column.FieldName != null)
{
md.Columns.Add(column.FieldName, column.ColumnType);
}
}
for (int i = 0; i < gridView3.DataRowCount; i++)
{
DataRow row = md.NewRow();
foreach (GridColumn column in gridView3.Columns)
{
if (gridView3.GetRowCellValue(i, column) != null)
{
row[column.FieldName] = gridView3.GetRowCellValue(i, column);
}
}
md.Rows.Add(row);
}
}
catch (Exception aa)
{
MessageBox.Show(aa.Message);
}