Sort DataTable - C#

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Bimal Kothari

    Sort DataTable - C#


    private DataTable SortDataTable(D ataTable GetDataTable, string sort)
    {
    DataTable _NewDataTable = GetDataTable.Cl one();
    int rowCount = GetDataTable.Ro ws.Count;

    DataRow[] foundRows = GetDataTable.Se lect(null, sort);
    // Sort with Column name
    for (int i = 0; i < rowCount; i++)
    {
    object[] arr = new object[GetDataTable.Co lumns.Count];
    for (int j = 0; j < GetDataTable.Co lumns.Count; j++)
    {
    arr[j] = foundRows[i][j];
    }
    DataRow data_row = _NewDataTable.N ewRow();
    data_row.ItemAr ray = arr;
    _NewDataTable.R ows.Add(data_ro w);
    }

    //Clear the incoming GetDataTable
    GetDataTable.Ro ws.Clear();

    for (int i = 0; i < _NewDataTable.R ows.Count; i++)
    {
    object[] arr = new object[GetDataTable.Co lumns.Count];
    for (int j = 0; j < GetDataTable.Co lumns.Count; j++)
    {
    arr[j] = _NewDataTable.R ows[i][j];
    }

    DataRow data_row = GetDataTable.Ne wRow();
    data_row.ItemAr ray = arr;
    GetDataTable.Ro ws.Add(data_row );
    }
    return _NewDataTable;
    }




Working...