Handling DataGridView Cells Bound to Data

Question

0.00/5 (No votes)

See more:

I am loading a DataGridView in VB.Net via either XML (if the file exists) or a datasource (if it doesn't). If a cell value is "N/A", I want to apply a cellstyle to that cell and make it readonly. I also have certain events that are being fired during user edit where the cell may get the N/A value. I'm able to more directly control setting the style and readonly there, but would like to do it in a manner where there are no potential "loop holes", where "N/A" has the default style and is editable.

I've explored many different cell events in the datagridview, but they don't fire when assigning the datasource. I've also tried using DataGridViewEditingControlShowingEvent, where I DirectCast a textbox textchanged event, but that seems to only occur on user edits as well.

Can someone help me come up with a way to assign a cellstyle and readonly property conditionally based on cell value upon assigning a datasource and the value in the cell = "N/A"?

Posted 14-Sep-11 4:18am

Tom Bihn

Add a Solution

Comments

S.Sls76 18-Nov-11 0:45am

How can I Move cell from column 2 to column 5 direct on cellafteredit event?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NewPast · Answer 1 · 2011-09-24T19:31:00

Try some thing like:

VB.NET

Private Sub DataGridView1_CellBeginEdit(ByVal sender As Object, _
ByVal e As System.Windows.Forms.DataGridViewCellCancelEventArgs) _
Handles DataGridView1.CellBeginEdit
   If Not IsNumeric(DataGridView1.Item(e.ColumnIndex, e.RowIndex).Value) Then
      e.Cancel = True
   End If
End Sub