Newbie question.

[bredal Jensen]

Hello gurus,

I need to sort the elements in my datagrid .
i want them to appear the newest first (by entry date).
How can i achive this.




i added this :"ORDER BY entry_date DESC" after my "select * from xTable
where id=@id" .


Shouldn't that work?

Many thanks in advance

 

[Cor Ligthert]

Hi Bredal,

However that your solution work, is in my opinion the easiest way to use the
dataview.

\\\
dim dv as new dataview(xTable)
dv.sort = "entry_date DESC"
mycontrol.datasource = dv
////
I hope this was what you was looking for?

Co

 

[bredal Jensen]

Yes thank you so much.. that is exaclty what i was looking for.