protected void ddl_emp_SelectedIndexChanged(object sender, EventArgs e) { string str = ""; str = "select ESS.ECODE,ESS.BASIC,ESS.PAY_BAND,ESS.CUR_PAY_GRADE,ESS.IT_Amount,MEM.Emp_Name,MEM.DATE_OF_BIRTH,ESS.GPF_ACCT_NO from M_Emp_mast MEM inner join EMP_SALARY_STRUCTURE ESS ON MEM.ECODE=ESS.ECODE Where ESS.ECODE='" + ddl_emp.SelectedValue + "'"; DataTable dt = SQL_DBCS.ExecuteDataTable(str); if (dt.Rows.Count > 0) { lblShowName.Text = dt.Rows[0]["EMP_NAME"].ToString(); lblPersonalNo.Text = dt.Rows[0]["ECODE"].ToString(); lblBasicPay.Text = dt.Rows[0]["BASIC"].ToString(); lblPayAccount.Text = dt.Rows[0]["GPF_ACCT_NO"].ToString(); //lblGPFNo.Text = dt.Rows[0]["GPF_ACCT_NO"].ToString(); // lblRank.Text = ddlEmpType.SelectedItem.ToString(); cc.FillDDL(ref ddlHdtrOffice, "---Select Department---", "DepartmentName", "DepartmentCode", "M_Department"); ddlHdtrOffice.SelectedIndex = 1; lblCorpOffice.Text = ddlHdtrOffice.SelectedItem.ToString(); BindRefrenceno(); } else { lblShowName.Visible = false; } BindRefrenceno(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable dt = new DataTable(); dt.Columns.Add("NameOfPlace_Arrived_At"); dt.Columns.Add("Arvl_Date"); dt.Columns.Add("Arvl_Hrs"); dt.Columns.Add("Distance_by_Road"); dt.Columns.Add("ConveyMode"); dt.Columns.Add("ConveyClass"); dt.Columns.Add("Departure_Date"); dt.Columns.Add("Departure_Hrs"); dt.Columns.Add("NoOfDA"); dt.Columns.Add("Rate_RMA_DA"); dt.Columns.Add("Amount"); dt.Columns.Add("Remark"); ViewState["dt"] = dt; bind_FinancialYear(); binddesig_type(); bindchildgrd(); bindgrdData(); cc.FillDDL(ref ddlHdtrOffice, "---Select Department---", "DepartmentName", "DepartmentCode", "M_Department"); ddlHdtrOffice.SelectedIndex = 1; } }