Any examples how would I enable sorting for the gridview? private void loadlist() { cn.Open(); cmd.CommandText = "select Breed, Name, Image from Animals"; dr = cmd.ExecuteReader(); cn.Close();

    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        AddData();
        Addimage();

    }

    protected void AddData()
    {
        if (TextBox1.Text != "" & TextBox2.Text != "")
        {
            cn.Open();
            cmd.CommandText = "insert into Animals (Breed, Name) values ('" + TextBox1.Text + "', '" + TextBox2.Text + "')";
            cmd.ExecuteNonQuery();
            cmd.Clone();
            cn.Close();
            loadlist();
        }
    }

    protected void DisplayData()
    {
        cn.Open();
        cmd.CommandText = "select Breed, Name from Animals";
        dr = cmd.ExecuteReader();
        GridView1.DataSource = dr;
        GridView1.DataBind();

        cn.Close();
    }