How to remove last row from DataView before binding it to a DataGrid?

[crazy_mads]

I have a DataView. I am Sorting the DataView and then removing the last row before binding it to dataGrid. dvViewOrder = new DataView(dtViewOrder); dvViewOrder.Sort = "VOD_ProductCategory ASC"; if (dtViewOrder.Rows.Count >= 2) dtViewOrder.Rows.RemoveAt(dtViewOrder.Rows.Count - 1); OrderList.DataSource = dvViewOrder; OrderList.DataBind(); Even tough I am removing it afte sorting. It is removing a row and then sorting. Can anyone help:( Mads

[just3ala2]

Why don't u do that on the database side? I mean in a stored procedure u get the number of total rows and the select using "Set Rowcount " [the number - 1]

Best Regards 3ala2 :)