ORDER BY Id DESC Not working

code_Lover

Hi
I am new with datatable.
I need a help...

Here I am providing my source code for showing datatable:

C# Code:

 Order objOrder = new Order();

  private void Awaiting_Delivery_Orders()
        {
            DataTable dt = objOrder.Get_Awaiting_Delivery_Orders();

            if (dt.Rows.Count > 0)
            {                
                listOrder.DataSource = dt;
                listOrder.DataBind();
                

            }

        }

 public DataTable Get_Awaiting_Delivery_Orders()
        {
            Gateway sql = new Gateway();
            StringBuilder queryParameters = new StringBuilder();
            string query = String.Format("Select * from sys.[Order] WHERE IsDelivered = '0' ORDER BY Id Desc");
            SqlDataReader reader = sql.ExecuteSqlReader(query);
            DataTable dt = new DataTable();
            dt.Load(reader);

            return dt;
        }

Please give me a solution

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

colin

Hi @code_Lover ,

ORDER BY Id DESC Not working

In what way doesn't it work? Are you seeing errors? Is the data just not ordered?

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin