473,325 Members | 2,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

VB.Net DataGridView Cell Editable

115 100+
I’m using VB.Net.

I’m using DataGridView with ColumnType = DataGridViewTextBoxColumn.

I have 3 columns. Column1, Column2, Column3.

For example:
Expand|Select|Wrap|Line Numbers
  1. Column1          Column2          Column3
  2. 1                        AA                AAA
  3. 2                        BB                EDIT
  4. 3                        CC                CCC
  5.  
If column3’s value = “EDIT”, then I need to edit only that cell.

Here for example: i need to make the Column3’s second cell to be readonly=false.

So i cannot make any changes to (1, AA, AAA), (3, CC, CCC) and (2, BB). Need to make changes only EDIT cell.

I tried this code. CountR is the row in which EDIT values is there.

Expand|Select|Wrap|Line Numbers
  1. DataGridView1.Item(2, CountR).ReadOnly = False 
  2.  
Expand|Select|Wrap|Line Numbers
  1. DataGridView1.Rows(CountR).Cells(2).ReadOnly = False
  2.  
But this makes every cell in column editable.

Is there a way i can make some cells editable in column?

If you know how to do it, please help me. if you can provide an example, then that will be so helpful.

Thanks in Advance.
Mar 9 '12 #1
1 11858
remya1000
115 100+
i think i'm executing that code multiple times with different row indexes.

So i try this code, and it's working...

Expand|Select|Wrap|Line Numbers
  1.                 For Each r As DataGridViewRow In DataGridView1.Rows
  2.                     If r.Cells(3).Value.ToString = "EDIT" Then
  3.                         r.Cells(3).ReadOnly = False
  4.                     Else
  5.                         r.Cells(3).ReadOnly = True
  6.                     End If
  7.                 Next
  8.  
Mar 11 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Steve | last post by:
I am looking for an example of a custom user control ( 2 labels and 2 datetime pickers ) in a datagridview cell. Every example I have come across handles only once control such as a datetimepicker...
11
by: dgk | last post by:
Is there a way to change the foreground or background color of a single cell in an unbound datagridview?
3
by: Rich | last post by:
Hello, If I want to update data displayed in a datagrideview/datagridview cell, how can I determine what cell I am updating? I am looking at the click event below, for example. Can I get...
10
by: steve | last post by:
Hi All I would like to be able to change the cell borders on certain cells to none at runtime to make a group of cells appear to be merged I have tried the following in the cellformatting...
1
by: Samuel Shulman | last post by:
Any method to make a cell editable programmatically The problem is that if the user entered a value which is not valid then instead of ignoring the value and explaining the user what was wrong ...
12
by: cj | last post by:
When viewing a datatable in a datagridview one of the columns in it is a "note" field which can be quite long. I would like to have the note field of the currently selected row of the datagrid...
0
by: varunk2 | last post by:
Hi How to autocomplete a datagridview cell in c# windows forms. Please anybody help me... Thanks in advance Regards,
0
by: hydro123 | last post by:
I am using VC++2008 and am trying to read data enetered in unbound datagridview to implement in function. Under button_click event I entered the following: // initialize varaibles from...
0
by: ziketo | last post by:
Hi, I searched a lot about changing the DataGridView cell borders. BYTES helped me so I will write down the solution: 1. You should override the class DataGridViewTextBoxCell, and the new class...
0
by: priyamtheone | last post by:
Problem in ToolStripButton (.Net 2008, Framework 3.5). Hi, I have an editable datagridview that's been databound with dataadapter and datatable, and a normal button on a form. When i edit the...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.