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




  • Nirosh

    #2
    Re: Sort DataTable -C#

    what the hell you are trying to do here??

    Nirosh

    <Bimal Kothariwrote in message
    news:2008429144 230bimal_kothar i@yahoo.com...
    >
    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;
    }
    >
    >
    >
    >

    Comment

    • Andrew Cooper

      #3
      Re: Sort DataTable -C#

      Nirosh wrote:
      what the hell you are trying to do here??
      >
      Sort a DataTable?

      Nirosh
      >
      <Bimal Kothariwrote in message
      news:2008429144 230bimal_kothar i@yahoo.com...
      >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;
      > }
      >>
      >>
      >>
      >>
      >
      >

      Comment

      • =?Utf-8?B?QklNQUwgS09USEFSSQ==?=

        #4
        Re: Sort DataTable -C#

        Hello Just pass your data table and sort expression to sort (Date
        and Amount) columns

        Ok



        "Andrew Cooper" wrote:
        Nirosh wrote:
        what the hell you are trying to do here??
        >
        Sort a DataTable?
        >
        >
        Nirosh

        <Bimal Kothariwrote in message
        news:2008429144 230bimal_kothar i@yahoo.com...
        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;
        }
        >
        >
        >
        >
        >

        Comment

        Working...