private void Fillpickuppoints()
        {
            Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
            DataSet ds = objbll.Viewpickpoints();

            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
        private void BindPickuppoints()
        {
            Businesslogiclayer.Businesslogiclayerclass objbll = new Businesslogiclayer.Businesslogiclayerclass();
            DataSet ds = objbll.Viewpickpoints();

            DropDownList2.DataSource     = ds;
            DropDownList2.DataTextField  = "pname";
            DropDownList2.DataValueField = "pid";
            DropDownList2.DataBind();
        }