change datagridview cell type containing text vaue "true" text to checkbox

debugcn Published at Dev

kay-B

I have a datagridview that has cells with text values that have "True" for one column and the next column should have a Combobox with two values to choose from (in and out)... I want to change the cell type to be a check box and cell type to Combobox... if the cell text is "true" the checkbox must be checked and if it is false or there is nothing in it, it must be unchecked if text from the direction column is in the Combobox value must be set to IN and have an extra option of out in it ... this DATA comes from a loaded XML file, this is how I load the XML file to the datagridview

public void Load(DataGridView dgv)
{             
    dgv.Refresh();
    XmlReaderxmlFile = XmlReader.Create(@"path/DGVXML.xml",newXmlReaderSettings());
    DataSet dataSet = new DataSet();
    dataSet.ReadXml(xmlFile);
    dgv.DataSource = dataSet.Tables[0];
    xmlFile.Close();              
 }

enter image description here

the datagridview must display as follows

enter image description here

kay-B

this is what iv added to the load method and worked 100%

  dgv.Refresh();
                XmlReader xmlFile = XmlReader.Create(@"/DGVXML.xml", new XmlReaderSettings());
                DataSet dataSet = new DataSet();
                dataSet.ReadXml(xmlFile);

                DataGridView grid = new DataGridView();
                var nameColumn = new DataGridViewTextBoxColumn();
                nameColumn.Name = "Device Name";
                nameColumn.HeaderText = "Device Name";
                dgv.Columns.Add(nameColumn);


                var checkColumn = new DataGridViewCheckBoxColumn();
                checkColumn.Name = "Select";
                checkColumn.HeaderText = "Select";
                dgv.Columns.Add(checkColumn);

                string IN = "IN";
                string OUT = "OUT";
                var select = new DataGridViewComboBoxColumn();
                select.HeaderText = "Direction";
                select.Name = "Direction";
                select.Items.Add(IN);
                select.Items.Add(OUT);
                dgv.Columns.Add(select);

                foreach (DataRow row in dataSet.Tables[0].Rows)
                {
                    string DeviceName = row[0].ToString();

                     bool Enabled = false;
                    if (row[1].ToString() != "")
                        Enabled = Convert.ToBoolean( row[1].ToString());

                    string Direction = row[2].ToString();

                    DataGridViewRow dgRow = new DataGridViewRow();
                    dgv.Rows.Add(new object[] {DeviceName, Enabled, Direction});
                }

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-2

Comments

0 comments

From Dev

Related Related

Article

change datagridview cell type containing text vaue "true" text to checkbox

change datagridview cell type containing text vaue "true" text to checkbox

How to change text of the top left cell of a datagridview?

Change text of a cell on dataGridView_CellFormatting

Multiline text in DataGridView Cell

Change color of only part of text inside a DataGridView cell

Change textcolor of a row in a datagridview if a cell contains part of text c#

Datagridview checkbox cell change color of button and drawline

Change Text if checked - checkbox

Merge DataGridView Image cell with text cell

how to replace text with numerical vaue in excel

Blinking Text If checkbox is checked to true

change text box text if checkbox is checked

Why my Checkbox change to text

VBA Set Cell value to text containing ' not working

Identify cell containing given text in LibreOffice Calc

Hide row based on cell containing text

Deactivate checkbox if a condition in a text input is true in javascript

excel search range for specific text copy cell containing text

If text string exist select cell containing text string

excel search range for specific text copy cell containing text

Associate input type checkbox to input type text

ASP VB.NET GridView: Change Column cell text by column header name with AutogenerateColumn = True

Find address of a cell containing a formula, using text value in the cell

how to delete cell value if cell is containing special text

HOW TO: Change datagridview LinkColumn Text when clicked

Change colour of a cell based on the value in the cell and text in another cell

Change checkbox text color when checked

CheckBox text to change based on its IsChecked

Change Text input value on checkbox select

Change TextBox text and focus via CheckBox in XAML