Disable cell if condition are met (Win app form - Datagridview)

Chris Anderson

5y854Visual Basic .NET

I want to disable a cell if a certain condition is met.

My pseudo code looks like:

If animal not is hungry then disable cell and set the name to Full

13 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shweta Lodha5y ago
Please paste you code here. I will see, where are you missing
+2
Chris Anderson5y ago
I managed to set the backcolor. But not the ReadOnly value. Getting close now :)
+2
Chris Anderson5y ago
This is what it looks like when it gets painted:
DataTable dt = new DataTable();
dt.Rows.Add(new object[] {
        animalId,
        animal.Name,
        animal.AnimalType,
        animal.IsHungry,
        emptyCol = "Full",

    });
And I tried to use the following one. Of course with no luck.
foreach (DataGridViewRow row in dataGridView1.Rows)
{
    foreach (DataGridViewCell cell in row.Cells)
    {
        if (cell.Value.ToString() == "Full")
        {
            cell.ReadOnly = true;
        }
    }
}
+2
Shweta Lodha5y ago
Of course, it is possible. Once your data is loaded into the table, you can iterate through all the cells of required column and compare the word Full and accordingly you can call disablign logic.
+2
Chris Anderson5y ago
I can see it flickering through for a millisecond. However when the table is repainted it disappears.
Is it possible to make cells that contains a certain word i.e. "Full" to be disabled and grayed out?
+2
Shweta Lodha5y ago
It is of type DataGridViewCell.
DataGridViewCell currentlySelectedCell = null;
+2
Chris Anderson5y ago
Hmm I'm slow. What datatype is currentlySelectedCell? I get The name 'currentlySelectedCell' does not exist in the current context"

Where should I specify the variable? I though it might be a good idea to place it globally just in the beginning of the user control likeso:
public partial class UserControlFeedAnimals : UserControl
{
    public partial class UserControlFeedAnimals : UserControl
    {
var currentlySelectedCell = ?
}
+2
Shweta Lodha5y ago
In that case, you can call my method enableCell in both the places. Here is the idea for button click. Similarly once your grid is loaded, iterate through all the rows and in the smae loop call this enableCell method based on your isHungry status. Hope you got an idea now.
private void DataGridView1_SelectionChanged(object sender, EventArgs e)
    {
          // take class level variable and then assign it here. I'm assuming that you will be clicking on single cell, if not, please change this part accordingly
         currentlySelectedCell= DataGridView1.SelectedCells[0];
    }

private void buttonCloseFeedWindow_Click(object sender, EventArgs e)
{
   // Retrieve last clicked cell and set the cell to enabled = false;
    enableCell(currentlySelectecdCell, false);
    CloseWindowButton();
}
+2
Chris Anderson5y ago
It's actually both when I think about it.

When an animal has been fed and the user clicks the close button I would like to disable the cell.
private void buttonCloseFeedWindow_Click(object sender, EventArgs e)
{
   // Retrieve last clicked cell and set the cell to enabled = false;
    CloseWindowButton();
}
2. When grid loads all cells that contains the string Full should be disabled.
if (!animal.IsHungry)
{
    dt.Rows.Add(new object[] {
            animalId,
            animal.Name,
            animal.AnimalType,
            animal.IsHungry,
            emptyCol = "Full",
        });

}
+2
Shweta Lodha5y ago
When do you want to check this hungry condition? Is it when grid loads or when user clicks on given cell?
+2
Shweta Lodha5y ago
My code will enable or disable the cell, nothing else. When to enable or disable the cell, that code is yet to be placed.
+2
Chris Anderson5y ago
Thanks for your suggestion. :) I didn't manage to get it to work however. Maybe the pseudo code below explain it better?

if (!isHungry)
Replace the string value of "Is hungry" in the current clicked cell with a new string value of "Is not hungry".
+1
Shweta Lodha5y ago
Hello Chris,
You can try this:
private void enableCell(DataGridViewCell cell, bool enabled) {
        cell.ReadOnly = !enabled;
        if (enabled)
        {
            //set it to default value
            cell.Style.BackColor = cell.OwningColumn.DefaultCellStyle.BackColor;
            cell.Style.ForeColor = cell.OwningColumn.DefaultCellStyle.ForeColor;
        }
        else
       {
            // disable the cell
            cell.Style.BackColor = Color.LightGray;
            cell.Style.ForeColor = Color.DarkGray;
        }
    }
+1