DataSet sorting

[Björn]

Hi List

I´m generating a DataSet using a simple sql select statement. Now my DataSet
has several rows with columns(ID,NAME ,CAPTION)

Now I want to sort the DataSet for column Caption. I can´t use sql "order
by" because the caption field is of Sqltype text.
So I wanted to use the DataView object sort order.
----sample code--------------------------
DataView sortView = this.sqlResultD S.Tables[0].DefaultView;//new
DataView(this.s qlResultDS.Tabl es[0]);
sortView.AllowE dit = true;

sortView.Sort = "CAPTION DESC";//sort data
this.sqlResultD S.Tables.Remove At(0);//remove old unsorted data

this.sqlResultD S.Tables.Add(so rtView.Table);//add new sorted data (does not
function)

----------------------------------------------------------------------------
----------------

Something is wrong with my Code, the data is not sorted.

Any ideas???

regards

Björn

[avnrao]

this.sqlResultD S.Tables.Remove At(0);//remove old unsorted data
this line removes the table...

this.sqlResultD S.Tables.Add(so rtView.Table);//add new sorted data (does not
function)
this line again tries to add the same table.. when you sort using sortview,
i dont think the underlying table gets modified. when you bind the DataView
to some control, only then the actual sorting occurs. so try binding your
DataView to some control and check if its working.

Av.
"Björn" <pr********@gmx .net> wrote in message
news:Oe******** *****@TK2MSFTNG P12.phx.gbl...

Hi List

I´m generating a DataSet using a simple sql select statement. Now my
DataSet
has several rows with columns(ID,NAME ,CAPTION)

Now I want to sort the DataSet for column Caption. I can´t use sql "order
by" because the caption field is of Sqltype text.
So I wanted to use the DataView object sort order.
----sample code--------------------------
DataView sortView = this.sqlResultD S.Tables[0].DefaultView;//new
DataView(this.s qlResultDS.Tabl es[0]);
sortView.AllowE dit = true;

sortView.Sort = "CAPTION DESC";//sort data
this.sqlResultD S.Tables.Remove At(0);//remove old unsorted data

this.sqlResultD S.Tables.Add(so rtView.Table);//add new sorted data (does
not
function)

----------------------------------------------------------------------------
----------------

Something is wrong with my Code, the data is not sorted.

Any ideas???

regards

Björn

[Björn]

Hey

Thanks for your answer.
Because I´m working with dataset in a class project and not a web project I
can´t bind the DataView to an Aspnet Control.
So this means I have to implement the sort for the dataset on my own? right?

regards

Björn

"avnrao" <av*@newsgroups .com> schrieb im Newsbeitrag
news:#0******** ******@TK2MSFTN GP12.phx.gbl...

this.sqlResultD S.Tables.Remove At(0);//remove old unsorted data
this line removes the table...

this.sqlResultD S.Tables.Add(so rtView.Table);//add new sorted data (does not function)
this line again tries to add the same table.. when you sort using sortview, i dont think the underlying table gets modified. when you bind the DataView to some control, only then the actual sorting occurs. so try binding your
DataView to some control and check if its working.

Av.
"Björn" <pr********@gmx .net> wrote in message
news:Oe******** *****@TK2MSFTNG P12.phx.gbl...

Hi List

I´m generating a DataSet using a simple sql select statement. Now my
DataSet
has several rows with columns(ID,NAME ,CAPTION)

Now I want to sort the DataSet for column Caption. I can´t use sql "order by" because the caption field is of Sqltype text.
So I wanted to use the DataView object sort order.
----sample code--------------------------
DataView sortView = this.sqlResultD S.Tables[0].DefaultView;//new
DataView(this.s qlResultDS.Tabl es[0]);
sortView.AllowE dit = true;

sortView.Sort = "CAPTION DESC";//sort data
this.sqlResultD S.Tables.Remove At(0);//remove old unsorted data

this.sqlResultD S.Tables.Add(so rtView.Table);//add new sorted data (does
not
function)

--------------------------------------------------------------------------

--

----------------

Something is wrong with my Code, the data is not sorted.

Any ideas???

regards

Björn

[avnrao]

if you have to sort the values and just use them in the class as sorted, use
this code..

DataView sorted = GetDataView();
System.Collecti ons.IEnumerator ienum = sorted.GetEnume rator();
int iLen = sorted.Table.Ro ws.Count;
DataRowView drv;
while(ienum.Mov eNext())
{
drv = (DataRowView)ie num.Current;
lstBox.Items.Ad d(new ListItem(drv.Ro w["ProgramNam e"].ToString())); i
just added the value in the list box.
}

hth,
Av.
"Björn" <pr********@gmx .net> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

Hey

Thanks for your answer.
Because I´m working with dataset in a class project and not a web project
I
can´t bind the DataView to an Aspnet Control.
So this means I have to implement the sort for the dataset on my own?
right?

regards

Björn

"avnrao" <av*@newsgroups .com> schrieb im Newsbeitrag
news:#0******** ******@TK2MSFTN GP12.phx.gbl...

this.sqlResultD S.Tables.Remove At(0);//remove old unsorted data
this line removes the table...

this.sqlResultD S.Tables.Add(so rtView.Table);//add new sorted data (does

not

function)
this line again tries to add the same table.. when you sort using

sortview,

i dont think the underlying table gets modified. when you bind the

DataView

to some control, only then the actual sorting occurs. so try binding your
DataView to some control and check if its working.

Av.
"Björn" <pr********@gmx .net> wrote in message
news:Oe******** *****@TK2MSFTNG P12.phx.gbl...

> Hi List
>
> I´m generating a DataSet using a simple sql select statement. Now my
> DataSet
> has several rows with columns(ID,NAME ,CAPTION)
>
> Now I want to sort the DataSet for column Caption. I can´t use sql "order > by" because the caption field is of Sqltype text.
> So I wanted to use the DataView object sort order.
> ----sample code--------------------------
> DataView sortView = this.sqlResultD S.Tables[0].DefaultView;//new
> DataView(this.s qlResultDS.Tabl es[0]);
> sortView.AllowE dit = true;
>
> sortView.Sort = "CAPTION DESC";//sort data
>
>
> this.sqlResultD S.Tables.Remove At(0);//remove old unsorted data
>
> this.sqlResultD S.Tables.Add(so rtView.Table);//add new sorted data (does
> not
> function)
>

--------------------------------------------------------------------------

--

> ----------------
>
> Something is wrong with my Code, the data is not sorted.
>
> Any ideas???
>
> regards
>
>
>
> Björn
>
>