Hi,

I have a datatable that contains the values in no order. I want to arrange it by name. Can anyone give me an idea to do this..

__________________
The OXYGEN
Delivers edgy, intelligent Technology to all...

Hi,

Hope this helps..

private DataTable SortDataTable(DataTable dt, string sort)
{
DataTable newDT = dt.Clone();
int rowCount = dt.Rows.Count;

DataRow[] foundRows = dt.Select(null, sort); // Sort with Column name
for (int i = 0; i < rowCount; i++)
{
object[] arr = new object[dt.Columns.Count];
for (int j = 0; j < dt.Columns.Count; j++)
{
arr[j] = foundRows[i][j];
}
DataRow data_row = newDT.NewRow();
data_row.ItemArray = arr;
newDT.Rows.Add(data_row);
}

//clear the incoming dt
dt.Rows.Clear();

for (int i = 0; i < newDT.Rows.Count; i++)
{
object[] arr = new object[dt.Columns.Count];
for (int j = 0; j < dt.Columns.Count; j++)
{
arr[j] = newDT.Rows[i][j];
}

DataRow data_row = dt.NewRow();
data_row.ItemArray = arr;
dt.Rows.Add(data_row);
}
return dt;
}

__________________
S.Balasubramanian
Nothing is impossible

public void Page_Load(Object sender, EventArgs e) {

ArrayList codes = new ArrayList();
codes.Add("20040307");
codes.Add("20051103");
codes.Add("20030503");
codes.Add("20041225");
Show(codes);

//ascending order
Response.Write("<hr/>");
ArrayList sortedCodesAcending = SortArrayList(codes);
Show(sortedCodesAcending);

//descending order
Response.Write("<hr/>");
ArrayList sortedCodesDescending = SortArrayListReverseOrder(codes);
Show(sortedCodesDescending);

}

private ArrayList SortArrayList(ArrayList alOld) {

SortedList sl = new SortedList();
ArrayList alNew = new ArrayList();

//copy values from arraylist into sortedlist
foreach(string s in alOld) {
sl.Add(s,"dummy");
}

//copy values from sortedlist back into arraylist
foreach(string s in sl.Keys) {
alNew.Add(s);
}

return alNew;

}

private ArrayList SortArrayListReverseOrder(ArrayList alUnsorted) {

SortedList sl = new SortedList();
ArrayList alAscending = new ArrayList();
ArrayList alDescending = new ArrayList();

//copy values from arraylist into sortedlist
foreach(string s in alUnsorted) {
sl.Add(s,"dummy");
}

//copy values from sortedlist back into arraylist
foreach(string s in sl.Keys) {
alAscending.Add(s);
}

//reverse the order (comment this out if you want ascending order)
for(int x=alAscending.Count-1; x >=0; x--) {
alDescending.Add(alAscending[x]);
}

return alDescending;

}

private void Show(ArrayList al) {
foreach(string s in al) {
HttpContext.Current.Response.Write(s.ToString() + "<br/>");
}
}