So maybe its helpful to know when building this code.As I'm begginer I wanted to ask you guys why Message Box doesnt apper when I check check Box? In the code shown, you have only added the column and it would be in unchecked state, so looping it won't find any records which has the Checked state true, you will have to check this in a specific event like (hoping winform) like This code will never hit the message box code - you've created the control, added it to the table, then immediately checked them for their values, which will be not set.

You are currently viewing the C# 2005 section of the Wrox Programmer to Programmer discussions. You may be able to cast that cell to a checkbox cell (I don't know the exact syntax) and that class should have a "checked" or similar property. I searched online and there is a solution like this: If check Box Cell Is Not Nothing Then If check Box Cell. Equals(Get Type(Boolean)) Then Dim checked As Boolean = CType(check Box Cell. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hey exports I dragged a Data Grid View on form and it was already successfully connected to database. Add(a Column ); How can I get the value of this newly added column? -Peter There is an object like "Data Grid View Check Box Cell". Data Grid View Check Box Cell acell = (Data Grid View Check Box Cell)data Grid View1. Value, Boolean) Else ' check Box Cell may have 3 states instead. From inside the Form Designer, you should see a very small triangle at the upper right-hand corner of the Data Grid View control. For example, if the Units On Hand column can never be a negative number,you could write a validating rule that looks to see if the value is negative prior to committing the changes to that row.Click on this triangle to select the data source that was created for you when you ran the Data Source Conversion Wizard. You can use the Error Provider class to display the problems detected during validation.You need to have an event handler that catches changed values in the datagridview: You will also most likely need to assign this handler to the Data Grid View - you can do this through the properties of it in design view for ease.

The Data Grid View is a very powerful windows form control for providing a user interface to tabular data.

Afterwards, you should have a fully-functional program that will allow you to view the data in the Data Table. When an input error occurs, there will be a little red exclamation point at that cell location.

However, you'll need to add a button and one line of code to be able to save changes back to the database. Load 'TODO: This line of code loads data into the 'North Wind Data Set. If the user hovers over the red "eye ball" (it kinda looks like a lower-case "i") they will see the reason why the input was rejected. Cancel" method with some caution, as it will "lock down" the Data Grid View control, and not let the user move to any other row (or switch to any other control) until after the error is fixed.

Canceling this event cancels the changes to the current cell.

When this event is canceled in data-bound mode, the new value is not pushed to the underlying data source.

Then I added a column to Data Grid View like this: Data Grid View Check Box Column a Column= new Data Grid View Check Box Column(); a Column. I mean I thought there should be certain property like "checked" to examine if a row in Data Grid View is checked. How could it be called "Data Grid View Check Box Column" without even a property like "checked"? I wanna update the checked row into database without those unchecked ones...I need to judge the value of the cell containing Data Grid View Checked Box to see if it's checked... "Value" property can be helpful only when I use it like this: if(data Grid View1. End If Else ' Current cell is not a Data Grid View Check Box Cell.