using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

 

using Utilities;

 

namespace GridViews

{

    public partial class GridViewExample5 : System.Web.UI.Page

    {

        DBConnect objDB = new DBConnect();

 

        protected void Page_Load(object sender, EventArgs e)

        {

 

        }

 

        public void Display(String sortKey)

        {

            String strSQL = "SELECT * FROM Product ORDER BY '" + sortKey + "'";

            gvProducts.DataSource = objDB.GetDataSet(strSQL);

            gvProducts.DataBind();

        }

 

        protected void lstSortType_SelectedIndexChanged(object sender, EventArgs e)

        {

            Display(lstSortType.SelectedItem.Value);

        }

 

 

 

    }

}