showing the last record at top in grid view.

See more:

C#

ASP.NET

i am showing orderid, orderdate, customerid, totalamount in a gridview. i want to show the last record at top of a gridview. how can i do it??

 public void bind()
    {
        string query = "select OrderID,CustomerID,OrderDate,totalAmount,Status From Orders";
        DataSet ds = obj.fillgrid(query);
        GridView1.DataSource = ds.Tables[0];
        GridView1.DataBind();
    }
}