Sorting dataset Columns

[Deepa]

I have a dataset which am trying to sort by 3 specific columns. I am not
making any connection to the database to get the dataset. I have the raw
dataset already.
What i tried doing was to create a DataView and sort it by a column name.

mydataset.ReadX ml(@sResponseXM L);
DataView mydataview = new DataView();
mydataview = ds.Tables[0].DefaultView;
mydataview.Sort = "ColumnName ";

Then I call a function Export() passing the dataset. The function loops thru
the dataset and writes the output as a csv file. So technically I cannot say
mydataview.Tabl es[0].Columns to loop thru the data view nor can I use the
foreach statement on a dataview.

I even tried sorting the dataset itself and passing it to the Export function
ds.Tables[0].DefaultView.So rt = "Country of Risk"; This doesnt work either.

Can someone give any ideas about how to handle this? I'd really appreciate.

Thanks
Deepa

[Cor Ligthert]

Deepa,

I once made a snippet, maybe you can use it.

\\\
DataView dv = new DataView(dt);
dv.Sort = "bla"; // sorts column bla
DataTable dtnew = dt.Clone();
foreach (DataRowView dvr in dv)
dtnew.ImportRow (dvr.Row);
dt.Clear();
dt = dtnew.Copy();
///

I hope this helps?

Cor

[Deepa]

Cor
in the statement DataView dv = new DataView(dt);
is dt another data table object?
In my scenario am loading the dataset object using the ReadXml. Later am
looping thru the dataset.

-Deepa

"Cor Ligthert" wrote:

Deepa,

I once made a snippet, maybe you can use it.

\\\
DataView dv = new DataView(dt);
dv.Sort = "bla"; // sorts column bla
DataTable dtnew = dt.Clone();
foreach (DataRowView dvr in dv)
dtnew.ImportRow (dvr.Row);
dt.Clear();
dt = dtnew.Copy();
///

I hope this helps?

Cor

[Deepa]

hey Cor
thanks a lot dude, this is exactly what i was looking for and it works :)

"Cor Ligthert" wrote:

Deepa,

I once made a snippet, maybe you can use it.

\\\
DataView dv = new DataView(dt);
dv.Sort = "bla"; // sorts column bla
DataTable dtnew = dt.Clone();
foreach (DataRowView dvr in dv)
dtnew.ImportRow (dvr.Row);
dt.Clear();
dt = dtnew.Copy();
///

I hope this helps?

Cor

[Cor Ligthert]

Deepa,

dt is the datatable you want to sort.
Something as ds.Tables[0]

As sample with a datagrid.
\\\
private void button1_Click(o bject sender, System.EventArg s e)
{
DataTable dt = (DataTable)(dat aGrid1.DataSour ce);
dataGrid1.DataS ource = null;
dataGrid1.DataS ource = sortmytable(dt) ;
}
private DataTable sortmytable(Dat aTable dt )
{
DataView dv = new DataView(dt);
dv.Sort = "bla";
DataTable dtnew = dt.Clone();
foreach (DataRowView dvr in dv)
dtnew.ImportRow (dvr.Row);
return(dtnew.Co py());
}
//

I hope this helps

Cor