protected void BindWYear()
{
DataTable Dt = TMSElectricity.GetDistinctYear("sdf").Tables[0];
ddlwater.DataSource = Dt;
ddlwater.DataValueField = "DistYear";
ddlwater.DataTextField = "DistYear";
ddlwater.DataBind();
ddlwater.Items.Insert(0, new ListItem("Select", "-1"));
}
protected void BindEYear()
{
DataTable Dt = TMSElectricity.GetDistinctYear("Elecricity").Tables[0];
DdlElecricity.DataSource = Dt;
DdlElecricity.DataValueField = "DistYear";
DdlElecricity.DataTextField = "DistYear";
DdlElecricity.DataBind();
DdlElecricity.Items.Insert(0, new ListItem("Select", "-1"));
}