My password unmasking is working but not the way I want it to

Bob Gatto

I've masked a password column in a datagridview with this code:

private void dataGridView2_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
if(e.ColumnIndex == 2 && e.Value != null){if (MouseButtons == MouseButtons.Left &&
e.ColumnIndex==2 && e.RowIndex == dataGridView2.CurrentCell.RowIndex)
{
int idno = (int)dataGridView2.Rows[e.RowIndex].Cells["Id"].Value;
SqlConnection c = new SqlConnection(ConStr);
string query = "select * from Passwords where Id = " +
idno;DataTable Tbl = new DataTable();
using (SqlDataAdapter da = new SqlDataAdapter(query, c))
{
c.Open();
da.Fill(Tbl);
c.Close();
}
c.Dispose();
dataGridView2.Rows[e.RowIndex].Cells[2].Value = Tbl.Rows[0]["password"].ToString();
}
else
e.Value = new String('*', e.Value.ToString().Length);
}
}

I want to hold down the left mouse button and have only that cell that the cursor is over be unmasked and then have it masked again as soon as I release the mouse button. I only want this happening when the cursor is over the password column (which is columnindex 2).

The problem I'm having is the password column unmasks even if the mouse is not in the password column.

How can I fix this?

Thanks for your help,

Bob Gatto

2 Replies

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

Bob Gatto5y ago
I've tried with that event using this code:
private void dataGridView2_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
    {
      if(e.ColumnIndex == 2 && e.Value != null)
      {
        e.Value = new String('*', e.Value.ToString().Length);
      }
    }

    private void dataGridView2_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
    {
      if (e.Button == MouseButtons.Left && e.ColumnIndex == 2 && e.RowIndex != -1)
      {
        int idno = (int)dataGridView2.Rows[e.RowIndex].Cells["Id"].Value;
        SqlConnection c = new SqlConnection(ConStr);
        string query = "select * from Passwords where Id = " + idno;
        DataTable Tbl = new DataTable();
        using (SqlDataAdapter da = new SqlDataAdapter(query, c))
        {
          c.Open();
          da.Fill(Tbl);
          c.Close();
        }

        c.Dispose();

        dataGridView2.Rows[e.RowIndex].Cells[2].Value = Tbl.Rows[0]["password"].ToString();
      }
    }
And when I left-click and hold on a cell in the password column nothing happens.
0
Sachin Singh5y ago
Use DataGridView_CellMouseClick event if(dataGridView.CurrentCell.ColumnIndex==2) .... ....
0