How can I refresh c dataGridView after update

Question

I have a dataGridView when I click on any row a form is opened to update the row data  but after ending updates the updating form is closed but the dataGridView data is not updated   How can i do that

User · Answer

You can use SqlDataAdapter to update the DataGridView       using  SqlConnection conn   new SqlConnection connectionString                         using  SqlDataAdapter ad   new SqlDataAdapter  SELECT   FROM Table   conn                                DataTable dt   new DataTable                     ad Fill dt                  dataGridView1 DataSource   dt

User · Answer

BindingSource is the only way without going for a 3rd party ORM  it may seem long winded at first but the benefits of one update method on the BindingSource are so helpful   If your source is say for example a list of user strings  List lt string gt  users   GetUsers    BindingSource source   new BindingSource    source DataSource   users  dataGridView1 DataSource   source    then when your done editing just update your data object whether that be a DataTable or List of user strings like here and ResetBindings on the BindingSource   users   GetUsers      Update your data object source ResetBindings false

User · Answer

Rebind your DatagridView to the source   DataGridView dg1   new DataGridView    dg1 DataSource   src1      Update Data in src1  dg1 DataSource   null  dg1 DataSource   src1

User · Answer

I use the DataGridView s Invalidate   function   However  that will refresh the entire DataGridView   If you want to refresh a particular row  you use dgv InvalidateRow rowIndex   If you want to refresh a particular cell  you can use dgv InvalidateCell columnIndex  rowIndex    This is of course assuming you re using a binding source or data source

User · Answer

You just need to redefine the DataSource  So if you have for example DataGridView s DataSource that contains a  b  i c   DataGridView DataSource   a  b  c   And suddenly you update the DataSource so you have just a and b  you would need to redefine your DataSource   DataGridView DataSource   a  b   I hope you find this useful    Thank you

User · Answer

I know i am late to the party but hope this helps someone who will do the same with Class binding  var newEntry   new MyClassObject     var bindingSource   dataGridView DataSource as BindingSource  var myClassObjects   bindingSource DataSource as List lt MyClassObject gt   myClassObjects Add newEntry   bindingSource DataSource   myClassObjects   dataGridView DataSource   null  dataGridView DataSource   bindingSource  dataGridView Update    dataGridView Refresh

User · Answer

I know thats an old topic but i suddenly found the best way of doing it and it does not require nullifying the datasource and reassigning it  Just use a  BindingList instead of a List   for example     declare your list private BindingList lt myclass gt  mMyList   new BindingList lt myclass gt        then bind it to your datagrid  i usually do it on the Load event private void Form1 Load object sender  EventArgs e         dgMyDatagrig DataSource   mMyList       start populating your list  private void addItem mycclass item        mMylist add item      the datagrid will show automatically the new added updated items  no need to do anything else

User · Answer

I don t know if this has really been solved or not    but by looking at all the other answers  nothing seems quite clear  The best way I found to do this is to put the same code  that was used to populate your datagridview into a method and pass it your form s datagridview  as so    public void ConnectAndPopulateDataGridView DataGridView dataGridView        The code within the method is the exact same as the code used to populate the datagirdview originally  except for the datagridview name changing to whatever you called it in your method   Now this method is called in your parent form   The child form is launched via a  ShowDialog   then the method is called after so that it is called right after the child for is closed    as so   ChildForm ShowDialog     ConnectAndPopulateDataGridView dataGridView1

User · Answer

You can use the DataGridView refresh method  But    in a lot of cases you have to refresh the DataGridView from methods running on a different thread than the one where the DataGridView is running  In order to do that you should implement the following method and call it rather than directly typing DataGridView Refresh         private void RefreshGridView                 if  dataGridView1 InvokeRequired                        dataGridView1 Invoke  MethodInvoker delegate                                  RefreshGridView                                      else             dataGridView1 Refresh

[c#] How can I refresh c# dataGridView after update ?

Examples related to c#

Examples related to datagridview