How to programmatically set cell value in DataGridView

Question

I have a DataGridView  Some of the cells receive their data from a serial port  I want to shove the data into the cell  and have it update the underlying bound object   I m trying something like this   SetValueFromSerial  decimal newValue        dataGridView CurrentCell Value   newValue      using a string doesn t help       dataGridView CurrentCell Value   newValue ToString       In both cases  I don t see anything in the grid  and the underlying value is unchanged   I did Google and search here  but I didn t find anything   I may have missed something  perhaps something obvious  but I m not utterly lazy

User · Answer

Do you remember to refresh the dataGridView   datagridview refresh

User · Answer

If the DataGridView is databound  you shouldn t directly modify the content of the cell  Instead  you should modify the databound object  You can access that object through the DataBoundItem of the DataGridViewRow    MyObject obj    MyObject dataGridView CurrentRow DataBoundItem  obj MyProperty   newValue    Note that the bound object should implement INotifyPropertyChanged so that the change is reflected in the DataGridView

User · Answer

in VB you can use this one   Dim selectedRow As DataRowView selectedRow   dg Rows dg CurrentCell RowIndex  DataBoundItem selectedRow  MyProp      myValue  dg NotifyCurrentCellDirty True    thanks to saeed serpooshan for last row

User · Answer

If the DataGridView has been populated by DataSource   x  i e  is databound  then you need to change the bound data  not the DataGridView cells themselves    One way of getting to that data from a known row or column is thus    YourRow DataBoundItem as DataRowView  Row  YourColumn     NewValue

User · Answer

The following works  I may be mistaken but adding a String value doesn t seem compatible to a DataGridView cell  I hadn t experimented or tried any hacks though    DataGridViewName Rows 0  Cells 0  Value   1

User · Answer

Just like  Thomas said  the element you want to change must implement INotifyPropertyChanged  But  datasource is also important  It has to be BindingList  which you can create easily from List   Here is my example - data source is at first DataTable  which I transfer to List and then create BindingList  Then I create BindingSource and use BindingList as DataSource from BindingSource  At last  DataSource from DataGridView uses this BindingSource    sp Select PersonTableAdapter adapter   new sp Select PersonTableAdapter      DataTable tbl   new DataTable     tbl Merge adapter GetData       List lt Person gt  list   tbl AsEnumerable   Select x   gt  new Person         Id    Int32   x  Id          Ime    string   x  Name                Priimek    string   x  LastName              ToList      BindingList lt Person gt  bindingList   new BindingList lt Person gt  list     BindingSource bindingSource   new BindingSource     bindingSource DataSource   bindingList   dgvPerson DataSource   bindingSource    What is also very important  each class s member setter must call OnPropertyChanged    Without that  it won t work  So  my class looks like this   public class Person   INotifyPropertyChanged               private int  id          private string  name          private string  lastName           public int Id                       get   return  id                set                               if  value     id                                         id   value                      OnPropertyChanged                                                      public string Name                       get   return  name                set                               if  value     name                                         name   value                      OnPropertyChanged                                                      public string LastName                       get   return  lastName                set                               if  value     lastName                                         lastName  value                      OnPropertyChanged                                                      public event PropertyChangedEventHandler PropertyChanged            NotifyPropertyChangedInvocator          protected virtual void OnPropertyChanged  CallerMemberName  string propertyName   null                        PropertyChangedEventHandler handler   PropertyChanged              if  handler    null  handler this  new PropertyChangedEventArgs propertyName                       More on this topic  http   msdn microsoft com en-us library system componentmodel inotifypropertychanged v vs 110  aspx

User · Answer

private void btn Addtoreciept Click object sender  EventArgs e                    serial number        dataGridView inventory Rows serial number - 1  Cells 0  Value   serial number      dataGridView inventory Rows serial number - 1  Cells 1  Value  comboBox Reciept name Text      dataGridView inventory Rows serial number - 1  Cells 2  Value   numericUpDown recieptprice Value      dataGridView inventory Rows serial number - 1  Cells 3  Value   numericUpDown Recieptpieces Value      dataGridView inventory Rows serial number - 1  Cells 4  Value   numericUpDown recieptprice Value   numericUpDown Recieptpieces Value      numericUpDown RecieptTotal Value   serial number      on first time it goes well but pressing 2nd time it gives me error   Index was out of range  Must be non-negative and less than the size of the collection  Parameter name  index  but when i click on the cell another row appears and then it works for the next row  and carry on

User · Answer

If you don t want to modify the databound object from some reason  for example you want to show some view in your grid  but you don t want it as a part of the datasource object   you might want to do this   1 Add column manually       DataGridViewColumn c   new DataGridViewColumn        DataGridViewCell cell   new DataGridViewTextBoxCell         c CellTemplate   cell      c HeaderText    added       c Name    added       c Visible   true  dgv Columns Insert 0  c      2 In the DataBindingComplete event do something like this    foreach  DataGridViewRow row in dgv Rows   if  row Cells 7  Value ToString     1   row Cells 0  Value    number one        just a stupid example   but remember IT HAS to be in the DataBindingComplete  otherwise value will remain blank

User · Answer

dataGridView1 1 1  Value  tes

User · Answer

I came across the same problem and solved it as following for VB NET  It s the  NET Framework so you should be possible to adapt  Wanted to compare my solution and now I see that nobody seems to solve it my way   Make a field declaration   Private  currentDataView as DataView  So looping through all the rows and searching for a cell containing a value that I know is next to the cell I want to change works for me   Public Sub SetCellValue ByVal value As String      Dim dataView As DataView    currentDataView      For i As Integer   0 To dataView Count - 1         If dataView i  Row Item  projID   ToString Equals  139   Then             dataView i  Row Item  Comment     value             Exit For   Exit early to save performance         End If     Next End Sub   So that you can better understand it  I know that ColumnName  projID  is 139  I loop until I find it and then I can change the value of  ColumnNameofCell  in my case  Comment   I use this for comments added on runtime

User · Answer

I searched for the solution how I can insert a new row and How to set the individual values of the cells inside it like Excel  I solved with following code   dataGridView1 ReadOnly   false    Before modifying  it is required  dataGridView1 Rows Add      Inserting first row if yet there is no row  first row number is  0  dataGridView1 Rows 0  Cells 0  Value    Razib  this is 0 0      Setting the leftmost and topmost cell s value  Not the column header row   dataGridView1 1  0  Value    This is 0 1      Setting the Second cell of the first row    Note    Previously I have designed the columns in design mode  I have set the row header visibility to false from property of the datagridview  The last line is important to understand  When yoou directly giving index of datagridview  the first number is cell number  second one is row number  Remember it    Hope this might help you

User · Answer

Try this way   dataGridView CurrentCell Value   newValue   dataGridView EndEdit     dataGridView CurrentCell Value   newValue   dataGridView EndEdit      Need to write two times

User · Answer

I tried a lot of methods  and the only one which worked was UpdateCellValue   dataGridView Rows rowIndex  Cells columnIndex  Value    New Value   dataGridView UpdateCellValue columnIndex  rowIndex     I hope to have helped

User · Answer

I had the same problem with sql-dataadapter to update data and so on   the following is working for me fine  mydatgridview Rows x  Cells x  Value  test  mydatagridview enabled   false  mydatagridview enabled   true

[c#] How to programmatically set cell value in DataGridView?

Examples related to c#

Examples related to winforms

Examples related to datagridview