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; } }