private void WorkAllocationGrid_DoubleClick(object sender, EventArgs e) { try { btnCancle.Enabled = true; btnSaveOpts.Enabled = true; if (UserGridView.FocusedColumn.FieldName == "ProgCode" || UserGridView.FocusedColumn.FieldName == "ProgDesc") { var row = UserGridView.GetDataRow(UserGridView.FocusedRowHandle); DataSet ds = ProjectFunctions.GetDataSet(" [sp_LoadUserAlloactedPerForm] @NProgCode='" + row["ProgCode"].ToString() + "'"); ds.Tables[0].Merge(ds.Tables[1]); if (ds.Tables[0].Rows.Count > 0) { ds.Tables[0].Columns.Add("SPLRIGHTS", typeof(bool)); ds.Tables[0].Columns.Add("&Add", typeof(bool)); ds.Tables[0].Columns.Add("EDIT", typeof(bool)); ds.Tables[0].Columns.Add("DELETE", typeof(bool)); ds.Tables[0].Columns.Add("SELECTFIELD", typeof(bool)); ds.Tables[0].Columns.Add("MASTER", typeof(bool)); ds.Tables[0].Columns.Add("TRANSACTION", typeof(bool)); ds.Tables[0].Columns.Add("REPORT", typeof(bool)); ds.Tables[0].Columns.Add("ADMIN", typeof(bool)); foreach (DataRow dr in ds.Tables[0].Rows) { dr["SPLRIGHTS"] = false; dr["&Add"] = false; dr["EDIT"] = false; dr["DELETE"] = false; dr["SELECTFIELD"] = false; dr["MASTER"] = false; dr["TRANSACTION"] = false; dr["REPORT"] = false; dr["ADMIN"] = false; } for (var j = 0; j < ds.Tables[0].Rows.Count; j++) { if (ds.Tables[0].Rows[j]["ProgAdd_F"].ToString() == "-1") { ds.Tables[0].Rows[j]["&Add"] = true; } else { ds.Tables[0].Rows[j]["&Add"] = false; } if (ds.Tables[0].Rows[j]["ProgUpd_F"].ToString() == "-1") { ds.Tables[0].Rows[j]["EDIT"] = true; } else { ds.Tables[0].Rows[j]["EDIT"] = false; } if (ds.Tables[0].Rows[j]["ProgDel_F"].ToString() == "-1") { ds.Tables[0].Rows[j]["DELETE"] = true; } else { ds.Tables[0].Rows[j]["DELETE"] = false; } if (ds.Tables[0].Rows[j]["MasterMenu"].ToString() == "-1") { ds.Tables[0].Rows[j]["MASTER"] = true; } else { ds.Tables[0].Rows[j]["MASTER"] = false; } if (ds.Tables[0].Rows[j]["TransactionsMenu"].ToString() == "-1") { ds.Tables[0].Rows[j]["TRANSACTION"] = true; } else { ds.Tables[0].Rows[j]["TRANSACTION"] = false; } if (ds.Tables[0].Rows[j]["AdministratorMenu"].ToString() == "-1") { ds.Tables[0].Rows[j]["ADMIN"] = true; } else { ds.Tables[0].Rows[j]["ADMIN"] = false; } if (ds.Tables[0].Rows[j]["ReportMenu"].ToString() == "-1") { ds.Tables[0].Rows[j]["REPORT"] = true; } else { ds.Tables[0].Rows[j]["REPORT"] = false; } if (ds.Tables[0].Rows[j]["SelectField"].ToString() == "-1") { ds.Tables[0].Rows[j]["SELECTFIELD"] = true; } else { ds.Tables[0].Rows[j]["SELECTFIELD"] = false; } if (ds.Tables[0].Rows[j]["ProgSpl_U"].ToString() == "-1") { ds.Tables[0].Rows[j]["SPLRIGHTS"] = true; } else { ds.Tables[0].Rows[j]["SPLRIGHTS"] = false; } } } OptionsGrid.DataSource = ds.Tables[0]; OptionsGrid.Visible = true; OptionsGrid.Focus(); } } catch (Exception ex) { ProjectFunctions.SpeakError(ex.Message); } }