private void dtgCompetition() { metroGrid2.EditMode = DataGridViewEditMode.EditOnEnter; //ComboBox 유형의 셀 만들고 DataGridViewComboBoxColumn[] ComboBoxCell = new DataGridViewComboBoxColumn[mainFrm.selectCompetitionAndSimilarity.Where(c => c).Count() - 1]; //DisplayStyle을 ComboBox로 설정 for (int i = 0; i < ComboBoxCell.Count(); i++) { ComboBoxCell[i] = new DataGridViewComboBoxColumn(); ComboBoxCell[i].Name = mainFrm.SelectedCompetitionMenu[i]; ComboBoxCell[i].Items.Add("열세"); ComboBoxCell[i].Items.Add("유사"); ComboBoxCell[i].Items.Add("우세"); ComboBoxCell[i].DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; ComboBoxCell[i].FlatStyle = FlatStyle.Flat; } textBox1.Size = metroGrid2.Size; metroGrid2.Location = new Point(textBox1.Location.X, textBox1.Location.Y + textBox1.Size.Height + 1); metroGrid2.Rows.Clear(); metroGrid2.RowHeadersVisible = false; metroGrid2.ColumnHeadersVisible = true; metroGrid2.ColumnCount = 2; metroGrid2.Columns[0].Name = "기 종"; metroGrid2.Columns[1].Name = "단 가"; for (int i = 0; i < Competition2.CompetitionWeapon.Length; i++) { metroGrid2.Rows.Add(Competition2.CompetitionWeapon[i]); metroGrid2.Rows[i].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; metroGrid2.Rows[i].Cells[0].Style.BackColor = Color.FromArgb(222, 235, 247); } metroGrid2.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(32, 56, 100); metroGrid2.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; metroGrid2.ColumnHeadersDefaultCellStyle.Font = new Font("나눔고딕", 9, FontStyle.Bold); DataGridViewColumn dataGridViewColumn = metroGrid2.Columns[0]; dataGridViewColumn.HeaderCell.Style.BackColor = Color.FromArgb(91, 155, 213); dataGridViewColumn.HeaderCell.Style.ForeColor = Color.White; // 단가 DataGridViewColumn dataGridViewColumn2 = metroGrid2.Columns[1]; dataGridViewColumn2.HeaderCell.Style.BackColor = Color.FromArgb(255, 192, 0); dataGridViewColumn2.HeaderCell.Style.ForeColor = Color.Black; // 구분 색깔 for (int i = 0; i < 1; i++) { metroGrid2.Rows[i].Cells[0].ReadOnly = true; metroGrid2.Rows[i].Cells[1].ReadOnly = true; } int count = 0; for (int i = 0; i < mainFrm.selectCompetitionAndSimilarity.Length; i++) { if (mainFrm.CompetitionData[0, i].ToString().IndexOf("Prices") != -1 || mainFrm.CompetitionData[0, i].ToString().IndexOf("단가") != -1 || mainFrm.CompetitionData[0, i].ToString().IndexOf("가격") != -1) { continue; } if (mainFrm.selectCompetitionAndSimilarity[i] == true) { metroGrid2.Columns.Add(ComboBoxCell[count]); count++; } } #region 경쟁무기체계 DB에서 추가함 // 경쟁무기체계를 추가함 for (int j = 0; j < metroGrid2.RowCount; j++) { metroGrid2.Rows[j].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; metroGrid2.Rows[j].Cells[1].Style.BackColor = Color.White; // metroGrid2.Rows[j].Cells[1].Style.ForeColor = Color.White; metroGrid2.Rows[j].Cells[1].ReadOnly = true; } for (int i = 2; i < metroGrid2.ColumnCount; i++) { for (int j = 0; j < metroGrid2.RowCount; j++) { metroGrid2.Rows[j].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; metroGrid2.Rows[j].Cells[i].Style.BackColor = Color.White; } } #endregion // Design metroGrid2.DefaultCellStyle.BackColor = Color.White; this.metroGrid2.DefaultCellStyle.Font = new Font("나눔고딕", 9); for (int i = 0; i < metroGrid2.RowCount; i++) { metroGrid2.Rows[i].Cells[0].Style.WrapMode = DataGridViewTriState.False; } metroGrid2.Columns[0].Width = 300; metroGrid2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCellsExceptHeader; for (int i = 1; i < metroGrid2.ColumnCount; i++) { metroGrid2.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } foreach (DataGridViewColumn column in metroGrid2.Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; column.DefaultCellStyle.Font = new Font("나눔고딕", 9); } for (int i = 2; i < metroGrid2.ColumnCount; i++) { for (int j = 0; j < metroGrid2.RowCount; j++) { int WeaponIndex = mainFrm.CompetitionWeapon.IndexOf(metroGrid2.Rows[j].Cells[0].Value.ToString()); int SpecIndex = Array.IndexOf(mainFrm.FullSpecCompetitionAndSimilarity, metroGrid2.Columns[i].Name.ToString()); metroGrid2.Rows[j].Cells[i].Value = mainFrm.CostEffectiveCompetitionAndSimilar[WeaponIndex, SpecIndex]; } } // metroGrid2.CurrentCell = null; }
public void FillComboDatagrid(DataGridViewComboBoxColumn dgvc) { mAsig.FillComboDatagridView(dgvc); }
private void InitTaskGrid() { this._taskGrid.AutoGenerateColumns = false; this._taskGrid.AllowUserToAddRows = false; this._taskGrid.MultiSelect = false; this._taskGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; this._taskGrid.RowHeadersWidthSizeMode = DataGridViewRowHeadersWidthSizeMode.DisableResizing; this._taskGrid.RowHeadersWidth = c_gridRowHeadersWidth; if (_tasksHolder != null) { this._taskGrid.DataSource = Tasks; } this._taskGrid.CellClick += new DataGridViewCellEventHandler(_taskGrid_CellClick); this._taskGrid.CurrentCellChanged += new EventHandler(_taskGrid_CurrentCellChanged); this._taskGrid.DataError += new DataGridViewDataErrorEventHandler(_taskGrid_DataError); this._taskGrid.CellFormatting += new DataGridViewCellFormattingEventHandler(_taskGrid_CellFormatting); this._taskGrid.CellParsing += new DataGridViewCellParsingEventHandler(_taskGrid_CellParsing); this._taskGrid.CellPainting += new DataGridViewCellPaintingEventHandler(_taskGrid_CellPainting); this._taskGrid.RowsAdded += new DataGridViewRowsAddedEventHandler(_taskGrid_RowsAdded); this._taskGrid.RowsRemoved += new DataGridViewRowsRemovedEventHandler(_taskGrid_RowsRemoved); this._taskGrid.DataBindingComplete += new DataGridViewBindingCompleteEventHandler(_taskGrid_DataBindingComplete); this._taskGrid.CurrentCellDirtyStateChanged += new EventHandler(_taskGrid_CurrentCellDirtyStateChanged); // file name: DataGridViewTextBoxColumn colFileName = new DataGridViewTextBoxColumn(); colFileName.Name = "File Name"; colFileName.DataPropertyName = "FileName"; colFileName.HeaderCell.Style.WrapMode = DataGridViewTriState.False; colFileName.Width = c_gridFileNameWidth; _taskGrid.Columns.Add(colFileName); _taskGridInfo.FileNameColIdx = colFileName.Index; // file selection ellipsis: DataGridViewButtonColumn colFileSelect = new DataGridViewButtonColumn(); // using column template allows to set tooltip properly: DataGridViewButtonCell tpl = new DataGridViewButtonCell(); tpl.ToolTipText = "Click to select file name"; tpl.UseColumnTextForButtonValue = true; colFileSelect.CellTemplate = tpl; colFileSelect.Text = "\x2026"; // ellipsis colFileSelect.Width = c_btnWidth; colFileSelect.MinimumWidth = c_btnWidth; colFileSelect.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; colFileSelect.Resizable = DataGridViewTriState.False; colFileSelect.HeaderCell.Style.WrapMode = DataGridViewTriState.False; _taskGrid.Columns.Add(colFileSelect); _taskGridInfo.FileSelectColIdx = colFileSelect.Index; // report name: DataGridViewComboBoxColumn colReportName = new DataGridViewComboBoxColumn(); colReportName.DataPropertyName = "ReportName"; colReportName.Name = "Report Name"; colReportName.ValueType = typeof(string); colReportName.HeaderCell.Style.WrapMode = DataGridViewTriState.False; colReportName.Width = c_gridReportNameWidth; _taskGrid.Columns.Add(colReportName); _taskGridInfo.ReportNameColIdx = colReportName.Index; // task type: DataGridViewComboBoxColumn colTaskKind = new DataGridViewComboBoxColumn(); colTaskKind.DataPropertyName = "ReportKind"; colTaskKind.Name = "Report Type"; colTaskKind.DataSource = c_taskKinds; colTaskKind.ValueType = typeof(ReportKind); colTaskKind.HeaderCell.Style.WrapMode = DataGridViewTriState.False; _taskGrid.Columns.Add(colTaskKind); _taskGridInfo.TaskKindColIdx = colTaskKind.Index; // task checked status: DataGridViewImageColumn colCheckedStatus = new DataGridViewImageColumn(); colCheckedStatus.DataPropertyName = "CheckedStatus"; colCheckedStatus.Width = c_btnWidth; colCheckedStatus.MinimumWidth = c_btnWidth; colCheckedStatus.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; colCheckedStatus.Resizable = DataGridViewTriState.False; colCheckedStatus.HeaderCell.Style.WrapMode = DataGridViewTriState.False; _taskGrid.Columns.Add(colCheckedStatus); _taskGridInfo.CheckedStatusColIdx = colCheckedStatus.Index; // task state: DataGridViewTextBoxColumn colReady = new DataGridViewTextBoxColumn(); colReady.ReadOnly = true; colReady.Name = "Status"; colReady.DataPropertyName = "State"; colReady.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; colReady.HeaderCell.Style.WrapMode = DataGridViewTriState.False; _taskGrid.Columns.Add(colReady); _taskGridInfo.ReadyColIdx = colReady.Index; }
private void btnLoadFile_Click(object sender, EventArgs e) { if (openFileDialog.ShowDialog() == DialogResult.OK) { using (var _session = SoSession.Authenticate(Username, Password)) { DataGridViewComboBoxColumn rolesColumn = (DataGridViewComboBoxColumn)dtUsersList.Columns["Role"]; rolesColumn.DataSource = roles.ToList(); rolesColumn.DisplayMember = "Name"; DataGridViewComboBoxColumn groupsColumn = (DataGridViewComboBoxColumn)dtUsersList.Columns["UserGroup"]; groupsColumn.DataSource = groups.ToList(); groupsColumn.DisplayMember = "Value"; p = new FileParser(openFileDialog.FileName); MessageBox.Show("File parsed, " + p.UserInfos.Count.ToString() + " users read\n"); foreach (ImportUserInfo ui in p.UserInfos) { ContactTableInfo cti = TablesInfo.GetContactTableInfo(); OwnerContactLinkTableInfo octi = TablesInfo.GetOwnerContactLinkTableInfo(); Select findOc = S.NewSelect("Find OC"); findOc.JoinRestriction.InnerJoin(cti.ContactId.Equal(octi.ContactId)); // if contact name contains a comma, assume that pre-comma is name and post-comma is department (db & file are set up that way) if (ui.Company.Contains(",")) { findOc.Restriction = cti.Name.Equal(S.Parameter(ui.Company.Split(',')[0].Trim())). And(cti.Department.Equal(S.Parameter(ui.Company.Split(',')[1].Trim()))); } else { findOc.Restriction = cti.Name.Equal(S.Parameter(ui.Company)); } findOc.ReturnFields.Add(cti.ContactId); int ocId = QueryExecutionHelper.ExecuteTypedScalar <int>(findOc); if (ocId == 0) { //MessageBox.Show("Owner company " + ui.Company + "(referenced by " + ui.UID + ") does not exist OR is not an Owner Company - setting to License Owner " + SoSystemInfo.GetCurrent().CompanyName); ui.Company = SoSystemInfo.GetCurrent().CompanyName; if (!_contacts.ContainsKey(SoSystemInfo.GetCurrent().CompanyName)) { _contacts.Add(ui.Company, SoSystemInfo.GetCurrent().CompanyId); } } else if (!_contacts.ContainsKey(ui.Company)) { _contacts.Add(ui.Company, ocId); } if (!_roles.ContainsKey(ui.Role)) { ui.Role = DefaultRole; } if (!_groups.ContainsKey(ui.Group)) { ui.Group = DefaultGroup; } } Dictionary <string, int> users = Importer.FindUsers(); dtUsersList.AutoGenerateColumns = false; dtUsersList.Columns["FirstName"].DataPropertyName = "FirstName"; dtUsersList.Columns["LastName"].DataPropertyName = "LastName"; dtUsersList.Columns["FullName"].DataPropertyName = "FullName"; dtUsersList.Columns["UserName"].DataPropertyName = "UID"; dtUsersList.Columns["Email"].DataPropertyName = "Email"; dtUsersList.Columns["Role"].DataPropertyName = "Role"; dtUsersList.Columns["UserGroup"].DataPropertyName = "Group"; dtUsersList.Columns["Company"].DataPropertyName = "Company"; dtUsersList.Columns["AssociateId"].DataPropertyName = "AssociateId"; dtUsers = Importer.ConvertToDataTable <ImportUserInfo>(p.UserInfos); dtUsersList.DataSource = dtUsers; //dtUsersList.DataSource = p.UserInfos; progressBar.Value = 0; foreach (DataGridViewRow item in dtUsersList.Rows) { string username = item.Cells["UserName"].Value.ToString(); if (users.ContainsKey(username)) { item.Cells["Status"].Value = "Exists"; item.Cells["AssociateId"].Value = users[username]; string license = Importer.GetLicense(users[username], LookupList); item.Cells["AssignedLicenses"].Value = license; } else { item.Cells["AssociateId"].Value = DBNull.Value; item.Cells["Status"].Value = "New"; item.Cells["AssignedLicenses"].Value = ""; } } } btnProcess.Enabled = true; progressBar.Value = 0; txtSearch.Text = ""; lblSearch.Visible = true; txtSearch.Visible = true; } }
public void SetEditable(bool bEditable) { m_bIsEditable = bEditable; if (m_bIsEditable) { // 设定标题栏,默认有个隐藏列 this.Header = new string[] { CS_Delete, CS_StationID, CS_StationName, CS_TimeCollected, CS_TotalRain, CS_DifferenceRain, CS_PeriodRain, CS_DayRain, CS_DataState, CS_TimeReceived, CS_ChannelType, CS_MsgType }; // this.HideColomns = new int[] { 10 }; //开启编辑模式,设置可编辑列 DataGridViewCheckBoxColumn deleteCol = new DataGridViewCheckBoxColumn(); base.SetColumnEditStyle(0, deleteCol); //// 设置采集时间编辑列 //CalendarColumn collectionCol = new CalendarColumn(); //base.SetColumnEditStyle(3, collectionCol); // 累计雨量编辑列 DataGridViewNumericUpDownColumn totalRain = new DataGridViewNumericUpDownColumn() { Minimum = 0, Maximum = 65537, DecimalPlaces = 1 /*好像是设置小数点后面的位数*/ }; base.SetColumnEditStyle(4, totalRain); //// 差值雨量编辑列 //DataGridViewNumericUpDownColumn differneceRain = new DataGridViewNumericUpDownColumn() //{ // Minimum = 0, // Maximum = 65537, // DecimalPlaces = 1 /*好像是设置小数点后面的位数*/ //}; //base.SetColumnEditStyle(5, differneceRain); //// 时段雨量编辑列 //DataGridViewNumericUpDownColumn periodRain = new DataGridViewNumericUpDownColumn() //{ // Minimum = 0, // Maximum = 65537, // DecimalPlaces = 1 /*好像是设置小数点后面的位数*/ //}; //base.SetColumnEditStyle(6, periodRain); //// 日雨量 //DataGridViewNumericUpDownColumn dayRain = new DataGridViewNumericUpDownColumn() //{ // Minimum = 0, // Maximum = 65537, // DecimalPlaces = 1 /*好像是设置小数点后面的位数*/ //}; //base.SetColumnEditStyle(7, dayRain); // 数据状态,可编辑列 DataGridViewComboBoxColumn dataStateCol = new DataGridViewComboBoxColumn(); dataStateCol.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; dataStateCol.Items.AddRange(new object[] { CS_DataState_Normal, CS_DataState_AbNormal, CS_DataState_Warning }); base.SetColumnEditStyle(8, dataStateCol); // 接收时间 CalendarColumn recvTime = new CalendarColumn(); base.SetColumnEditStyle(9, recvTime); // 通讯方式,不可编辑 // 报文类型,不可编辑 // 设置删除列的宽度 this.Columns[0].Width = 40; //删除列宽度为20 this.Columns[1].Width = 60; this.Columns[3].Width = 125; this.Columns[4].Width = 70; this.Columns[5].Width = 70; this.Columns[6].Width = 70; this.Columns[7].Width = 70; this.Columns[8].Width = 60; this.Columns[9].Width = 125; // 接收时间 } else { this.Columns[0].Width = 60; this.Columns[2].Width = 125; this.Columns[3].Width = 70; this.Columns[4].Width = 70; this.Columns[5].Width = 70; this.Columns[6].Width = 70; this.Columns[7].Width = 60; this.Columns[8].Width = 125; // 接收时间 //this.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; //this.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } }
private void createDinamicDataGridViewToOrders() { if (dgv != null) { return; } dgv = new DataGridView(); dgv.CellContentClick += Dgv_CellContentClick; dgv.DefaultValuesNeeded += Dgv_DefaultValuesNeeded; dgv.CellValueChanged += Dgv_CellValueChanged; DataGridViewComboBoxColumn cbc = new DataGridViewComboBoxColumn(); cbc.Name = "pizzaName"; cbc.HeaderText = " Pizza név "; cbc.MaxDropDownItems = 5; cbc.DataSource = repo.getPizzasName(); cbc.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; DataGridViewButtonColumn bcPlusz = new DataGridViewButtonColumn(); bcPlusz.UseColumnTextForButtonValue = true; bcPlusz.HeaderText = "Mennyiség növelés"; bcPlusz.Name = "bcPlusz"; bcPlusz.Text = "+"; bcPlusz.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; DataGridViewButtonColumn bcMinusz = new DataGridViewButtonColumn(); bcMinusz.UseColumnTextForButtonValue = true; bcMinusz.HeaderText = "Mennyiség csökkentés"; bcMinusz.Name = "bcMinusz"; bcMinusz.Text = "-"; bcMinusz.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; DataGridViewTextBoxColumn tbcMennyiseg = new DataGridViewTextBoxColumn(); tbcMennyiseg.HeaderText = "Mennyiség"; tbcMennyiseg.Name = "mennyiseg"; tbcMennyiseg.ReadOnly = true; tbcMennyiseg.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader; DataGridViewTextBoxColumn tbcEgysegar = new DataGridViewTextBoxColumn(); tbcEgysegar.HeaderText = "Egységár"; tbcEgysegar.Name = "egysegar"; tbcEgysegar.ReadOnly = true; tbcEgysegar.AutoSizeMode = DataGridViewAutoSizeColumnMode.ColumnHeader; dgv.Location = new Point(30, 60); dgv.Width = 600; dgv.Columns.Add(cbc); dgv.Columns.Add(bcPlusz); dgv.Columns.Add(bcMinusz); dgv.Columns.Add(tbcMennyiseg); dgv.Columns.Add(tbcEgysegar); tabPageMegrendeles.Controls.Add(dgv); }
private void LoadDataGridViewColumns() { try { DataGridViewTextBoxColumn tbDiffStatus = new DataGridViewTextBoxColumn(); tbDiffStatus.Name = "差異狀態"; tbDiffStatus.Width = 100; tbDiffStatus.HeaderText = "差異狀態"; tbDiffStatus.ReadOnly = true; DataGridViewComboBoxColumn cbProcStatus = new DataGridViewComboBoxColumn(); cbProcStatus.Name = "處理方式"; cbProcStatus.Width = 90; cbProcStatus.Width = 120; cbProcStatus.HeaderText = "處理方式"; DataTable dtPitems = new DataTable(); dtPitems.Columns.Add("ITEM"); dtPitems.Columns.Add("VALUE"); List <string> items = new List <string>(); items.Add("更新"); items.Add("略過"); items.Add("刪除"); items.Add("新增"); foreach (string str in items) { DataRow dr = dtPitems.NewRow(); dr["ITEM"] = str; dr["VALUE"] = str; dtPitems.Rows.Add(dr); } cbProcStatus.DataSource = dtPitems; cbProcStatus.DisplayMember = "ITEM"; cbProcStatus.ValueMember = "VALUE"; DataGridViewTextBoxColumn tbDomain = new DataGridViewTextBoxColumn(); tbDomain.Name = "領域"; tbDomain.Width = 70; tbDomain.HeaderText = "領域"; tbDomain.ReadOnly = true; DataGridViewTextBoxColumn tbScoreType = new DataGridViewTextBoxColumn(); tbScoreType.Name = "分項類別"; tbScoreType.Width = 90; tbScoreType.HeaderText = "分項類別"; tbScoreType.ReadOnly = true; DataGridViewTextBoxColumn tbSubjectName = new DataGridViewTextBoxColumn(); tbSubjectName.Name = "科目名稱"; tbSubjectName.Width = 150; tbSubjectName.HeaderText = "科目名稱"; tbSubjectName.ReadOnly = true; DataGridViewTextBoxColumn tbRequiredBy = new DataGridViewTextBoxColumn(); tbRequiredBy.Name = "校訂部定"; tbRequiredBy.Width = 90; tbRequiredBy.HeaderText = "校訂部定"; tbRequiredBy.ReadOnly = true; DataGridViewTextBoxColumn tbIsRequired = new DataGridViewTextBoxColumn(); tbIsRequired.Name = "必選修"; tbIsRequired.Width = 90; tbIsRequired.HeaderText = "必選修"; tbIsRequired.ReadOnly = true; DataGridViewTextBoxColumn tbGS11 = new DataGridViewTextBoxColumn(); tbGS11.Name = "1上"; tbGS11.Width = 60; tbGS11.HeaderText = "1上"; tbGS11.ReadOnly = true; DataGridViewTextBoxColumn tbGS12 = new DataGridViewTextBoxColumn(); tbGS12.Name = "1下"; tbGS12.Width = 60; tbGS12.HeaderText = "1下"; tbGS12.ReadOnly = true; DataGridViewTextBoxColumn tbGS21 = new DataGridViewTextBoxColumn(); tbGS21.Name = "2上"; tbGS21.Width = 60; tbGS21.HeaderText = "2上"; tbGS21.ReadOnly = true; DataGridViewTextBoxColumn tbGS22 = new DataGridViewTextBoxColumn(); tbGS22.Name = "2下"; tbGS22.Width = 60; tbGS22.HeaderText = "2下"; tbGS22.ReadOnly = true; DataGridViewTextBoxColumn tbGS31 = new DataGridViewTextBoxColumn(); tbGS31.Name = "3上"; tbGS31.Width = 60; tbGS31.HeaderText = "3上"; tbGS31.ReadOnly = true; DataGridViewTextBoxColumn tbGS32 = new DataGridViewTextBoxColumn(); tbGS32.Name = "3下"; tbGS32.Width = 60; tbGS32.HeaderText = "3下"; tbGS32.ReadOnly = true; DataGridViewTextBoxColumn tbOpenStatus = new DataGridViewTextBoxColumn(); tbOpenStatus.Name = "開課方式"; tbOpenStatus.Width = 90; tbOpenStatus.HeaderText = "開課方式"; tbOpenStatus.ReadOnly = true; DataGridViewTextBoxColumn tbCourseCode = new DataGridViewTextBoxColumn(); tbCourseCode.Name = "課程代碼"; tbCourseCode.Width = 300; tbCourseCode.HeaderText = "課程代碼"; tbCourseCode.ReadOnly = true; dgData.Columns.Add(tbDiffStatus); dgData.Columns.Add(cbProcStatus); dgData.Columns.Add(tbDomain); dgData.Columns.Add(tbScoreType); dgData.Columns.Add(tbSubjectName); dgData.Columns.Add(tbRequiredBy); dgData.Columns.Add(tbIsRequired); dgData.Columns.Add(tbGS11); dgData.Columns.Add(tbGS12); dgData.Columns.Add(tbGS21); dgData.Columns.Add(tbGS22); dgData.Columns.Add(tbGS31); dgData.Columns.Add(tbGS32); dgData.Columns.Add(tbOpenStatus); dgData.Columns.Add(tbCourseCode); //// 因為自動排序有些問題,先將關閉 //foreach(DataGridViewColumn col in dgData.Columns ) //{ // col.SortMode = DataGridViewColumnSortMode.NotSortable; //} } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public static void CarregaComboEnum <T>(ref DataGridViewComboBoxColumn combo, bool todos) { combo.DataSource = TrataEnum.Listar(typeof(T), todos); combo.DisplayMember = "Value"; combo.ValueMember = "Key"; }
public override void Execute(object cmdParams) { if (!MinoApi.LicenseCheck.LicenceCheck())// 20180427 { return; } //get the root of physical//all physical TxPhysicalRoot physRoot = TxApplication.ActiveDocument.PhysicalRoot; //need filter.robot ITxTypeFilter objFilter = new TxTypeFilter(typeof(TxRobot)); //return all descendants by filter TxObjectList objst = physRoot.GetAllDescendants(objFilter); // TxApplication.ActiveUndoManager.StartTransaction(); MinoApi.MinoCEEForm rz = new MinoApi.MinoCEEForm(); // rz.Robots = new TxRobot[objst.Count]; if (objst.Count > 0) { TxRobot tr = objst[0] as TxRobot; if (tr.Controller.Name == "Fanuc-Rj") { rz.radioButton2.Checked = true; } else { rz.radioButton1.Checked = true; } } List <TxRobot> Roblist = new List <TxRobot>(); foreach (TxRobot robot in objst) { Roblist.Add(robot); } Roblist = Roblist.OrderBy(s => s.Name).ToList(); int c = objst.Count, i = 0; System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle(); dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; dataGridViewCellStyle1.Font = new System.Drawing.Font("宋体", 11F); rz.dataGridView3.Columns[0].HeaderCell.Style = dataGridViewCellStyle1; System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Menu; DataGridViewComboBoxColumn col = rz.dataGridView2.Columns[0] as DataGridViewComboBoxColumn; foreach (TxRobot robot in Roblist) { rz.Robots[i] = robot; DataGridViewTextBoxColumn dc = new System.Windows.Forms.DataGridViewTextBoxColumn(); dc.HeaderText = robot.Name; dc.Name = "Column" + i + 1; dc.HeaderCell.Style = dataGridViewCellStyle1; dc.DefaultCellStyle = dataGridViewCellStyle1; dc.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; rz.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { dc }); rz.dataGridView3.Rows.Add(); rz.dataGridView3.Rows[i].Cells[0].Value = robot.Name; rz.dataGridView1.Rows.Add(); rz.dataGridView1.Rows[i].Cells[i].Style = dataGridViewCellStyle2; DataGridViewTextBoxColumn dc1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); dc1.HeaderText = robot.Name; dc1.Name = "Column" + i + 1; dc1.HeaderCell.Style = dataGridViewCellStyle1; dc1.DefaultCellStyle = dataGridViewCellStyle1; dc1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; rz.dataGridView8.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { dc1 }); col.Items.Add(robot.Name); i = i + 1; } TxApplication.ActiveUndoManager.EndTransaction(); rz.dataGridView8.Rows.Add(); rz.Show(); }
private DataGridView GetDGV(InventoryPouch pouch) { // Add DataGrid DataGridView dgv = new DataGridView { Dock = DockStyle.Fill, Text = pouch.Type.ToString(), Name = DGVPrefix + pouch.Type, AllowUserToAddRows = false, AllowUserToDeleteRows = false, AllowUserToResizeRows = false, AllowUserToResizeColumns = false, RowHeadersVisible = false, //ColumnHeadersVisible = false, MultiSelect = false, ShowEditingIcon = false, EditMode = DataGridViewEditMode.EditOnEnter, ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single, ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize, SelectionMode = DataGridViewSelectionMode.CellSelect, CellBorderStyle = DataGridViewCellBorderStyle.None, }; int c = 0; DataGridViewComboBoxColumn dgvItemVal = new DataGridViewComboBoxColumn { HeaderText = "Item", DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing, DisplayIndex = c++, Width = 135, FlatStyle = FlatStyle.Flat }; DataGridViewColumn dgvIndex = new DataGridViewTextBoxColumn(); { dgvIndex.HeaderText = "Count"; dgvIndex.DisplayIndex = c++; dgvIndex.Width = 45; dgvIndex.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; if (!Main.HaX) { ((DataGridViewTextBoxColumn)dgvIndex).MaxInputLength = (int)(Math.Log10(Math.Max(1, pouch.MaxCount)) + 1); } } dgv.Columns.Add(dgvItemVal); dgv.Columns.Add(dgvIndex); if (HasFreeSpace) { DataGridViewCheckBoxColumn dgvFree = new DataGridViewCheckBoxColumn { HeaderText = "Free", DisplayIndex = c++, Width = 40, FlatStyle = FlatStyle.Flat }; dgv.Columns.Add(dgvFree); } if (HasNew) { DataGridViewCheckBoxColumn dgvNew = new DataGridViewCheckBoxColumn { HeaderText = "NEW", DisplayIndex = c++, Width = 40, FlatStyle = FlatStyle.Flat }; dgv.Columns.Add(dgvNew); } var itemcount = pouch.Items.Length; string[] itemarr = Main.HaX ? (string[])itemlist.Clone() : GetItems(pouch.LegalItems); var combo = dgv.Columns[0] as DataGridViewComboBoxColumn; foreach (string t in itemarr) { combo.Items.Add(t); // add only the Item Names } dgv.Rows.Add(itemcount > 0 ? itemcount : itemarr.Length); dgv.CancelEdit(); return(dgv); }
[NUnit.Framework.Category("NotWorking")] // DGVComboBox not implemented public void AddRow_Changes() { using (DataGridView dgv = new DataGridView()) { DataGridViewColumn col = new DataGridViewComboBoxColumn(); DataGridViewRow row = new DataGridViewRow(); DataGridViewCell cell = new DataGridViewComboBoxCell(); Assert.IsNotNull(row.AccessibilityObject, "#A row.AccessibilityObject"); Assert.IsNotNull(row.Cells, "#A row.Cells"); Assert.IsNull(row.ContextMenuStrip, "#A row.ContextMenuStrip"); Assert.IsNull(row.DataBoundItem, "#A row.DataBoundItem"); Assert.IsNull(row.DataGridView, "#A row.DataGridView"); Assert.IsNotNull(row.DefaultCellStyle, "#A row.DefaultCellStyle"); Assert.IsNotNull(row.DefaultHeaderCellType, "#A row.DefaultHeaderCellType"); Assert.AreEqual(false, row.Displayed, "#A row.Displayed"); Assert.AreEqual(0, row.DividerHeight, "#A row.DividerHeight"); Assert.AreEqual(@"", row.ErrorText, "#A row.ErrorText"); Assert.AreEqual(false, row.Frozen, "#A row.Frozen"); Assert.AreEqual(true, row.HasDefaultCellStyle, "#A row.HasDefaultCellStyle"); Assert.IsNotNull(row.HeaderCell, "#A row.HeaderCell"); // DPI Dependent? // Assert.AreEqual (22, row.Height, "#A row.Height"); Assert.AreEqual(-1, row.Index, "#A row.Index"); try { object zxf = row.InheritedStyle; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#A row.InheritedStyle"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the InheritedStyle property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#A row.InheritedStyle"); } Assert.AreEqual(false, row.IsNewRow, "#A row.IsNewRow"); Assert.AreEqual(3, row.MinimumHeight, "#A row.MinimumHeight"); Assert.AreEqual(false, row.ReadOnly, "#A row.ReadOnly"); Assert.AreEqual(DataGridViewTriState.NotSet, row.Resizable, "#A row.Resizable"); Assert.AreEqual(false, row.Selected, "#A row.Selected"); Assert.AreEqual(DataGridViewElementStates.Visible, row.State, "#A row.State"); Assert.IsNull(row.Tag, "#A row.Tag"); Assert.AreEqual(true, row.Visible, "#A row.Visible"); row.Cells.Add(cell); Assert.IsNotNull(row.AccessibilityObject, "#B row.AccessibilityObject"); Assert.IsNotNull(row.Cells, "#B row.Cells"); Assert.IsNull(row.ContextMenuStrip, "#B row.ContextMenuStrip"); Assert.IsNull(row.DataBoundItem, "#B row.DataBoundItem"); Assert.IsNull(row.DataGridView, "#B row.DataGridView"); Assert.IsNotNull(row.DefaultCellStyle, "#B row.DefaultCellStyle"); Assert.IsNotNull(row.DefaultHeaderCellType, "#B row.DefaultHeaderCellType"); Assert.AreEqual(false, row.Displayed, "#B row.Displayed"); Assert.AreEqual(0, row.DividerHeight, "#B row.DividerHeight"); Assert.AreEqual(@"", row.ErrorText, "#B row.ErrorText"); Assert.AreEqual(false, row.Frozen, "#B row.Frozen"); Assert.AreEqual(true, row.HasDefaultCellStyle, "#B row.HasDefaultCellStyle"); Assert.IsNotNull(row.HeaderCell, "#B row.HeaderCell"); // DPI Dependent? // Assert.AreEqual (22, row.Height, "#B row.Height"); Assert.AreEqual(-1, row.Index, "#B row.Index"); try { object zxf = row.InheritedStyle; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#B row.InheritedStyle"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the InheritedStyle property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#B row.InheritedStyle"); } Assert.AreEqual(false, row.IsNewRow, "#B row.IsNewRow"); Assert.AreEqual(3, row.MinimumHeight, "#B row.MinimumHeight"); Assert.AreEqual(false, row.ReadOnly, "#B row.ReadOnly"); Assert.AreEqual(DataGridViewTriState.NotSet, row.Resizable, "#B row.Resizable"); Assert.AreEqual(false, row.Selected, "#B row.Selected"); Assert.AreEqual(DataGridViewElementStates.Visible, row.State, "#B row.State"); Assert.IsNull(row.Tag, "#B row.Tag"); Assert.AreEqual(true, row.Visible, "#B row.Visible"); dgv.Columns.Add(col); Assert.IsNotNull(row.AccessibilityObject, "#C row.AccessibilityObject"); Assert.IsNotNull(row.Cells, "#C row.Cells"); Assert.IsNull(row.ContextMenuStrip, "#C row.ContextMenuStrip"); Assert.IsNull(row.DataBoundItem, "#C row.DataBoundItem"); Assert.IsNull(row.DataGridView, "#C row.DataGridView"); Assert.IsNotNull(row.DefaultCellStyle, "#C row.DefaultCellStyle"); Assert.IsNotNull(row.DefaultHeaderCellType, "#C row.DefaultHeaderCellType"); Assert.AreEqual(false, row.Displayed, "#C row.Displayed"); Assert.AreEqual(0, row.DividerHeight, "#C row.DividerHeight"); Assert.AreEqual(@"", row.ErrorText, "#C row.ErrorText"); Assert.AreEqual(false, row.Frozen, "#C row.Frozen"); Assert.AreEqual(true, row.HasDefaultCellStyle, "#C row.HasDefaultCellStyle"); Assert.IsNotNull(row.HeaderCell, "#C row.HeaderCell"); // DPI Dependent? // Assert.AreEqual (22, row.Height, "#C row.Height"); Assert.AreEqual(-1, row.Index, "#C row.Index"); try { object zxf = row.InheritedStyle; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#C row.InheritedStyle"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the InheritedStyle property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#C row.InheritedStyle"); } Assert.AreEqual(false, row.IsNewRow, "#C row.IsNewRow"); Assert.AreEqual(3, row.MinimumHeight, "#C row.MinimumHeight"); Assert.AreEqual(false, row.ReadOnly, "#C row.ReadOnly"); Assert.AreEqual(DataGridViewTriState.NotSet, row.Resizable, "#C row.Resizable"); Assert.AreEqual(false, row.Selected, "#C row.Selected"); Assert.AreEqual(DataGridViewElementStates.Visible, row.State, "#C row.State"); Assert.IsNull(row.Tag, "#C row.Tag"); Assert.AreEqual(true, row.Visible, "#C row.Visible"); dgv.Rows.Add(row); Assert.IsNotNull(row.AccessibilityObject, "#D row.AccessibilityObject"); Assert.IsNotNull(row.Cells, "#D row.Cells"); try { object zxf = row.ContextMenuStrip; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.ContextMenuStrip"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Operation cannot be performed on a shared row.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.ContextMenuStrip"); } Assert.IsNull(row.DataBoundItem, "#D row.DataBoundItem"); Assert.IsNotNull(row.DataGridView, "#D row.DataGridView"); Assert.IsNotNull(row.DefaultCellStyle, "#D row.DefaultCellStyle"); Assert.IsNotNull(row.DefaultHeaderCellType, "#D row.DefaultHeaderCellType"); try { object zxf = row.Displayed; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.Displayed"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the Displayed property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.Displayed"); } Assert.AreEqual(0, row.DividerHeight, "#D row.DividerHeight"); try { object zxf = row.ErrorText; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.ErrorText"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Operation cannot be performed on a shared row.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.ErrorText"); } try { object zxf = row.Frozen; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.Frozen"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the Frozen property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.Frozen"); } Assert.AreEqual(true, row.HasDefaultCellStyle, "#D row.HasDefaultCellStyle"); Assert.IsNotNull(row.HeaderCell, "#D row.HeaderCell"); // DPI Dependent? // Assert.AreEqual (22, row.Height, "#D row.Height"); Assert.AreEqual(-1, row.Index, "#D row.Index"); try { object zxf = row.InheritedStyle; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.InheritedStyle"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the InheritedStyle property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.InheritedStyle"); } Assert.AreEqual(false, row.IsNewRow, "#D row.IsNewRow"); Assert.AreEqual(3, row.MinimumHeight, "#D row.MinimumHeight"); try { object zxf = row.ReadOnly; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.ReadOnly"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the ReadOnly property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.ReadOnly"); } try { object zxf = row.Resizable; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.Resizable"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the Resizable property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.Resizable"); } try { object zxf = row.Selected; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.Selected"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the Selected property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.Selected"); } try { object zxf = row.State; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.State"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the State property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.State"); } Assert.IsNull(row.Tag, "#D row.Tag"); try { object zxf = row.Visible; TestHelper.RemoveWarning(zxf); Assert.Fail("Expected 'System.InvalidOperationException', but no exception was thrown.", "#D row.Visible"); } catch (InvalidOperationException ex) { Assert.AreEqual(@"Getting the Visible property of a shared row is not a valid operation.", ex.Message); } catch (Exception ex) { Assert.Fail("Expected 'System.InvalidOperationException', got '" + ex.GetType().FullName + "'.", "#D row.Visible"); } } }
public void CreateTable(int type) { table = new DataTable(); switch (type) { case 1: string sqlselect = string.Empty; if (lista_modifica.SelectedItem.ToString() == lista_modifica.Items[0].ToString()) { sqlselect = string.Format("SELECT IDProfesor,Nume,Prenume FROM Materii;"); table = MyData.readTable(sqlselect); string sql = string.Format("SELECT ID_Materie,Nume_Materie FROM TabelMaterii;"); table_materii = MyData.readTable(sql); table.Columns.Add("Materie"); for (int i = 0; i < table.Rows.Count; i++) { string materie_sql = string.Format("SELECT IDMaterie FROM Materii WHERE IDProfesor={0};", table.Rows[i][0]); int materie_id = MyData.selectData(materie_sql, "IDMaterie"); for (int j = 0; j < table_materii.Rows.Count; j++) { if (Convert.ToInt32(table_materii.Rows[j][0]) == materie_id) { table.Rows[i]["Materie"] = table_materii.Rows[j][1]; } } } } else { sqlselect = string.Format("SELECT ID_Student,Nume,Prenume FROM Grades;"); table = MyData.readTable(sqlselect); } date_dgv.Columns.Clear(); date_dgv.DataSource = table; DataGridViewButtonColumn btn = new DataGridViewButtonColumn(); btn.HeaderText = "Sterge " + lista_modifica.SelectedItem.ToString(); btn.Name = "delete_btn"; btn.Text = "Sterge"; btn.ValueType = typeof(Button); btn.UseColumnTextForButtonValue = true; date_dgv.Columns.Add(btn); break; case 2: string sqlmodifica = string.Empty; if (lista_modifica.SelectedItem.ToString() == lista_modifica.Items[0].ToString()) { sqlmodifica = string.Format("SELECT Materii.IDProfesor,Materii.Nume,Materii.Prenume,TabelMaterii.Nume_Materie,Profesori.Nick,Profesori.Pass FROM Materii,TabelMaterii,Profesori WHERE Profesori.IDMaterie=TabelMaterii.ID_Materie AND Profesori.ID_Prof=Materii.IDProfesor;"); table = MyData.readTable(sqlmodifica); modifica_dgv.Columns.Clear(); modifica_dgv.DataSource = table; //Remodelate coloana 4 intr-o lista dropdown DataGridViewComboBoxColumn list_materii = new DataGridViewComboBoxColumn(); list_materii.HeaderText = "Materie"; list_materii.Name = "lst_materii"; DataTable dt = getMaterii(); object[] obj = new object[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { obj[i] = dt.Rows[i]["Nume_Materie"]; } list_materii.Items.AddRange(obj); modifica_dgv.Columns.RemoveAt(3); modifica_dgv.Columns.Add(list_materii); for (int i = 0; i < modifica_dgv.RowCount; i++) { modifica_dgv["lst_materii", i].Value = table.Rows[i]["Nume_Materie"]; } //buton cu ce teste a adaugat DataGridViewButtonColumn ts = new DataGridViewButtonColumn(); ts.Name = "teste_btn"; ts.HeaderText = "Teste adaugate"; ts.Text = "Editeaza"; ts.UseColumnTextForButtonValue = true; ts.ValueType = typeof(Button); modifica_dgv.Columns.Add(ts); modifica_dgv.Columns["IDProfesor"].ReadOnly = true; } else { sqlmodifica = string.Format("SELECT Grades.ID_Student,Grades.Nume,Grades.Prenume,Studenti.Nick,Studenti.Parola,Grades.Materii_inscris FROM Studenti,Grades WHERE Grades.ID_Student=Studenti.ID_Student;"); table = MyData.readTable(sqlmodifica); modifica_dgv.Columns.Clear(); modifica_dgv.DataSource = table; modifica_dgv.Columns["Materii_inscris"].Name = "ID_Materii"; //buton teste windows DataGridViewButtonColumn button = new DataGridViewButtonColumn(); button.Name = "teste_btn"; button.HeaderText = "Teste"; button.Text = "Vezi teste"; button.ValueType = typeof(Button); button.UseColumnTextForButtonValue = true; modifica_dgv.Columns.Add(button); modifica_dgv.Columns["ID_Student"].ReadOnly = true; } break; } }
public static void InitializeComboBox(String dataAdapterapterString, String displayMem, String valueMem, object[] defaultDataRowParams, ref DataGridViewComboBoxColumn combBx) { SqlDataAdapter dataAdapter = new SqlDataAdapter(@dataAdapterapterString, SqlC.c); DataTable dataTable = new DataTable(); dataAdapter.Fill(dataTable); DataRow defaultDataRow = dataTable.NewRow(); defaultDataRow.ItemArray = defaultDataRowParams; dataTable.Rows.InsertAt(defaultDataRow, 0); double symbolScale = 6.45; int maxItemLenght = combBx.Width; for (int i = 0; i < dataTable.Rows.Count; i++) { if (maxItemLenght < ((int)(dataTable.Rows[i][displayMem].ToString().Length *symbolScale))) { maxItemLenght = ((int)(dataTable.Rows[i][displayMem].ToString().Length *symbolScale)); } } combBx.DropDownWidth = maxItemLenght; combBx.DataSource = dataTable; combBx.DisplayMember = displayMem; combBx.ValueMember = valueMem; }
protected void AddColumn(DataGridView grid, int colType, string Field, bool IsHide, bool HasSort, byte CenterFlag, int colWidth) { DataGridViewTextBoxColumn colText; DataGridViewCheckBoxColumn colCheck; DataGridViewComboBoxColumn colCombo; switch (colType) { case 0: colText = new DataGridViewTextBoxColumn(); colText.DataPropertyName = Field; colText.Visible = !IsHide; if (!HasSort) { colText.SortMode = DataGridViewColumnSortMode.NotSortable; } colText.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; if (CenterFlag == 1) { colText.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; } else if (CenterFlag == 2) { colText.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } if (colWidth > 0) { colText.Width = colWidth; } else { colText.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } grid.Columns.Add(colText); break; case 1: colCheck = new DataGridViewCheckBoxColumn(); colCheck.DataPropertyName = Field; colCheck.Visible = !IsHide; colCheck.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; if (CenterFlag == 1) { colCheck.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; } else if (CenterFlag == 2) { colCheck.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } if (colWidth > 0) { colCheck.Width = colWidth; } else { colCheck.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } grid.Columns.Add(colCheck); break; case 2: colCombo = new DataGridViewComboBoxColumn(); colCombo.DataPropertyName = Field; colCombo.Visible = !IsHide; colCombo.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; if (CenterFlag == 1) { colCombo.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; } else if (CenterFlag == 2) { colCombo.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; } if (colWidth > 0) { colCombo.Width = colWidth; } else { colCombo.AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; } colCombo.DisplayStyleForCurrentCellOnly = true; grid.Columns.Add(colCombo); break; } }
public void AddItemsInComboBox(DataGridViewComboBoxColumn comboboxColumn) { //DB_Part_OS2Entities db = new DB_Part_OS2Entities(); //comboboxColumn.Items.AddRange((from d in db.tbl_Modul_Name select d.Short_Name_Modul_Name).ToArray()); }
public static void AddColumns(TSDataGridView dgv, TSGrid hsGrid) { if (dgv == null) { throw new ArgumentNullException("dgv"); } if (hsGrid == null) { throw new ArgumentNullException("hsGrid"); } List <TSGridColumn> columns = hsGrid.Columns; DataGridViewColumn[] gridColumns = new DataGridViewColumn[columns.Count]; for (int i = 0, count = columns.Count; i < count; i++) { TSGridColumn col = columns[i]; DataGridViewColumn column = null; switch (col.ColumnType) { case TSGridColumnType.CheckBox: { column = new DataGridViewCheckBoxColumn(); } break; case TSGridColumnType.Image: { column = new DataGridViewImageColumn(); column.Tag = col.DefaultValue; } break; case TSGridColumnType.Text: { column = new DataGridViewTextBoxColumn(); } break; case TSGridColumnType.ComboBox: { column = new DataGridViewComboBoxColumn(); } break; case TSGridColumnType.NumericUpDown: { var numericCell = new DataGridViewNumericUpDownColumn(); numericCell.Minimum = 0; numericCell.Increment = 1; numericCell.Maximum = 100; column = numericCell; } break; default: { column = new DataGridViewTextBoxColumn(); } break; } if (col.ValueType == DataValueType.Float) { column.DefaultCellStyle.Format = "##0.000"; } column.HeaderText = col.Text; column.Name = col.Name; column.Width = col.Width; column.ReadOnly = (col.ReadOnly != 0) ? true : false; column.Visible = (col.Visible != 0) ? true : false; gridColumns[i] = column; if (hsGrid.Background == 1 && column.ReadOnly) { column.DefaultCellStyle.BackColor = Color.FromArgb(244, 243, 234); } } dgv.Columns.AddRange(gridColumns); }
private void SubTopicDetails() { Sbd = new StringBuilder(); Sbd.Remove(0, Sbd.Length); Sbd.Append("SELECT "); Sbd.Append("S.SubTopicName,"); Sbd.Append("P.Para_Desc 'TopicStatus',"); Sbd.Append("S.SubTopicId "); Sbd.Append("FROM SubTopic S "); Sbd.Append("INNER JOIN Parameter P ON P.Para_BPC = 'DetailsGroup' AND P.Para_Type = 'status' AND P.Para_Code = S.SubTopicStatus "); Sbd.Append("WHERE S.SubTopicStatus <> 'I' "); Sbd.Append(" AND S.SubTopicId NOT IN (SELECT M.SubTopicId FROM MainTopicMappingDetail M "); Sbd.Append("INNER JOIN MainTopicMapping T ON M.TopicMappingId = T.TopicMappingId "); Sbd.Append("INNER JOIN DetailsGroup G ON G.DetailGroupId = T.DetailGroupId "); Sbd.Append("INNER JOIN SubSubject S ON S.SubSubjectId = G.SubSubjectId WHERE S.SubSubjectName = 'VFR' )"); string sql = Sbd.ToString(); Cmd = new SqlCommand(); Cmd.Parameters.Clear(); Cmd.CommandText = sql; Cmd.CommandType = CommandType.Text; Cmd.Connection = Conn; Sdr = Cmd.ExecuteReader(); if (Sdr.HasRows) { DataGridViewCheckBoxColumn chkColSelect = new DataGridViewCheckBoxColumn(); chkColSelect.Name = "chkSelect"; chkColSelect.TrueValue = true; chkColSelect.Width = 130; chkColSelect.DisplayIndex = 18; chkColSelect.FlatStyle = FlatStyle.Popup; dgv_SubTopic.Columns.Add(chkColSelect); DataTable dt = new DataTable(); dt.Load(Sdr); dgv_SubTopic.DataSource = dt; DataGridViewComboBoxColumn column = new DataGridViewComboBoxColumn(); column.HeaderText = "Style"; column.Items.Add("Default"); column.Items.Add("Additional"); column.Name = "cmbName"; dgv_SubTopic.Columns.Add(column); dgv_SubTopic.ClearSelection(); lbSumList.Text = "Count Sub-Topic : " + dgv_SubTopic.Rows.Count.ToString(); dgv_Header(); } else { dgv_SubTopic.DataSource = null; } Sdr.Close(); }
/// <summary> /// Fill a list by the specified Enum type. /// </summary> /// <typeparam name="TEnum">The type of a Enum.</typeparam> /// <param name="list">A DataGridViewComboBoxColumn.</param> /// <param name="firstIsEmpty">True: the first item should be empty.</param> public static void Fill <TEnum>(DataGridViewComboBoxColumn list, bool firstIsEmpty) where TEnum : struct { FillDropdown <DataGridViewComboBoxColumn, TEnum>(list, firstIsEmpty); }
private void PopulateListStudentAttendance() { if (!isFormLoaded) { return; } timeTable = _timeTableservice.GetTimeTableByID(Convert.ToInt32(cbxClassSchedule.SelectedValue)); if (cbxClassSchedule.SelectedValue != null) { List <LecturerStudentAttendanceItem> studentAttendanceItems = _studentAttendanceService.GetLecturerStudentAttendance(timeTable.LecturerID, timeTable.IntakeID, timeTable.SubjectID, timeTable.SubjectDay, ((DateTime.Now.DayOfYear + 3) / 7)); DataGridViewComboBoxColumn cmb = new DataGridViewComboBoxColumn(); var presenceStatuses = _presenceStatus.GetAll(); presenceStatuses.Insert(0, new PresenceStatus { PresenceStatusID = 0, PresenceStatusName = "Select Status" }); cmb.DataSource = presenceStatuses; cmb.DisplayMember = "PresenceStatusName"; cmb.ValueMember = "PresenceStatusID"; cmb.HeaderText = "PresenceStatus"; cmb.Name = "PresenceStatus"; cmb.DataPropertyName = "PresenceStatus"; dgvStudentAttendance.Rows.Clear(); dgvStudentAttendance.ReadOnly = false; dgvStudentAttendance.ColumnCount = 9; dgvStudentAttendance.Columns[0].Name = "StudentAttendanceID"; dgvStudentAttendance.Columns[1].Name = "StudentID"; dgvStudentAttendance.Columns[2].Name = "IntakeID"; dgvStudentAttendance.Columns[3].Name = "SubjectID"; dgvStudentAttendance.Columns[4].Name = "LecturerID"; dgvStudentAttendance.Columns[5].Name = "DayOfWeek"; dgvStudentAttendance.Columns[6].Name = "WeekOfYear"; dgvStudentAttendance.Columns[7].Name = "Date"; dgvStudentAttendance.Columns[8].Name = "Student Name"; dgvStudentAttendance.Columns.Add(cmb); dgvStudentAttendance.Columns["StudentAttendanceID"].Visible = false; dgvStudentAttendance.Columns["WeekOfYear"].Visible = false; dgvStudentAttendance.Columns["DayOfWeek"].Visible = false; dgvStudentAttendance.Columns["Date"].Visible = false; dgvStudentAttendance.Columns["LecturerID"].Visible = false; dgvStudentAttendance.Columns["SubjectID"].Visible = false; dgvStudentAttendance.Columns["StudentID"].ReadOnly = true; dgvStudentAttendance.Columns["IntakeID"].ReadOnly = true; dgvStudentAttendance.Columns["Student NAme"].ReadOnly = true; for (int i = 0; i < studentAttendanceItems.Count; i++) { string[] row = new string[] { studentAttendanceItems[i].StudentAttendanceID.ToString(), studentAttendanceItems[i].StudentID, studentAttendanceItems[i].IntakeID, studentAttendanceItems[i].SubjectID.ToString(), studentAttendanceItems[i].LecturerID, studentAttendanceItems[i].DayOfWeek.ToString(), studentAttendanceItems[i].WeekOfyear.ToString(), studentAttendanceItems[i].Date.ToString(), studentAttendanceItems[i].StudentFullName.ToString() }; dgvStudentAttendance.Rows.Add(row); dgvStudentAttendance.Rows[i].Cells["PresenceStatus"].Value = studentAttendanceItems[i].PresenceStatusID; } if (dgvStudentAttendance.Rows.Count == 0) { btnPublishStudentAttendance.Enabled = false; } else { btnPublishStudentAttendance.Enabled = true; } } }
/// <summary> /// Fill a list by the specified data. /// </summary> /// <param name="list">A DataGridViewComboBoxColumn.</param> /// <param name="items">The data used to fill <paramref name="list"/>.</param> /// <param name="firstIsEmpty">True: the first item should be empty.</param> public static void Fill(DataGridViewComboBoxColumn list, IEnumerable <DropdownItem> items, bool firstIsEmpty) { FillDropdown <DataGridViewComboBoxColumn>(list, items, firstIsEmpty); }
private void SearchBanksForm_Load(object sender, EventArgs e) { try { AccountFields.Add(new Field("banksortcode", "string")); AccountFields.Add(new Field("bankcode", "string")); AccountFields.Add(new Field("bankname", "string")); AccountFields.Add(new Field("branchcode", "string")); AccountFields.Add(new Field("branchname", "string")); cbField.DataSource = AccountFields; cbField.DisplayMember = "Name"; cbField.ValueMember = "Name"; cbOperator.DataSource = Op.GetList(); cbOperator.DisplayMember = "Description"; cbOperator.ValueMember = "Symbol"; lstCriteria.DataSource = criteriaBuilder.CriterionItemList(); var _Banksquery = from b in db.Banks select b; List <Bank> _Banks = _Banksquery.ToList(); DataGridViewComboBoxColumn colBank = new DataGridViewComboBoxColumn(); colBank.HeaderText = "Bank"; colBank.Name = "cbBank"; colBank.DataSource = _Banks; colBank.DisplayMember = "BankName"; colBank.DataPropertyName = "BankCode"; colBank.ValueMember = "BankCode"; colBank.MaxDropDownItems = 10; colBank.DisplayIndex = 4; colBank.MinimumWidth = 5; colBank.Width = 200; colBank.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; colBank.FlatStyle = FlatStyle.Flat; colBank.DefaultCellStyle.NullValue = "--- Select ---"; colBank.ReadOnly = true; if (!this.dataGridViewBanks.Columns.Contains("cbBank")) { dataGridViewBanks.Columns.Add(colBank); } var _BankBranchesquery = from bb in db.BankBranches select bb; List <BankBranch> _BankBranches = _BankBranchesquery.ToList(); DataGridViewComboBoxColumn colBranch = new DataGridViewComboBoxColumn(); colBranch.HeaderText = "Branch"; colBranch.Name = "cbBranch"; colBranch.DataSource = _BankBranches; colBranch.DisplayMember = "BranchName"; colBranch.DataPropertyName = "BankSortCode"; colBranch.ValueMember = "BankSortCode"; colBranch.MaxDropDownItems = 10; colBranch.DisplayIndex = 3; colBranch.MinimumWidth = 5; colBranch.Width = 150; colBranch.FlatStyle = FlatStyle.Flat; colBranch.DefaultCellStyle.NullValue = "--- Select ---"; colBranch.ReadOnly = true; if (!this.dataGridViewBanks.Columns.Contains("cbBranch")) { dataGridViewBanks.Columns.Add(colBranch); } this.dataGridViewBanks.AutoGenerateColumns = false; this.dataGridViewBanks.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } catch (Exception ex) { Utils.ShowError(ex); } }
private void GenerarColumnas() { // Creando la columna Nro. Documento DataGridViewTextBoxColumn colNroDoc = new DataGridViewTextBoxColumn(); // Creamos la nueva columna y definimos el tipo de columna colNroDoc.Name = "nro_doc"; // Asignamos un nombre a la columna colNroDoc.HeaderText = "Nro. Documento"; // Indicamos el título a mostrar colNroDoc.DataPropertyName = "nro_doc"; // Indicamos con cual columna del DataTable que asignamos al // DataSource de la grilla debe vincularse colNroDoc.DisplayIndex = 0; // En que posición debe mostrarse, todas las columnas a la derecha // de la posición que indiquemos se moverán una posción a la derecha this.dgvUsuarios.Columns.Add(colNroDoc); // Agregamos la columna al DataGridView para que la muestre // Creando la columna Tipo Documento DataGridViewComboBoxColumn colTipoDoc = new DataGridViewComboBoxColumn(); colTipoDoc.Name = "tipo_doc"; colTipoDoc.HeaderText = "Tipo Documento"; colTipoDoc.DataPropertyName = "tipo_doc"; colTipoDoc.DisplayIndex = 0; /* * // Agrego items manualmente * colTipoDoc.Items.Add(1); * colTipoDoc.Items.Add(2); * colTipoDoc.Items.Add(3); * colTipoDoc.Items.Add(4); * colTipoDoc.Items.Add(5); */ colTipoDoc.DataSource = this.getTiposDocumento(); // Asigno la lista de items que son válidos colTipoDoc.ValueMember = "cod_tipo_doc"; // Indico que el valor interno del combo es el // valor de la fila elegida y la columna cod_tipo_doc // del DataSource que asigné a la columna colTipoDoc colTipoDoc.DisplayMember = "desc_tipo_doc"; // Indico que el valor que se muestra al usuario es el // que se corresponde con la columna desc_tipo_doc // del DataSource que asigné a colTipoDoc independientemente // de la columna de la cual obtiene su valor this.dgvUsuarios.Columns.Add(colTipoDoc); DataGridViewTextBoxColumn colTel = new DataGridViewTextBoxColumn(); colTel.Name = "telefono"; colTel.HeaderText = "Teléfono"; colTel.DataPropertyName = "telefono"; DataGridViewTextBoxColumn colEmail = new DataGridViewTextBoxColumn(); colEmail.Name = "email"; colEmail.HeaderText = "E-Mail"; colEmail.DataPropertyName = "email"; DataGridViewTextBoxColumn colCel = new DataGridViewTextBoxColumn(); colCel.Name = "celular"; colCel.HeaderText = "Celular"; colCel.DataPropertyName = "celular"; DataGridViewTextBoxColumn colUsuario = new DataGridViewTextBoxColumn(); colUsuario.Name = "usuario"; colUsuario.HeaderText = "Usuario"; colUsuario.DataPropertyName = "usuario"; DataGridViewTextBoxColumn colClave = new DataGridViewTextBoxColumn(); colClave.Name = "clave"; colClave.HeaderText = "Clave"; colClave.DataPropertyName = "clave"; colEmail.Width = 250; colNroDoc.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; colClave.Visible = false; // Como las columnas direccion, nombre, apellido y fecha de nacimiento las creamos // con el diseñador de formularios no disponemos de una variable para hacer // referencia a ellas. Entonces debemos referenciarlas con // this.dgvUsuarios.Columns["nombre_columna"] donde el nombre_columna es lo que // indicamos en la propiedad Name de las columnas this.dgvUsuarios.Columns["direccion"].Width = 250; this.dgvUsuarios.Columns["apellido"].DefaultCellStyle.Font = new Font(this.dgvUsuarios.DefaultCellStyle.Font, FontStyle.Bold); this.dgvUsuarios.Columns["nombre"].DefaultCellStyle.Font = new Font(this.dgvUsuarios.DefaultCellStyle.Font, FontStyle.Bold); this.dgvUsuarios.Columns["fecha_nac"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; this.dgvUsuarios.Columns.Add(colTel); this.dgvUsuarios.Columns.Add(colEmail); this.dgvUsuarios.Columns.Add(colCel); this.dgvUsuarios.Columns.Add(colUsuario); this.dgvUsuarios.Columns.Add(colClave); }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); var form = new Form(); var dg = new DataGridView { Dock = DockStyle.Fill, Parent = form }; dg.AllowUserToAddRows = dg.AllowUserToDeleteRows = false; var colId = new DataGridViewTextBoxColumn { HeaderText = "Id", ReadOnly = true }; var colName = new DataGridViewTextBoxColumn { HeaderText = "Name" }; var colCity = new DataGridViewComboBoxColumn { HeaderText = "City" }; var colAction = new DataGridViewButtonColumn { HeaderText = "Action" }; colName.ReadOnly = true; colCity.ReadOnly = true; colCity.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; colAction.Text = "Edit"; dg.Columns.AddRange(colId, colName, colCity, colAction); var data = new[] { new { Id = 1, Name = "Mitch", City = "Kolkata" }, new { Id = 2, Name = "Simon", City = "Delhi" }, new { Id = 3, Name = "Poly", City = "Madras" }, }; colCity.Items.AddRange(data.Select(item => item.City).Distinct().ToArray()); foreach (var item in data) { dg.Rows.Add(item.Id, item.Name, item.City, "Edit"); } Action <DataGridViewRow> enterEditMode = row => { var cellName = (DataGridViewTextBoxCell)row.Cells[colName.Index]; var cellCity = (DataGridViewComboBoxCell)row.Cells[colCity.Index]; var cellAction = (DataGridViewButtonCell)row.Cells[colAction.Index]; cellName.ReadOnly = false; cellCity.ReadOnly = false; cellCity.DisplayStyle = DataGridViewComboBoxDisplayStyle.ComboBox; dg.CurrentCell = cellName; dg.BeginEdit(true); cellAction.Value = "Save"; }; Action <DataGridViewRow> exitEditMode = row => { var cellName = (DataGridViewTextBoxCell)row.Cells[colName.Index]; var cellCity = (DataGridViewComboBoxCell)row.Cells[colCity.Index]; var cellAction = (DataGridViewButtonCell)row.Cells[colAction.Index]; cellName.ReadOnly = true; cellCity.ReadOnly = true; cellCity.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; cellAction.Value = "Edit"; }; dg.CellContentClick += (sender, e) => { if (e.ColumnIndex == colAction.Index) { var row = dg.Rows[e.RowIndex]; var cellAction = (DataGridViewButtonCell)row.Cells[colAction.Index]; if ((string)cellAction.Value == "Edit") { enterEditMode(row); } else if (dg.EndEdit()) { // Save code goes here ... exitEditMode(row); } } }; dg.RowValidated += (sender, e) => { var row = dg.Rows[e.RowIndex]; var cellAction = (DataGridViewButtonCell)row.Cells[colAction.Index]; if ((string)cellAction.Value == "Save") { exitEditMode(row); } }; Application.Run(form); }
/// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(QuestionSetEditor)); this.groupBox2 = new System.Windows.Forms.GroupBox(); this.questionSetsDataGrid = new System.Windows.Forms.DataGridView(); this.idDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.typeIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.subtypeIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.difficultyLevelIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.pictureDataGridViewImageColumn = new System.Windows.Forms.DataGridViewImageColumn(); this.difficultyLevel = new System.Windows.Forms.DataGridViewComboBoxColumn(); this.TypeId = new System.Windows.Forms.DataGridViewComboBoxColumn(); this.SubtypeId = new System.Windows.Forms.DataGridViewComboBoxColumn(); this.Idpas = new System.Windows.Forms.DataGridViewComboBoxColumn(); this.setIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.questionOrderDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.questionZoneDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.questionIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.buttonUp = new System.Windows.Forms.Button(); this.imageList = new System.Windows.Forms.ImageList(this.components); this.addExistingButton = new System.Windows.Forms.Button(); this.addNewButton = new System.Windows.Forms.Button(); this.removeButton = new System.Windows.Forms.Button(); this.buttonDown = new System.Windows.Forms.Button(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.inZone3 = new System.Windows.Forms.Label(); this.inZone2 = new System.Windows.Forms.Label(); this.inZone1 = new System.Windows.Forms.Label(); this.label8 = new System.Windows.Forms.Label(); this.label6 = new System.Windows.Forms.Label(); this.label4 = new System.Windows.Forms.Label(); this.typeLable = new System.Windows.Forms.Label(); this.timeLable = new System.Windows.Forms.Label(); this.numberOfQuestionsLable = new System.Windows.Forms.Label(); this.label1 = new System.Windows.Forms.Label(); this.label5 = new System.Windows.Forms.Label(); this.label7 = new System.Windows.Forms.Label(); this.groupBox3 = new System.Windows.Forms.GroupBox(); this.descriptionTextBox = new System.Windows.Forms.TextBox(); this.nameTextBox = new System.Windows.Forms.TextBox(); this.label2 = new System.Windows.Forms.Label(); this.label3 = new System.Windows.Forms.Label(); ((System.ComponentModel.ISupportInitialize)(this.data)).BeginInit(); this.groupBox2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.questionSetsDataGrid)).BeginInit(); this.groupBox1.SuspendLayout(); this.groupBox3.SuspendLayout(); this.SuspendLayout(); // // groupBox2 // this.groupBox2.Controls.Add(this.questionSetsDataGrid); this.groupBox2.Controls.Add(this.buttonUp); this.groupBox2.Controls.Add(this.addExistingButton); this.groupBox2.Controls.Add(this.addNewButton); this.groupBox2.Controls.Add(this.removeButton); this.groupBox2.Controls.Add(this.buttonDown); this.groupBox2.FlatStyle = System.Windows.Forms.FlatStyle.System; this.groupBox2.Location = new System.Drawing.Point(3, 248); this.groupBox2.Name = "groupBox2"; this.groupBox2.Size = new System.Drawing.Size(774, 381); this.groupBox2.TabIndex = 9; this.groupBox2.TabStop = false; this.groupBox2.Text = "Questions"; // // questionSetsDataGrid // this.questionSetsDataGrid.AllowUserToAddRows = false; this.questionSetsDataGrid.AllowUserToDeleteRows = false; this.questionSetsDataGrid.AllowUserToOrderColumns = true; this.questionSetsDataGrid.AutoGenerateColumns = false; this.questionSetsDataGrid.ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.None; this.questionSetsDataGrid.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.questionSetsDataGrid.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.idDataGridViewTextBoxColumn, this.typeIdDataGridViewTextBoxColumn, this.subtypeIdDataGridViewTextBoxColumn, this.difficultyLevelIdDataGridViewTextBoxColumn, this.dataGridViewTextBoxColumn1, this.pictureDataGridViewImageColumn, this.difficultyLevel, this.TypeId, this.SubtypeId, this.Idpas, this.setIdDataGridViewTextBoxColumn, this.questionOrderDataGridViewTextBoxColumn, this.questionZoneDataGridViewTextBoxColumn, this.questionIdDataGridViewTextBoxColumn }); this.questionSetsDataGrid.DataMember = "QuestionsEx"; this.questionSetsDataGrid.DataSource = this.data; this.questionSetsDataGrid.Location = new System.Drawing.Point(5, 46); this.questionSetsDataGrid.MultiSelect = false; this.questionSetsDataGrid.Name = "questionSetsDataGrid"; this.questionSetsDataGrid.ReadOnly = true; this.questionSetsDataGrid.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect; this.questionSetsDataGrid.Size = new System.Drawing.Size(759, 329); this.questionSetsDataGrid.TabIndex = 11; this.questionSetsDataGrid.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.questionSetsDataGrid_CellDoubleClick); this.questionSetsDataGrid.DataError += new System.Windows.Forms.DataGridViewDataErrorEventHandler(this.questionSetsDataGrid_DataError); // // idDataGridViewTextBoxColumn // this.idDataGridViewTextBoxColumn.DataPropertyName = "Id"; this.idDataGridViewTextBoxColumn.HeaderText = "Id"; this.idDataGridViewTextBoxColumn.Name = "idDataGridViewTextBoxColumn"; this.idDataGridViewTextBoxColumn.ReadOnly = true; this.idDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; this.idDataGridViewTextBoxColumn.Visible = false; // // typeIdDataGridViewTextBoxColumn // this.typeIdDataGridViewTextBoxColumn.DataPropertyName = "TypeId"; this.typeIdDataGridViewTextBoxColumn.HeaderText = "TypeId"; this.typeIdDataGridViewTextBoxColumn.Name = "typeIdDataGridViewTextBoxColumn"; this.typeIdDataGridViewTextBoxColumn.ReadOnly = true; this.typeIdDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; this.typeIdDataGridViewTextBoxColumn.Visible = false; // // subtypeIdDataGridViewTextBoxColumn // this.subtypeIdDataGridViewTextBoxColumn.DataPropertyName = "SubtypeId"; this.subtypeIdDataGridViewTextBoxColumn.HeaderText = "SubtypeId"; this.subtypeIdDataGridViewTextBoxColumn.Name = "subtypeIdDataGridViewTextBoxColumn"; this.subtypeIdDataGridViewTextBoxColumn.ReadOnly = true; this.subtypeIdDataGridViewTextBoxColumn.Visible = false; // // difficultyLevelIdDataGridViewTextBoxColumn // this.difficultyLevelIdDataGridViewTextBoxColumn.DataPropertyName = "DifficultyLevelId"; this.difficultyLevelIdDataGridViewTextBoxColumn.HeaderText = "DifficultyLevelId"; this.difficultyLevelIdDataGridViewTextBoxColumn.Name = "difficultyLevelIdDataGridViewTextBoxColumn"; this.difficultyLevelIdDataGridViewTextBoxColumn.ReadOnly = true; this.difficultyLevelIdDataGridViewTextBoxColumn.Visible = false; // // dataGridViewTextBoxColumn1 // this.dataGridViewTextBoxColumn1.DataPropertyName = "Text"; this.dataGridViewTextBoxColumn1.HeaderText = "Text"; this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1"; this.dataGridViewTextBoxColumn1.ReadOnly = true; this.dataGridViewTextBoxColumn1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; // // pictureDataGridViewImageColumn // this.pictureDataGridViewImageColumn.DataPropertyName = "Picture"; this.pictureDataGridViewImageColumn.HeaderText = "Picture"; this.pictureDataGridViewImageColumn.ImageLayout = System.Windows.Forms.DataGridViewImageCellLayout.Zoom; this.pictureDataGridViewImageColumn.Name = "pictureDataGridViewImageColumn"; this.pictureDataGridViewImageColumn.ReadOnly = true; // // difficultyLevel // this.difficultyLevel.DataPropertyName = "DifficultyLevelId"; this.difficultyLevel.DataSource = this.data; this.difficultyLevel.DisplayMember = "DifficultyLevel.Name"; this.difficultyLevel.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing; this.difficultyLevel.HeaderText = "Difficulty level"; this.difficultyLevel.Name = "difficultyLevel"; this.difficultyLevel.ReadOnly = true; this.difficultyLevel.ValueMember = "DifficultyLevel.Id"; // // TypeId // this.TypeId.DataPropertyName = "TypeId"; this.TypeId.DataSource = this.data; this.TypeId.DisplayMember = "QuestionTypes.Name"; this.TypeId.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing; this.TypeId.HeaderText = "Type"; this.TypeId.Name = "TypeId"; this.TypeId.ReadOnly = true; this.TypeId.ValueMember = "QuestionTypes.Id"; // // SubtypeId // this.SubtypeId.DataPropertyName = "SubtypeId"; this.SubtypeId.DataSource = this.data; this.SubtypeId.DisplayMember = "QuestionSubtypes.Name"; this.SubtypeId.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing; this.SubtypeId.HeaderText = "Subtype"; this.SubtypeId.Name = "SubtypeId"; this.SubtypeId.ReadOnly = true; this.SubtypeId.ValueMember = "QuestionSubtypes.Id"; this.SubtypeId.Width = 250; // // Idpas // this.Idpas.AutoComplete = false; this.Idpas.DataPropertyName = "QuestionId"; this.Idpas.DataSource = this.data; this.Idpas.DisplayMember = "PassagesToQuestionsEx.Text"; this.Idpas.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing; this.Idpas.HeaderText = "Passage"; this.Idpas.Name = "Idpas"; this.Idpas.ReadOnly = true; this.Idpas.ValueMember = "PassagesToQuestionsEx.Id"; this.Idpas.Visible = false; this.Idpas.Width = 200; // // setIdDataGridViewTextBoxColumn // this.setIdDataGridViewTextBoxColumn.DataPropertyName = "SetId"; this.setIdDataGridViewTextBoxColumn.HeaderText = "SetId"; this.setIdDataGridViewTextBoxColumn.Name = "setIdDataGridViewTextBoxColumn"; this.setIdDataGridViewTextBoxColumn.ReadOnly = true; this.setIdDataGridViewTextBoxColumn.Visible = false; // // questionOrderDataGridViewTextBoxColumn // this.questionOrderDataGridViewTextBoxColumn.DataPropertyName = "QuestionOrder"; this.questionOrderDataGridViewTextBoxColumn.HeaderText = "QuestionOrder"; this.questionOrderDataGridViewTextBoxColumn.Name = "questionOrderDataGridViewTextBoxColumn"; this.questionOrderDataGridViewTextBoxColumn.ReadOnly = true; this.questionOrderDataGridViewTextBoxColumn.Visible = false; // // questionZoneDataGridViewTextBoxColumn // this.questionZoneDataGridViewTextBoxColumn.DataPropertyName = "QuestionZone"; this.questionZoneDataGridViewTextBoxColumn.HeaderText = "QuestionZone"; this.questionZoneDataGridViewTextBoxColumn.Name = "questionZoneDataGridViewTextBoxColumn"; this.questionZoneDataGridViewTextBoxColumn.ReadOnly = true; this.questionZoneDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; this.questionZoneDataGridViewTextBoxColumn.Visible = false; // // questionIdDataGridViewTextBoxColumn // this.questionIdDataGridViewTextBoxColumn.DataPropertyName = "QuestionId"; this.questionIdDataGridViewTextBoxColumn.HeaderText = "QuestionId"; this.questionIdDataGridViewTextBoxColumn.Name = "questionIdDataGridViewTextBoxColumn"; this.questionIdDataGridViewTextBoxColumn.ReadOnly = true; this.questionIdDataGridViewTextBoxColumn.Visible = false; // // buttonUp // this.buttonUp.FlatStyle = System.Windows.Forms.FlatStyle.Popup; this.buttonUp.ImageIndex = 0; this.buttonUp.ImageList = this.imageList; this.buttonUp.Location = new System.Drawing.Point(8, 16); this.buttonUp.Name = "buttonUp"; this.buttonUp.Size = new System.Drawing.Size(17, 24); this.buttonUp.TabIndex = 10; this.buttonUp.Click += new System.EventHandler(this.buttonUp_Click); // // imageList // this.imageList.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList.ImageStream"))); this.imageList.TransparentColor = System.Drawing.Color.Fuchsia; this.imageList.Images.SetKeyName(0, ""); this.imageList.Images.SetKeyName(1, ""); // // addExistingButton // this.addExistingButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.addExistingButton.FlatStyle = System.Windows.Forms.FlatStyle.System; this.addExistingButton.ImageIndex = 1; this.addExistingButton.Location = new System.Drawing.Point(488, 16); this.addExistingButton.Name = "addExistingButton"; this.addExistingButton.Size = new System.Drawing.Size(88, 24); this.addExistingButton.TabIndex = 7; this.addExistingButton.Text = "Add &Existing..."; this.addExistingButton.Click += new System.EventHandler(this.addExistingButton_Click); // // addNewButton // this.addNewButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.addNewButton.FlatStyle = System.Windows.Forms.FlatStyle.System; this.addNewButton.ImageIndex = 0; this.addNewButton.Location = new System.Drawing.Point(582, 16); this.addNewButton.Name = "addNewButton"; this.addNewButton.Size = new System.Drawing.Size(88, 24); this.addNewButton.TabIndex = 8; this.addNewButton.Text = "Add &New..."; this.addNewButton.Click += new System.EventHandler(this.addNewButton_Click); // // removeButton // this.removeButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.removeButton.FlatStyle = System.Windows.Forms.FlatStyle.System; this.removeButton.ImageIndex = 2; this.removeButton.Location = new System.Drawing.Point(676, 16); this.removeButton.Name = "removeButton"; this.removeButton.Size = new System.Drawing.Size(88, 24); this.removeButton.TabIndex = 9; this.removeButton.Text = "&Remove"; this.removeButton.Click += new System.EventHandler(this.removeButton_Click); // // buttonDown // this.buttonDown.FlatStyle = System.Windows.Forms.FlatStyle.Popup; this.buttonDown.ImageIndex = 1; this.buttonDown.ImageList = this.imageList; this.buttonDown.Location = new System.Drawing.Point(27, 16); this.buttonDown.Name = "buttonDown"; this.buttonDown.Size = new System.Drawing.Size(17, 24); this.buttonDown.TabIndex = 10; this.buttonDown.Click += new System.EventHandler(this.buttonDown_Click); // // groupBox1 // this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.groupBox1.Controls.Add(this.inZone3); this.groupBox1.Controls.Add(this.inZone2); this.groupBox1.Controls.Add(this.inZone1); this.groupBox1.Controls.Add(this.label8); this.groupBox1.Controls.Add(this.label6); this.groupBox1.Controls.Add(this.label4); this.groupBox1.Controls.Add(this.typeLable); this.groupBox1.Controls.Add(this.timeLable); this.groupBox1.Controls.Add(this.numberOfQuestionsLable); this.groupBox1.Controls.Add(this.label1); this.groupBox1.Controls.Add(this.label5); this.groupBox1.Controls.Add(this.label7); this.groupBox1.FlatStyle = System.Windows.Forms.FlatStyle.System; this.groupBox1.Location = new System.Drawing.Point(542, 5); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(237, 126); this.groupBox1.TabIndex = 11; this.groupBox1.TabStop = false; this.groupBox1.Text = "Information"; // // inZone3 // this.inZone3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.inZone3.FlatStyle = System.Windows.Forms.FlatStyle.System; this.inZone3.Location = new System.Drawing.Point(147, 93); this.inZone3.Name = "inZone3"; this.inZone3.Size = new System.Drawing.Size(80, 16); this.inZone3.TabIndex = 22; this.inZone3.Text = "999"; this.inZone3.TextAlign = System.Drawing.ContentAlignment.TopRight; // // inZone2 // this.inZone2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.inZone2.FlatStyle = System.Windows.Forms.FlatStyle.System; this.inZone2.Location = new System.Drawing.Point(147, 78); this.inZone2.Name = "inZone2"; this.inZone2.Size = new System.Drawing.Size(80, 16); this.inZone2.TabIndex = 21; this.inZone2.Text = "999"; this.inZone2.TextAlign = System.Drawing.ContentAlignment.TopRight; // // inZone1 // this.inZone1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.inZone1.FlatStyle = System.Windows.Forms.FlatStyle.System; this.inZone1.Location = new System.Drawing.Point(147, 63); this.inZone1.Name = "inZone1"; this.inZone1.Size = new System.Drawing.Size(80, 16); this.inZone1.TabIndex = 20; this.inZone1.Text = "999"; this.inZone1.TextAlign = System.Drawing.ContentAlignment.TopRight; // // label8 // this.label8.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.label8.FlatStyle = System.Windows.Forms.FlatStyle.System; this.label8.Location = new System.Drawing.Point(11, 78); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(104, 16); this.label8.TabIndex = 19; this.label8.Text = "Questions in zone 2"; // // label6 // this.label6.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.label6.FlatStyle = System.Windows.Forms.FlatStyle.System; this.label6.Location = new System.Drawing.Point(11, 94); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(104, 15); this.label6.TabIndex = 18; this.label6.Text = "Questions in zone 3"; // // label4 // this.label4.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.label4.FlatStyle = System.Windows.Forms.FlatStyle.System; this.label4.Location = new System.Drawing.Point(11, 62); this.label4.Name = "label4"; this.label4.Size = new System.Drawing.Size(104, 16); this.label4.TabIndex = 17; this.label4.Text = "Questions in zone 1"; // // typeLable // this.typeLable.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.typeLable.FlatStyle = System.Windows.Forms.FlatStyle.System; this.typeLable.Location = new System.Drawing.Point(107, 16); this.typeLable.Name = "typeLable"; this.typeLable.Size = new System.Drawing.Size(120, 16); this.typeLable.TabIndex = 12; this.typeLable.Text = "Reading Comprehension"; this.typeLable.TextAlign = System.Drawing.ContentAlignment.TopRight; // // timeLable // this.timeLable.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.timeLable.FlatStyle = System.Windows.Forms.FlatStyle.System; this.timeLable.Location = new System.Drawing.Point(147, 32); this.timeLable.Name = "timeLable"; this.timeLable.Size = new System.Drawing.Size(80, 16); this.timeLable.TabIndex = 16; this.timeLable.Text = "Unlimited"; this.timeLable.TextAlign = System.Drawing.ContentAlignment.TopRight; // // numberOfQuestionsLable // this.numberOfQuestionsLable.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.numberOfQuestionsLable.FlatStyle = System.Windows.Forms.FlatStyle.System; this.numberOfQuestionsLable.Location = new System.Drawing.Point(147, 47); this.numberOfQuestionsLable.Name = "numberOfQuestionsLable"; this.numberOfQuestionsLable.Size = new System.Drawing.Size(80, 16); this.numberOfQuestionsLable.TabIndex = 15; this.numberOfQuestionsLable.Text = "999"; this.numberOfQuestionsLable.TextAlign = System.Drawing.ContentAlignment.TopRight; // // label1 // this.label1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.label1.FlatStyle = System.Windows.Forms.FlatStyle.System; this.label1.Location = new System.Drawing.Point(11, 15); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(32, 16); this.label1.TabIndex = 8; this.label1.Text = "Type:"; this.label1.Click += new System.EventHandler(this.label1_Click); // // label5 // this.label5.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.label5.FlatStyle = System.Windows.Forms.FlatStyle.System; this.label5.Location = new System.Drawing.Point(11, 30); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(80, 16); this.label5.TabIndex = 9; this.label5.Text = "Time Limit:"; // // label7 // this.label7.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); this.label7.FlatStyle = System.Windows.Forms.FlatStyle.System; this.label7.Location = new System.Drawing.Point(11, 46); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(104, 16); this.label7.TabIndex = 10; this.label7.Text = "# of Questions:"; // // groupBox3 // this.groupBox3.Controls.Add(this.descriptionTextBox); this.groupBox3.Controls.Add(this.nameTextBox); this.groupBox3.Controls.Add(this.label2); this.groupBox3.Controls.Add(this.label3); this.groupBox3.FlatStyle = System.Windows.Forms.FlatStyle.System; this.groupBox3.Location = new System.Drawing.Point(3, 3); this.groupBox3.Name = "groupBox3"; this.groupBox3.Size = new System.Drawing.Size(531, 239); this.groupBox3.TabIndex = 12; this.groupBox3.TabStop = false; // // descriptionTextBox // this.descriptionTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.data, "Tests.Description", true)); this.descriptionTextBox.Location = new System.Drawing.Point(5, 56); this.descriptionTextBox.Multiline = true; this.descriptionTextBox.Name = "descriptionTextBox"; this.descriptionTextBox.Size = new System.Drawing.Size(520, 177); this.descriptionTextBox.TabIndex = 5; // // nameTextBox // this.nameTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.data, "Tests.Name", true)); this.nameTextBox.Location = new System.Drawing.Point(42, 14); this.nameTextBox.Name = "nameTextBox"; this.nameTextBox.Size = new System.Drawing.Size(483, 20); this.nameTextBox.TabIndex = 2; // // label2 // this.label2.FlatStyle = System.Windows.Forms.FlatStyle.System; this.label2.Location = new System.Drawing.Point(6, 17); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(48, 17); this.label2.TabIndex = 4; this.label2.Text = "Name"; // // label3 // this.label3.FlatStyle = System.Windows.Forms.FlatStyle.System; this.label3.Location = new System.Drawing.Point(6, 37); this.label3.Name = "label3"; this.label3.Size = new System.Drawing.Size(64, 16); this.label3.TabIndex = 3; this.label3.Text = "Description"; // // QuestionSetEditor // this.Controls.Add(this.groupBox3); this.Controls.Add(this.groupBox1); this.Controls.Add(this.groupBox2); this.Name = "QuestionSetEditor"; this.Size = new System.Drawing.Size(782, 632); this.Enter += new System.EventHandler(this.QuestionSetEditor_Enter); this.Load += new System.EventHandler(this.QuestionSetEditor_Load); ((System.ComponentModel.ISupportInitialize)(this.data)).EndInit(); this.groupBox2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.questionSetsDataGrid)).EndInit(); this.groupBox1.ResumeLayout(false); this.groupBox3.ResumeLayout(false); this.groupBox3.PerformLayout(); this.ResumeLayout(false); }
private void ConstructeZDataGridView() { var dgv = this; // dgv.ManipulateRows = true; dgv.ShowRowNumber = true; // dgv.AutoGenerateColumns = false; dgv.EditMode = DataGridViewEditMode.EditOnEnter; var dicimalStyle3 = new DataGridViewCellStyle(); dicimalStyle3.Format = "0.###"; // 创建数据列并绑定到数据源 ---------------------------------------------- // ------------------------- var combo = new DataGridViewComboBoxColumn(); combo.DataSource = Enum.GetValues(typeof(Operator_Bool)); combo.DataPropertyName = "Fill"; combo.Width = 50; combo.Name = "填方"; combo.ToolTipText = @"边坡为填方还是挖方"; dgv.Columns.Add(combo); // 如果要设置对应单元格的值为某枚举项:combo.Item(combo.Index,行号).Value = Gender.Male; // ------------------------- var column = new DataGridViewTextBoxColumn(); column.DataPropertyName = "FirstSlopeRatio"; column.ReadOnly = true; column.Name = "首级坡比"; column.ToolTipText = @"第一级子边坡的坡比,如果子边坡数量为0,则恒不满足此条件"; column.Width = 100; dgv.Columns.Add(column); // ------------------------- column = new DataGridViewTextBoxColumn(); column.DataPropertyName = "SlopeHeight"; column.Name = "总坡高(m)"; column.ToolTipText = @"整个边坡的总坡高"; column.ReadOnly = true; column.Width = 100; dgv.Columns.Add(column); // ------------------------- column = new DataGridViewTextBoxColumn(); column.DataPropertyName = "SlopeLevel"; column.Name = "总坡级"; column.ToolTipText = @"整个边坡共有多少级子边坡"; column.ReadOnly = true; column.ValueType = typeof(int); column.Width = 100; dgv.Columns.Add(column); // ------------------------- var prots = Options_Collections.CommonFillProtections.ToList(); prots.AddRange(Options_Collections.CommonCutProtections); var protsBinding = new BindingList <string>(prots); combo = new DataGridViewComboBoxColumn(); // combo.drow = DataGridViewComboBoxDisplayStyle.DropDownButton; combo.DataSource = protsBinding; combo.DataPropertyName = "ProtectionMethod"; combo.Name = "防护"; combo.ToolTipText = @"当前面所有的条件都满足时,确定此边坡的具体防护形式"; combo.MinimumWidth = 100; combo.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv.Columns.Add(combo); // ------------------------- column = new DataGridViewTextBoxColumn(); column.DataPropertyName = "ProtectionMethod"; column.Name = "防护"; column.ToolTipText = @"当前面所有的条件都满足时,确定此边坡的具体防护形式"; column.MinimumWidth = 100; column.AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv.Columns.Add(column); // 事件绑定 ------------------------------------------------------------- dgv.CellClick += DgvOnCellClick; dgv.DataError += EZdgvOnDataError; // 响应表格中的数据类型不匹配等出错的情况 //dgv.CellContentClick += EZdgvOnCellContentClick; // 响应表格中的按钮按下事件 //dgv.CurrentCellDirtyStateChanged += EZdgvOnCurrentCellDirtyStateChanged; // 在表格中Checkbox的值发生改变时立即作出响应 Slopes.AddingNew += SlopesOnAddingNew; }
private void prepareBenchmarksTab() { benchmarksGrid.Rows.Clear(); benchmarksGrid.Columns.Clear(); List <Benchmark> benchmarks = SportsFestivalManagementController.getInstance.getAllBenchmarks(); DataGridViewComboBoxColumn disciplineColumn = new DataGridViewComboBoxColumn(); disciplineColumn.DataSource = SportsFestivalManagementController.getInstance.getAllDisciplines(); disciplineColumn.DisplayMember = "Name"; disciplineColumn.ValueMember = "DisciplineId"; disciplineColumn.Name = "Disziplin"; disciplineColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; DataGridViewTextBoxColumn ageFromColumn = new DataGridViewTextBoxColumn(); ageFromColumn.Name = "Alter: Von"; ageFromColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; DataGridViewTextBoxColumn ageUntilColumn = new DataGridViewTextBoxColumn(); ageUntilColumn.Name = "Alter: Bis"; ageUntilColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; DataGridViewTextBoxColumn genderColumn = new DataGridViewTextBoxColumn(); genderColumn.Name = "Geschlecht"; genderColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; DataGridViewTextBoxColumn rankColumn = new DataGridViewTextBoxColumn(); rankColumn.Name = "Rang"; rankColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; DataGridViewTextBoxColumn valueColumn = new DataGridViewTextBoxColumn(); valueColumn.Name = "Richtwert"; valueColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; DataGridViewTextBoxColumn measureColumn = new DataGridViewTextBoxColumn(); measureColumn.Name = "Einheit"; measureColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; benchmarksGrid.Columns.Add(disciplineColumn); benchmarksGrid.Columns.Add(ageFromColumn); benchmarksGrid.Columns.Add(ageUntilColumn); benchmarksGrid.Columns.Add(genderColumn); benchmarksGrid.Columns.Add(rankColumn); benchmarksGrid.Columns.Add(valueColumn); benchmarksGrid.Columns.Add(measureColumn); foreach (Benchmark benchmark in benchmarks) { object[] dataRow = new object[] { benchmark.Discipline.DisciplineId, benchmark.AgeFrom, benchmark.AgeUntil, benchmark.Gender == 'm' ? "männlich" : "weiblich", benchmark.Rank == "bronze" ? "Bronze" : benchmark.Rank == "silver" ? "Silber" : "Gold", benchmark.BenchmarkValue, benchmark.Discipline.Measure.Name }; benchmarksGrid.Rows.Add(dataRow); } }
private void InitView() { dgvMain.AutoGenerateColumns = false; DataGridViewTextBoxColumn ColumnRecordID = new DataGridViewTextBoxColumn(); ColumnRecordID.DataPropertyName = "RecordID"; ColumnRecordID.Name = "ColumnRecordID"; ColumnRecordID.HeaderText = "RecordID"; ColumnRecordID.Visible = false; ColumnRecordID.Width = 30; ColumnRecordID.FillWeight = 40F; ColumnRecordID.ReadOnly = true; ColumnRecordID.DisplayIndex = 0; dgvMain.Columns.Add(ColumnRecordID); DataGridViewTextBoxColumn ColumnOnCreditID = new DataGridViewTextBoxColumn(); ColumnOnCreditID.DataPropertyName = "OnCreditID"; ColumnOnCreditID.Name = "ColumnOnCreditID"; ColumnOnCreditID.HeaderText = "GoodsID"; ColumnOnCreditID.Visible = false; ColumnOnCreditID.Width = 30; ColumnOnCreditID.FillWeight = 40F; ColumnOnCreditID.ReadOnly = true; ColumnOnCreditID.DisplayIndex = 1; dgvMain.Columns.Add(ColumnOnCreditID); DataGridViewAutoFilter.DataGridViewAutoFilterTextBoxColumn ColumnClientName = new DataGridViewAutoFilter.DataGridViewAutoFilterTextBoxColumn(); ColumnClientName.DataPropertyName = "ClientName"; ColumnClientName.Name = "ColumnClientName"; ColumnClientName.HeaderText = "客户"; ColumnClientName.Width = 70; ColumnClientName.DisplayIndex = 2; dgvMain.Columns.Add(ColumnClientName); DataGridViewTextBoxColumn ColumnRecordTime = new DataGridViewTextBoxColumn(); ColumnRecordTime.DataPropertyName = "RecordTime"; ColumnRecordTime.Name = "ColumnRecordTime"; ColumnRecordTime.HeaderText = "时间"; ColumnRecordTime.Width = 120; ColumnRecordTime.DisplayIndex = 3; dgvMain.Columns.Add(ColumnRecordTime); DataGridViewComboBoxColumn ColumnOpType = new DataGridViewComboBoxColumn(); ColumnOpType.DataPropertyName = "OpType"; ColumnOpType.DisplayMember = "Name"; ColumnOpType.ValueMember = "Value"; ColumnOpType.DataSource = CGlobalInstance.Instance.dtOnCreditType; ColumnOpType.Name = "ColumnOpType"; ColumnOpType.HeaderText = "操作"; ColumnOpType.Width = 70; ColumnOpType.DisplayIndex = 4; dgvMain.Columns.Add(ColumnOpType); DataGridViewTextBoxColumn ColumnLastNumber = new DataGridViewTextBoxColumn(); ColumnLastNumber.DataPropertyName = "LastNumber"; ColumnLastNumber.Name = "ColumnLastNumber"; ColumnLastNumber.HeaderText = "上次余额"; ColumnLastNumber.Width = 120; ColumnLastNumber.DisplayIndex = 5; dgvMain.Columns.Add(ColumnLastNumber); DataGridViewTextBoxColumn ColumnNumber = new DataGridViewTextBoxColumn(); ColumnNumber.DataPropertyName = "Number"; ColumnNumber.Name = "ColumnNumber"; ColumnNumber.HeaderText = "发生金额"; ColumnNumber.Width = 70; ColumnNumber.DisplayIndex = 6; dgvMain.Columns.Add(ColumnNumber); DataGridViewAutoFilter.DataGridViewAutoFilterTextBoxColumn ColumnEmployee = new DataGridViewAutoFilter.DataGridViewAutoFilterTextBoxColumn(); ColumnEmployee.DataPropertyName = "Employee"; ColumnEmployee.Name = "ColumnEmployee"; ColumnEmployee.HeaderText = "员工"; ColumnEmployee.Width = 70; ColumnEmployee.DisplayIndex = 7; dgvMain.Columns.Add(ColumnEmployee); DataGridViewTextBoxColumn ColumnRemark = new DataGridViewTextBoxColumn(); ColumnRemark.DataPropertyName = "Remark"; ColumnRemark.Name = "ColumnRemark"; ColumnRemark.HeaderText = "备注"; ColumnRemark.Width = 70; ColumnRemark.DisplayIndex = 8; dgvMain.Columns.Add(ColumnRemark); }
/// <summary> /// 设置DataGridView的列 /// 该函数主要设置列的类型,尤其要注意变成下拉框的列 /// 列的可见性,只读性,HeadText都不要在这里设置,放在DataBindComplete事件中处理 /// </summary> void setDataGridViewColumn() { dataGridView1.Columns.Clear(); DataGridViewTextBoxColumn tbc; DataGridViewComboBoxColumn cbc; DataGridViewCheckBoxColumn ckbc; // 先把所有的列都加好,基本属性附上 foreach (DataColumn dc in dtInner.Columns) { // 要下拉框的特殊处理 if (dc.ColumnName == "判定") { cbc = new DataGridViewComboBoxColumn(); cbc.HeaderText = dc.ColumnName; cbc.Name = dc.ColumnName; cbc.ValueType = dc.DataType; cbc.DataPropertyName = dc.ColumnName; cbc.SortMode = DataGridViewColumnSortMode.NotSortable; cbc.Items.Add("Y"); cbc.Items.Add("N"); dataGridView1.Columns.Add(cbc); continue; } if (dc.ColumnName == "位置1") { cbc = new DataGridViewComboBoxColumn(); cbc.HeaderText = dc.ColumnName; cbc.Name = dc.ColumnName; cbc.ValueType = dc.DataType; cbc.DataPropertyName = dc.ColumnName; cbc.SortMode = DataGridViewColumnSortMode.NotSortable; cbc.Items.Add("东"); cbc.Items.Add("西"); dataGridView1.Columns.Add(cbc); continue; } if (dc.ColumnName == "位置2") { cbc = new DataGridViewComboBoxColumn(); cbc.HeaderText = dc.ColumnName; cbc.Name = dc.ColumnName; cbc.ValueType = dc.DataType; cbc.DataPropertyName = dc.ColumnName; cbc.SortMode = DataGridViewColumnSortMode.NotSortable; cbc.Items.Add("左"); cbc.Items.Add("右"); cbc.Items.Add("底"); dataGridView1.Columns.Add(cbc); continue; } // 根据数据类型自动生成列的关键信息 switch (dc.DataType.ToString()) { case "System.Int32": case "System.String": case "System.Double": case "System.DateTime": tbc = new DataGridViewTextBoxColumn(); tbc.HeaderText = dc.ColumnName; tbc.Name = dc.ColumnName; tbc.ValueType = dc.DataType; tbc.DataPropertyName = dc.ColumnName; tbc.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridView1.Columns.Add(tbc); break; case "System.Boolean": ckbc = new DataGridViewCheckBoxColumn(); ckbc.HeaderText = dc.ColumnName; ckbc.Name = dc.ColumnName; ckbc.ValueType = dc.DataType; ckbc.DataPropertyName = dc.ColumnName; ckbc.SortMode = DataGridViewColumnSortMode.NotSortable; dataGridView1.Columns.Add(ckbc); break; } } }
public StockEditor(DataTable table, QuoteCom quotecom, TaiFexCom tfcom, string brokerid, string account, string StockHistoryFile) { InitializeComponent(); this.StockTable = table; this.quotecom = quotecom; this.tfcom = tfcom; this.brokerid = brokerid; this.account = account; this.StockHistoryFile = StockHistoryFile; //建立下拉選單表格 BuyModeTable.Columns.Add("BuyMode", typeof(string)); BuyModeTable.Columns.Add("BuyMode_Text", typeof(string)); BuyModeTable.Rows.Add("Auto", "自動"); BuyModeTable.Rows.Add("Notify", "手動"); BindingSource bindingBuyMode = new BindingSource(); bindingBuyMode.DataSource = BuyModeTable; StatusTable.Columns.Add("Status", typeof(string)); StatusTable.Columns.Add("Status_Text", typeof(string)); StatusTable.Rows.Add("StandBy", "待命中"); StatusTable.Rows.Add("WaitingBuySignal", "等待買入訊號"); StatusTable.Rows.Add("WaitingBuy", "等待買入"); StatusTable.Rows.Add("ConfirmBuyOrder", "確認委托買單"); StatusTable.Rows.Add("ConfirmBuyMatch", "確認買單成交"); StatusTable.Rows.Add("WaitingSellSignal", "等待賣出訊號"); StatusTable.Rows.Add("WaitingSell", "等待賣出"); StatusTable.Rows.Add("ConfirmSellOrder", "確認委托賣單"); StatusTable.Rows.Add("ConfirmSellMatch", "確認賣單成交"); StatusTable.Rows.Add("Stop", "中止流程"); StatusTable.Rows.Add("Error", "錯誤"); BindingSource bindingStatus = new BindingSource(); bindingStatus.DataSource = StatusTable; StopLossModeTable.Columns.Add("StopLossMode", typeof(string)); StopLossModeTable.Columns.Add("StopLossMode_Text", typeof(string)); StopLossModeTable.Rows.Add("Auto", "自動"); StopLossModeTable.Rows.Add("Manual", "手動"); BindingSource bindingStopLossMode = new BindingSource(); bindingStopLossMode.DataSource = StopLossModeTable; LockGainModeTable.Columns.Add("LockGainMode", typeof(string)); LockGainModeTable.Columns.Add("LockGainMode_Text", typeof(string)); LockGainModeTable.Rows.Add("Auto", "自動"); LockGainModeTable.Rows.Add("Manual", "手動"); BindingSource bindingLockGainMode = new BindingSource(); bindingLockGainMode.DataSource = LockGainModeTable; //增加欄位名稱 dgv_StockEditor.Columns.Add("StockID", "代號"); dgv_StockEditor.Columns["StockID"].DataPropertyName = "StockID"; dgv_StockEditor.Columns["StockID"].ReadOnly = true; DataGridViewComboBoxColumn StatusCol = new DataGridViewComboBoxColumn(); StatusCol.ValueMember = "Status"; StatusCol.DisplayMember = "Status_Text"; StatusCol.DataSource = bindingStatus; StatusCol.Name = "Status"; StatusCol.DataPropertyName = "Status"; StatusCol.HeaderText = "狀態"; StatusCol.ReadOnly = true; StatusCol.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; StatusCol.SortMode = DataGridViewColumnSortMode.Automatic; dgv_StockEditor.Columns.Add(StatusCol); dgv_StockEditor.Columns.Add("AmountThreshold", "成交量門檻"); dgv_StockEditor.Columns["AmountThreshold"].DataPropertyName = "AmountThreshold"; dgv_StockEditor.Columns["AmountThreshold"].ToolTipText = "前五分鐘成交量門檻"; //dgv_StockEditor.Columns["AmountThreshold"].ReadOnly = true; DataGridViewComboBoxColumn BuyModeCol = new DataGridViewComboBoxColumn(); BuyModeCol.ValueMember = "BuyMode"; BuyModeCol.DisplayMember = "BuyMode_Text"; BuyModeCol.DataSource = bindingBuyMode; BuyModeCol.Name = "BuyMode"; BuyModeCol.DataPropertyName = "BuyMode"; BuyModeCol.HeaderText = "買入模式"; //BuyModeCol.ReadOnly = true; BuyModeCol.DisplayStyle = DataGridViewComboBoxDisplayStyle.DropDownButton; BuyModeCol.SortMode = DataGridViewColumnSortMode.Automatic; dgv_StockEditor.Columns.Add(BuyModeCol); DataGridViewComboBoxColumn StopLossModeCol = new DataGridViewComboBoxColumn(); StopLossModeCol.ValueMember = "StopLossMode"; StopLossModeCol.DisplayMember = "StopLossMode_Text"; StopLossModeCol.DataSource = bindingStopLossMode; StopLossModeCol.Name = "StopLossMode"; StopLossModeCol.DataPropertyName = "StopLossMode"; StopLossModeCol.HeaderText = "停損模式"; //StopLossModeCol.ReadOnly = true; StopLossModeCol.DisplayStyle = DataGridViewComboBoxDisplayStyle.DropDownButton; StopLossModeCol.SortMode = DataGridViewColumnSortMode.Automatic; dgv_StockEditor.Columns.Add(StopLossModeCol); DataGridViewComboBoxColumn LockGainModeCol = new DataGridViewComboBoxColumn(); LockGainModeCol.ValueMember = "LockGainMode"; LockGainModeCol.DisplayMember = "LockGainMode_Text"; LockGainModeCol.DataSource = bindingLockGainMode; LockGainModeCol.Name = "LockGainMode"; LockGainModeCol.DataPropertyName = "LockGainMode"; LockGainModeCol.HeaderText = "停利模式"; //LockGainModeCol.ReadOnly = true; LockGainModeCol.DisplayStyle = DataGridViewComboBoxDisplayStyle.DropDownButton; LockGainModeCol.SortMode = DataGridViewColumnSortMode.Automatic; dgv_StockEditor.Columns.Add(LockGainModeCol); //DataGridViewComboBoxColumn BuyQtyCol = new DataGridViewComboBoxColumn(); //BuyQtyCol.Items.AddRange(1, 2, 3, 4, 5, 6, 7, 8, 9, 10); //BuyQtyCol.Name = "BuyQty"; //BuyQtyCol.DataPropertyName = "BuyQty"; //BuyQtyCol.HeaderText = "設定買量"; //dgv_StockList.Columns.Add(BuyQtyCol); dgv_StockEditor.Columns.Add("BuyQty", "設定買量"); dgv_StockEditor.Columns["BuyQty"].DataPropertyName = "BuyQty"; //dgv_StockEditor.Columns["BuyQty"].ReadOnly = true; BindingSource bs = new BindingSource(); bs.DataSource = StockTable; dgv_StockEditor.DataSource = bs; ////隱藏不顯示欄位 dgv_StockEditor.Columns["TradeBot"].Visible = false; dgv_StockEditor.Columns["BuyAvgPrice"].Visible = false; dgv_StockEditor.Columns["MatchBuyQty"].Visible = false; dgv_StockEditor.Columns["SellAvgPrice"].Visible = false; dgv_StockEditor.Columns["MatchSellQty"].Visible = false; dgv_StockEditor.Columns["ROI"].Visible = false; dgv_StockEditor.Columns["ClosePrice"].Visible = false; dgv_StockEditor.Columns["OpenPrice"].Visible = false; dgv_StockEditor.Columns["MatchTime"].Visible = false; dgv_StockEditor.Columns["MatchPrice"].Visible = false; dgv_StockEditor.Columns["MatchQty"].Visible = false; dgv_StockEditor.Columns["TotalQty"].Visible = false; dgv_StockEditor.Columns["AH"].Visible = false; dgv_StockEditor.Columns["NH"].Visible = false; dgv_StockEditor.Columns["NL"].Visible = false; dgv_StockEditor.Columns["AL"].Visible = false; //設定下拉選單預設值 cb_BuyMode.SelectedIndex = 0; cb_StopLossMode.SelectedIndex = 0; cb_LockGainMode.SelectedIndex = 0; }
public void Form1_Load(object sender, EventArgs e) { DataGridViewCheckBoxColumn column0 = new DataGridViewCheckBoxColumn(); DataGridViewDisableButtonColumn column1 = new DataGridViewDisableButtonColumn(); DataGridViewComboBoxColumn column2 = new DataGridViewComboBoxColumn(); column2.Items.Add("test1"); column2.Items.Add("test2"); column0.Name = "CheckBoxes"; column1.Name = "Buttons"; column2.Name = "Combobox"; dataGridView1.Columns.Add(column0); dataGridView1.Columns.Add(column1); dataGridView1.Columns.Add(column2); dataGridView1.RowCount = /*8*/ 1; dataGridView1.AutoSize = true; dataGridView1.AllowUserToAddRows = false; dataGridView1.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; // Set the text for each button. int row = dataGridView1.RowCount; for (int i = 0; i < dataGridView1.RowCount; i++) { dataGridView1.Rows[i].Cells["Buttons"].Value = "Button " + i.ToString(); dataGridView1.Rows[i].Cells["Combobox"].Value = "test2"; } this.panel1.Controls.Clear(); this.panel1.Controls.Add(dataGridView1); //dataGridView1.AutoGenerateColumns = true; //var source = new BindingSource(); ////使用List<>泛型集合填充DataGridView //List<Student> students = new List<Student>(); //Student hat = new Student(true, "12", "Male"); //Student peter = new Student(false, "14", "Male"); //Student dell = new Student(true, "16", "Male"); //Student anne = new Student(false, "19", "Female"); //students.Add(hat); //students.Add(peter); //students.Add(dell); //students.Add(anne); //source.DataSource = students; //this.dataGridView1.DataSource = source; //this.dataGridView1.Refresh(); //dataGridView1.CellValueChanged += // new DataGridViewCellEventHandler(dataGridView1_CellValueChanged); //dataGridView1.CurrentCellDirtyStateChanged += // new EventHandler(dataGridView1_CurrentCellDirtyStateChanged); //dataGridView1.CellClick += // new DataGridViewCellEventHandler(dataGridView1_CellClick); //this.Controls.Add(dataGridView1); }
///<summary> /// Constructor for <see cref="DataGridViewComboBoxColumnVWG"/> ///</summary> ///<param name="dataGridViewComboBoxColumn"></param> public DataGridViewComboBoxColumnVWG(DataGridViewComboBoxColumn dataGridViewComboBoxColumn) : base(dataGridViewComboBoxColumn) { _dataGridViewComboBoxColumn = dataGridViewComboBoxColumn; }
private void btnChanges_Click(object sender, EventArgs e) { string cad; try { String Action = ""; if (cbAction.SelectedIndex >= 0) Action = cbAction.Text.Substring(0, 2); switch (Action) { case " 0": // MOD "Keyboard" cad = ChangeCase(Products[0].Name); if (cad.EndsWith("*")) cad = cad.Substring(0, cad.Length - 1); else cad = cad + "*"; // NOTE!!: A modification that only changes the case of the letters will be ignored by comboBox controls. Is its normal behaviour. // Thats why "*" is added or removed. Products[0].Name = cad; break; case " 1": // MOD "Jane Wilson" & "Bill Smith" cad = ChangeCase(Customers[0].Name); Customers[0].Name = cad; cad = ChangeCase(Customers[1].Name); Customers[1].Name = cad; break; case " 2": // MOD "Keyboard" & "Mose" cad = ChangeCase(Products[0].Name); Products[0].Name = cad; cad = ChangeCase(Products[1].Name); Products[1].Name = cad; break; case " 3": // INC OrderDate: Order-1 & Order-2 Orders[0].OrderDate = Orders[0].OrderDate.AddDays(1); Orders[1].OrderDate = Orders[1].OrderDate.AddDays(1); break; case " 4": // Order-1.OrderLines[1].Product <- Order-1.OrderLines[0].Product Orders[0].OrderLines[1].Product = Orders[0].OrderLines[0].Product; break; case " 5": // INC OrderLines[0].Quantity: Order-1 & Order-2 Orders[0].OrderLines[0].Quantity += 1; Orders[1].OrderLines[0].Quantity += 1; break; case " 6": // INC Customer.Age <Jane Wilson> & <Bill Smith> Customers[0].Age += 1; Customers[1].Age += 1; break; case " 7": // INC Product.UnitPrice: <Keyboard> & <Mouse> Products[0].UnitPrice += 10; Products[1].UnitPrice += 10; break; case " 8": // MOD <Keyboard>.ChangeMultiple (Property=Nothing) Products[0].ChangeMultiple(); break; case " 9": // Remove <Samantha Brown> Customers.RemoveAt(2); break; case "10": // Remove <LapTop> Products.RemoveAt(4); break; case "11": // Delete All Orders.Clear(); Customers.Clear(); Products.Clear(); OtherItems.Clear(); SimpleClasses.Clear(); // As Orders and OtherItems don't implement IBindingList but only IList, deleting these lists will raise // an error on the DataGridView binded to the objects BindingSource on trying to refresh their cells, because // BindingSource objects are not aware of the other objects deletion and so they don't inform to the consumers // (DataGridView in this case) // Also, if we make DataSource = null in the BindingSource controls will cause the same error because they will trigger // the method MyBase.ResetBindings(True) and that will raise ListChanged, forcing the DataGridView to refresh their // content // ==> We must execute .ResetBindings(false) just after the .Clear() previous productsBindingSource.DataSource = typeof(Product); customersBindingSource.DataSource = typeof(Customer); ordersBindingSource.ResetBindings(false); otherItemsBindingSource.ResetBindings(false); dataGridView1.AutoGenerateColumns = false; orderlinesBindingSource.DataSource = null; ordersBindingSource.DataSource = null; otherItemsBindingSource.DataSource = null; simpleClassesBindingSource.DataSource = null; break; case "12": // BindingSourceS.Dispose orderlinesBindingSource.Dispose(); ordersBindingSource.Dispose(); productsBindingSource.Dispose(); customersBindingSource.Dispose(); otherItemsBindingSource.Dispose(); simpleClassesBindingSource.Dispose(); break; case "13": // Add New Order (4: <Jane Wilson>) Order o = new Order(4, DateTime.Now, Customers[0]); o.OrderLines.Add(new OrderLine(Products[1], 4)); o.OrderLines.Add(new OrderLine(Products[4], 5)); Orders.Add(o); _Objects.Add(new WeakReference(o)); ordersBindingSource.ResetBindings(false); // Pues el origen no es IBindingList break; case "14": // Remove New Order (4: <Jane Wilson>) Orders.RemoveAt(3); ordersBindingSource.ResetBindings(false); // Pues el origen no es IBindingList break; case "24": // INSERT New Order (4: <Jane Wilson>) at position 1 o = new Order(4, DateTime.Now, Customers[0]); o.OrderLines.Add(new OrderLine(Products[1], 4)); o.OrderLines.Add(new OrderLine(Products[4], 5)); Orders.Insert(1, o); _Objects.Add(new WeakReference(o)); ordersBindingSource.ResetBindings(false); // Pues el origen no es IBindingList break; case "15": // MOD ordersBindingSource.BindableNestedProperties: A ordersBindingSource.BindableNestedProperties = new string[] { "Customer.Name", "Customer.BillingAddress.StreetAddress", "Customer.BillingAddress.City", "DeliveryAddress.StreetAddress", "DeliveryAddress.City", "Customer.FavoriteProduct.Name"}; //DataGridViewColumn c = new DataGridViewTextBoxColumn(); //c.DataPropertyName = "Customer_FavoriteProduct_Name"; //c.HeaderText = "Customer.FavoriteProduct.Name"; //c.Name = "customerFavoriteProductNameDataGridViewTextBoxColumn"; //dataGridView1.Columns.Add(c); break; case "16": // MOD ordersBindingSource.BindableNestedProperties: B ordersBindingSource.BindableNestedProperties = new string[] { "Customer.Name", "Customer.BillingAddress.StreetAddress", "Customer.BillingAddress.City", "DeliveryAddress.StreetAddress", "DeliveryAddress.City"}; //c = dataGridView1.Columns[dataGridView1.Columns.Count-1]; //if (c.DataPropertyName == "Customer_FavoriteProduct_Name") // dataGridView1.Columns.RemoveAt(dataGridView1.Columns.Count - 1); break; case "23": // MOD ordersBindingSource.BindableNestedProperties: C ordersBindingSource.BindableNestedProperties = new string[] { "Customer.Name", "Customer.BillingAddress.StreetAddress", "Customer.BillingAddress.City", "DeliveryAddress.StreetAddress", "DeliveryAddress.City", "Customer.FavoriteProduct.NonExistentProperty"}; break; case "17": // MOD orderlinesBindingSource.BindableNestedProperties: A orderlinesBindingSource.BindableNestedProperties = new string[] { "Product.ProductId", "Product.UnitPrice", "Product.Name", "Product.Type"}; // I have set: dataGridView2.AutoGenerateColumns = false; DataGridViewComboBoxColumn productType = new DataGridViewComboBoxColumn(); productType.DataSource = new EnumeratedValueCollection<ProductType>(); productType.ValueMember = "Value"; productType.DisplayMember = "Description"; productType.DataPropertyName = "Product_Type"; productType.HeaderText = "Product.Type"; dataGridView2.Columns.Add(productType); break; case "20": // MOD Orders[0].OrderLines[0].Details[0].NotShownProperty Orders[0].OrderLines[0].Details[0].NotShownProperty += 10; break; case "21": // Orders[0].OrderLines = Orders[0].OrderLines; Orders[0].OrderLines = Orders[0].OrderLines; break; case "22": // Orders[0].OrderLines = Orders[1].OrderLines; Orders[0].OrderLines = Orders[1].OrderLines; break; case "25": // MOD orderlinesBindingSource.BindableNestedProperties: B orderlinesBindingSource.BindableNestedProperties = new string[] { "Product.ProductId", "Product.UnitPrice", "Product.Name"}; break; case "26": // MOD orderlinesBindingSource.BindableNestedProperties: C orderlinesBindingSource.BindableNestedProperties = null; break; default: break; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }