protected void ddlHouseNO_SelectedIndexChanged(object sender, EventArgs e)
 {
     try
     {
         if (ddlHouseNO.SelectedIndex != 0)
         {
             DataSet ds = Cls_HousesMaster.ShowBuildingApprovalNOSelectHouseno(Convert.ToInt32(ddlHouseNO.SelectedValue));
             if (ds.Tables[0].Rows.Count != 0)
             {
                 txtBuildingApprovalNo.Text = ds.Tables[0].Rows[0][13].ToString();
             }
             else
             {
                 txtBuildingApprovalNo.Text = "";
             }
         }
         else
         {
         }
     }
     catch (Exception ex)
     {
         lblError.Text = ex.Message;
     }
 }
 protected void ddlRevenueCircleName_SelectedIndexChanged(object sender, EventArgs e)
 {
     try
     {
         if (ddlRevenueCircleName.SelectedIndex != 0)
         {
             ddlBlockName.Items.Clear();
             DataSet ds = Cls_HousesMaster.SelectRevenuCircleId(Convert.ToInt32(ddlRevenueCircleName.SelectedValue));
             if (ds.Tables[0].Rows.Count != 0)
             {
                 ddlBlockName.DataSource     = ds.Tables[0];
                 ddlBlockName.DataTextField  = "RevenueBlockName";
                 ddlBlockName.DataValueField = "RevenueBlockId";
                 ddlBlockName.DataBind();
                 ddlBlockName.Items.Insert(0, "--SelectOne--");
             }
             else
             {
                 ddlBlockName.Items.Insert(0, "--SelectOne--");
                 //   txtBuildingApprovalNo.Text = "";
             }
         }
     }
     catch (Exception ex)
     {
         lblError.Text = ex.Message;
     }
 }
 public void GetData()
 {
     try
     {
         DataSet ds = Cls_HousesMaster.ShowHouseReports();
         if (ds.Tables[0].Rows.Count != 0)
         {
             gridReport.DataSource = ds.Tables[0];
             gridReport.DataBind();
         }
     }
     catch (Exception ex)
     {
         lblError.Text = ex.Message;
     }
 }