private void bindData() { PenjaminanViewDataset.AccessRow dr = Access.selectAccessByID(eID); Models.PenjaminanDatasetTableAdapters.u_roleTableAdapter taRole = new Models.PenjaminanDatasetTableAdapters.u_roleTableAdapter(); Models.PenjaminanDatasetTableAdapters.tPageTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.tPageTableAdapter(); PageList.DataSource = (PenjaminanDataset.tPageDataTable)ta.GetDataByID(Convert.ToInt16(dr.fk_page)); RoleList.DataSource = (PenjaminanDataset.u_roleDataTable)taRole.GetDataRoleByID(Convert.ToInt16(dr.fk_role)); PageList.DataBind(); RoleList.DataBind(); //txtUsername.Value = dr.username.ToString(); //txtPassword.Value = dr.password.ToString(); //txtRole.Value = dr.role.ToString(); //txtDivision.Value = dr.division.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserProfile"] == null) { Response.Redirect("/Default.aspx"); } if (!Page.IsPostBack) { if (eType == "add") { } else if (eType == "edit") { bindData(); } else if (eType == "delete") { softDeleteData(eID); } } lblMenu.Text = "Entry Master Access"; Session["activepage"] = "Access"; if (!Page.IsPostBack) { Models.PenjaminanDatasetTableAdapters.tPageTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.tPageTableAdapter(); Models.PenjaminanDatasetTableAdapters.u_roleTableAdapter taRole = new Models.PenjaminanDatasetTableAdapters.u_roleTableAdapter(); PageList.DataSource = (PenjaminanDataset.tPageDataTable)ta.GetData(); PageList.DataBind(); RoleList.DataSource = (PenjaminanDataset.u_roleDataTable)taRole.GetData(); RoleList.DataBind(); if (eType == "edit") { PenjaminanViewDataset.AccessRow dr = Access.selectAccessByID(eID); tPageID = Convert.ToInt16(dr.fk_page); tRoleID = Convert.ToInt16(dr.fk_role); PageList.SelectedValue = tPageID.ToString(); RoleList.SelectedValue = tRoleID.ToString(); } } }
public static PenjaminanViewDataset.AccessRow selectAccessByID(int id) { PenjaminanViewDatasetTableAdapters.AccessTableAdapter ta = new PenjaminanViewDatasetTableAdapters.AccessTableAdapter(); PenjaminanViewDataset.AccessDataTable dt = new PenjaminanViewDataset.AccessDataTable(); PenjaminanViewDataset.AccessRow dr = null; try { ta.FillByID(dt, id); if (dt.Count > 0) { dr = dt[0]; } return(dr); } catch (Exception ex) { throw new ApplicationException("Failed to load Employee data : " + ex.Message); } }