private void frm_PantallaPrincipal_Load(object sender, EventArgs e) { ad_lib = new AccesoDatos(); string userLabel = "USER: "******"UserName", "SELECT * FROM Users WHERE idUser = "******"idUserRank", "SELECT * FROM Users WHERE idUser = "******" " + "RANK: " + ad_lib.GetTableData("DescRank", "SELECT * FROM UserRanks WHERE idUserRank = " + idRank).ToString(); txt_topuser.Text = userLabel; DataSet dtsTablaDeTablas = ad_lib.PortarTaula("MenuOptions"); foreach (DataRow dr in dtsTablaDeTablas.Tables[0].Rows) { if (Int32.Parse(dr["nivellAcces"].ToString()) >= idRank) { createButton(dr["nomOpcio"].ToString().Trim(), dr["ensamblat"].ToString().Trim(), dr["classe"].ToString().Trim()); } } createButton("MAIN", null, "frm_pantallaInicio"); //createButton("MAIN", "./", "frm_pantallaInicio"); Form newForm = new frm_pantallaInicio(); newForm.TopLevel = false; newForm.AutoScroll = true; this.formShowPanel.Controls.Add(newForm); newForm.FormBorderStyle = FormBorderStyle.None; newForm.Show(); MenuPanel.LoadMenu(); }
private void frm_InsideTemplate_Load(object sender, EventArgs e) { if (DesignMode || nomTaula == "") { return; } ad_lib = new AccesoDatos(); //Pasar nom de la taula com parametre al form a l'hora d'afegir els textbox dtsTabla = ad_lib.PortarTaula(nomTaula); dtg_BBDDdata.DataSource = dtsTabla.Tables[0]; foreach (Control ctrl in this.Controls) { if (ctrl is TextBox) { SWTextbox SWctrl = (SWTextbox)ctrl; SWctrl.DataBindings.Clear(); SWctrl.DataBindings.Add("Text", dtsTabla.Tables[0], SWctrl._TableBind); SWctrl.Validated += new System.EventHandler(this.ValidarTextBox); } else if (ctrl is ComboBox) { SWComboFK SWctrl = (SWComboFK)ctrl; DataSet dtsForeign = new DataSet(); dtsForeign = ad_lib.PortarTaula(SWctrl._ForeignTable); SWctrl.DataBindings.Clear(); SWctrl.DataSource = dtsForeign.Tables[0]; SWctrl.DisplayMember = SWctrl._Display_Member; SWctrl.ValueMember = SWctrl._Value_Member; SWctrl.DataBindings.Add("SelectedValue", dtsTabla.Tables[0], SWctrl._TableBind); SWctrl.Validated += new System.EventHandler(this.ValidarComboBox); } } }