C#

Dimitri Backaert wrote:

Normally, we would use a read account on the database for this, but (since the database is being managed by the Netherlands and I am a Belgian employee) the Netherlands are refusing to give us a read account.

Henry Minute wrote:

Doncha just luuuv office politics?

Dimitri Backaert wrote:

This doesn't work however, I seem to be stuck at the logon page. I'm not able to pass the user security.
Anyone has an idea?

private Bitmap start = new Bitmap("LocationForImage");
private Bitmap stop = new Bitmap("LocationForImage");
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
    // Try to load it as a DataGridViewImageCell
    DataGridViewImageCell img = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex] as DataGridViewImageCell
    // If that works, we have the right cell
    if (img != null)
    {
        if ((bool)img.Tag)
        {
            // if it is true then we are started, so stop
            img.Value = stop;
            img.Tag = false;
            // HERE DO ANYTHING ELSE REQUIRED FOR STOPPING e.g. this.timer1.Stop;
        }
        else
        {
            // if it is false then we are stopped, so start
            img.Value = start;
            img.Tag = true;
            // HERE DO ANYTHING ELSE REQUIRED FOR STARTING e.g. this.timer1.Start;
        }
    }
}

public partial class ImageColumnTestForm : Form
{
    private Bitmap start = ImageCellTest.Properties.Resources.START; // I am getting the images from the apps resources
    private Bitmap stop = ImageCellTest.Properties.Resources.STOP;   // 'ImageCellTest' is the Namespace that I used.

    public ImageColumnTestForm()
    {
        InitializeComponent();
    }

    private void ImageColumnTestForm_Load(object sender, EventArgs e)
    {
        DataGridViewRow newRow = null;
        DataGridViewTextBoxCell textCell = null;
        DataGridViewImageCell imgCell = null;

        for (int i = 0; i < 5; i++)
        {
            newRow = new DataGridViewRow();
            textCell = new DataGridViewTextBoxCell();
            newRow.Cells.Add(textCell);
            imgCell = new DataGridViewImageCell();
            newRow.Cells.Add(imgCell);
            textCell.Value = "Text " + i.ToString();
            imgCell.Value = start;
            imgCell.Tag = true;
            this.dataGridView1.Rows.Add(newRow);
        }
    }

    private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
    {
        // Try to load it as a DataGridViewImageCell
        DataGridViewImageCell img = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex] as DataGridViewImageCell;
        // If that works, we have the right cell
        if (img != null)
        {
            if ((bool)img.Tag)
            {
                // if it is true then we are started, so stop
                img.Value = stop;
                img.Tag = false;
                // HERE DO ANYTHING ELSE REQUIRED FOR STOPPING e.g. this.timer1.Stop;
            }
            else
            {
                // if it is false then we are stopped, so start
                img.Value = start;
                img.Tag = true;
                // HERE DO ANYTHING ELSE REQUIRED FOR STARTING e.g. this.timer1.Start;
            }
        }
    }
}

RobertFall wrote:

Just some advice on direction or where to find further information would be GREATLY appreciated!

DataTable tbl = myDataSet[0];
for (int i = 0; i < tbl.Rows.Count - 1; i++)
{
  if (tbl.Rows[i]["myColumn"] == tbl.Rows[i+1]["myColumn"])
  {
    // It's a match
  }
}