protected void BindGrid() { DataTable dt = ClassJopPosition.LoadData(); this.ss_dt = dt; datagrid.DataSource = dt; datagrid.DataBind(); }
protected void btnAdd_Click(object sender, EventArgs e) { JobPositionEN pos = ClassJopPosition.SearchByPosid(Convert.ToInt16(ddlPosition.SelectedValue)); JobPosition_EmpEN en = new JobPosition_EmpEN(); en.empid = this.empid; en.posid = Convert.ToInt16(ddlPosition.SelectedValue); en.cost = pos.cost; ClassJopPosition.InsertPosition_Emp(en); BindPosition_Emp(); }
private void LoadControl() { DataTable dt = ClassJopPosition.LoadDept(); DataRow dr = dt.NewRow(); dr["id"] = 0; dr["Name"] = "-- กรุณาเลือก --"; dt.Rows.InsertAt(dr, 0); ddlDept.DataTextField = "Name"; ddlDept.DataValueField = "id"; ddlDept.DataSource = dt; ddlDept.DataBind(); }
public void BindPosition_Emp() { DataTable dt = ClassJopPosition.SearchPosiionByEmp(this.empid); if (dt.Rows.Count == 0) { DataRow dr = dt.NewRow(); dr["position"] = ""; dr["pos_id"] = 0; dt.Rows.Add(dr); } datagrid.DataSource = dt; datagrid.DataBind(); }
private void LoadPosition() { DataTable dt = ClassJopPosition.LoadData(); // Set Defult if (dt.Rows.Count == 0) { DataRow dr = dt.NewRow(); dr["position"] = ""; dr["cost"] = ""; dt.Rows.Add(dr); } dt.Columns.Add("name"); foreach (DataRow dr in dt.Rows) { dr["name"] = dr["position"] + " " + dr["cost"] + " บาท"; } ddlPosition.DataTextField = "name"; ddlPosition.DataValueField = "id"; ddlPosition.DataSource = dt; ddlPosition.DataBind(); }