protected void BindWaterSupply()
    {
        try
        {
            string wyear = null;

            if (ddlwater.SelectedValue != "-1")
            {
                wyear = ddlwater.SelectedValue;
            }
            else
            {
                wyear = null;
            }

            DataTable dtGriedViewWater = TMSWatersupply.GetWatersupplySEARCH(null, null, null, null, wyear, null, null, null, null, null, null).Tables[0];
            if (dtGriedViewWater.Rows.Count > 0)
            {
                sectionSortWater.Visible = true;
            }
            else
            {
                sectionSortWater.Visible = false;
            }
            GrdWaterSupply.DataSource = dtGriedViewWater;
            GrdWaterSupply.DataBind();
        }
        catch (Exception ex) { }
    }