Sorting the grid view in asp.net

Question

private void BindGridView(string field)
    {       
        string userName = field;
        //Get OrganisationID from user Table
        string OrgIdQueryText = "SELECT tbl_organisation_OrganisationID FROM tbl_user WHERE Email ";
        int newOrgID = Convert.ToInt32(server.performQuery(OrgIdQueryText, userName, MySqlDbType.VarChar));

        MySqlCommand command = new MySqlCommand();
        DataSet ds = new DataSet();

        string MysqlStatement = "SELECT MsgID, MsgText, Title, RespondBy, ExpiresBy, OwnerName, Status FROM tbl_message WHERE tbl_user_tbl_organisation_OrganisationID = @Value1";
        using (server)
        {
            MySqlParameter[] param = new MySqlParameter[1];
            param[0] = new MySqlParameter("@value1", MySqlDbType.Int32);
            param[0].Value = newOrgID;
            command.Parameters.AddWithValue("@Value1", newOrgID);
            ds = server.ExecuteQuery(CommandType.Text, MysqlStatement, param);
        }

        Grid_Messagetable.DataSource=ds;
        Grid_Messagetable.DataBind();
}

I am data binding a grid view and It displays the row based on the MsgID. I want it to display in descending order so that the new message gets displayed on the top of the grid

Are you using <asp:boundfield in grid?

Emaad Ali
– Emaad Ali

2011-09-13 13:33:07 +00:00
Commented Sep 13, 2011 at 13:33 — Emaad Ali
– Emaad Ali, Commented Sep 13, 2011 at 13:33

Icarus · Accepted Answer · 2011-09-13 13:31:09Z

4

Change your query to do the sorting appropriately like so:

string MysqlStatement = "SELECT MsgID, MsgText, Title, RespondBy, ExpiresBy, OwnerName, Status FROM tbl_message WHERE tbl_user_tbl_organisation_OrganisationID = @Value1 order by MsgID desc";

answered Sep 13, 2011 at 13:31

Icarus

64k14 gold badges102 silver badges116 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sorting the grid view in asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related