Sort DataTable -C#

[Bimal Kothari]

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]

what the hell you are trying to do here??

Nirosh

<Bimal Kothariwrote in message
news:20******** *************** *@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;
}

[Andrew Cooper]

Nirosh wrote:

what the hell you are trying to do here??

Sort a DataTable?

Nirosh

<Bimal Kothariwrote in message
news:20******** *************** *@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;
}

[=?Utf-8?B?QklNQUwgS09USEFSSQ==?=]

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:20******** *************** *@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;
}