blocks|key|813938|text|BindingSource是唯一不需要第三方ORM的方法，一开始可能看起来很冗长，但在BindingSource上使用一种更新方法的好处是非常有用的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|813939|例如，如果您来源是用户字符串列表|813940|List<string>+users+=+GetUsers();
BindingSource+source+=+new+BindingSource();
source.DataSource+=+users;
dataGridView1.DataSource+=+source;|code-block|syntax|javascript|813941|然后，当您完成编辑时，只需更新您的数据对象，无论是DataTable还是像BindingSource上的here和ResetBindings这样的用户字符串列表；|813942|users+=+GetUsers();+//Update+your+data+object
source.ResetBindings(false);|813943|entityMap^0|0|D|17|D|0|0|0|P|9|11|D|1L|D|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@$9|10|A|11|B|C]|$9|12|A|13|B|C]|$9|14|A|15|B|C]]|D|@]|E|$]]|$1|O|3|P|5|J|7|16|8|@]|D|@]|E|$K|L]]|$1|Q|3|-4|5|6|7|17|8|@]|D|@]|E|$]]]|R|$]]

<code>BindingSource</code> 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 <code>BindingSource</code> are so helpful.

If your source is say for example a list of user strings

<pre><code>List&lt;string&gt; users = GetUsers();
BindingSource source = new BindingSource();
source.DataSource = users;
dataGridView1.DataSource = source;
</code></pre>

then when your done editing just update your data object whether that be a <code>DataTable</code> or List of user strings like here and <code>ResetBindings</code> on the <code>BindingSource</code>;

<pre><code>users = GetUsers(); //Update your data object
source.ResetBindings(false);
</code></pre>

blocks|key|598376|text|将您的DatagridView重新绑定到源代码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|598377|DataGridView+dg1+=+new+DataGridView();
dg1.DataSource+=+src1;

//+Update+Data+in+src1

dg1.DataSource+=+null;
dg1.DataSource+=+src1;|code-block|syntax|javascript|598378|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Rebind your DatagridView to the source.

<pre><code>DataGridView dg1 = new DataGridView();
dg1.DataSource = src1;

// Update Data in src1

dg1.DataSource = null;
dg1.DataSource = src1;
</code></pre>

blocks|key|598610|text|我知道我来晚了，但我希望这篇文章能帮助那些在类绑定方面也做同样事情的人|type|unstyled|depth|inlineStyleRanges|entityRanges|data|598611|var+newEntry+=+new+MyClassObject();

var+bindingSource+=+dataGridView.DataSource+as+BindingSource;
var+myClassObjects+=+bindingSource.DataSource+as+List<MyClassObject>;
myClassObjects.Add(newEntry);
bindingSource.DataSource+=+myClassObjects;

dataGridView.DataSource+=+null;
dataGridView.DataSource+=+bindingSource;
dataGridView.Update();
dataGridView.Refresh();|code-block|syntax|javascript|598612|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I know i am late to the party but hope this helps someone who will do the same with Class binding

<pre><code>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();
</code></pre>

blocks|key|814167|text|我知道这是一个古老的话题，但我突然发现了最好的方法，它不需要取消数据源并重新分配它。只需使用BindingList而不是列表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|814168|例如：|814169|//declare+your+list
private+BindingList<myclass>+mMyList+=+new+BindingList<myclass>();

//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

}|code-block|syntax|javascript|814170|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|L|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|M|8|@]|9|@]|A|$G|H]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

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:

<pre><code>//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

}
</code></pre>

blocks|key|598586|text|您可以使用DataGridView刷新方法。但是..。在许多情况下，您必须从运行DataGridView的线程之外的其他线程上运行的方法刷新DataGridView。为此，您应该实现以下方法并调用它，而不是直接键入DataGridView.Refresh()：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|598587|++++private+void+RefreshGridView()
++++{
++++++++if+(dataGridView1.InvokeRequired)
++++++++{
++++++++++++dataGridView1.Invoke((MethodInvoker)delegate+()
++++++++++++{
++++++++++++++++RefreshGridView();
++++++++++++});
++++++++}
++++++++else
++++++++++++dataGridView1.Refresh();
++++}++|code-block|syntax|javascript|598588|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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():

<pre><code> private void RefreshGridView()
 {
 if (dataGridView1.InvokeRequired)
 {
 dataGridView1.Invoke((MethodInvoker)delegate ()
 {
 RefreshGridView();
 });
 }
 else
 dataGridView1.Refresh();
 } 
</code></pre>

blocks|key|598699|text|我使用DataGridView的Invalidate()函数。但是，这将刷新整个DataGridView。如果您想刷新特定的行，可以使用dgv.InvalidateRow(rowIndex)。如果您想刷新特定的单元格，可以使用dgv.InvalidateCell(columnIndex,+rowIndex)。当然，这是假设您使用的是绑定源或数据源。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|598700|entityMap^0|G|C|1W|R|35|15|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

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

blocks|key|814004|text|我不知道这个问题是否真的解决了..。但通过查看所有其他答案，似乎没有什么是非常清楚的。我找到的最好的方法是将用于填充datagridview的相同代码放入一个方法中，并将表单的datagridview传递给它，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|814005|public+void+ConnectAndPopulateDataGridView(DataGridView+dataGridView)
{+}|code-block|syntax|javascript|814006|该方法中的代码与最初用于填充datagirdview的代码完全相同，只是datagridview名称更改为您在方法中调用的名称。|814007|现在在父窗体中调用此方法。|814008|通过.ShowDialog()启动子窗体，然后调用该方法，以便在关闭for的子窗体后立即调用该方法。因此：|814009|ChildForm.ShowDialog();

ConnectAndPopulateDataGridView(dataGridView1);|814010|entityMap^0|1M|C|2G|C|0|0|E|C|10|C|0|0|2|D|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|Z|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|10|8|@$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|15|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|H|7|19|8|@]|D|@]|E|$I|J]]|$1|S|3|-4|5|6|7|1A|8|@]|D|@]|E|$]]]|T|$]]

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 <code>datagridview</code> into a method and pass it your form's <code>datagridview</code>, as so: 

<pre><code>public void ConnectAndPopulateDataGridView(DataGridView dataGridView)
{ }
</code></pre>

The code within the method is the exact same as the code used to populate the <code>datagirdview</code> originally, except for the <code>datagridview</code> 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 <code>.ShowDialog()</code> then the method is called after so that it is called right after the child for is closed... as so:

<pre><code>ChildForm.ShowDialog();

ConnectAndPopulateDataGridView(dataGridView1);
</code></pre>

blocks|key|814269|text|我发现了这个有用的.NET+documentation，它演示了如何使用BindingSource.ResetBindings正确地重置绑定。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|814270|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/dotnet/desktop/winforms/controls/reflect-data-source-updates-in-a-wf-control-with-the-bindingsource?view=netframeworkdesktop-4.8^0|10|R|9|I|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]]|D|@$9|Q|A|R|1|S]]|E|$]]|$1|F|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|G|$H|$5|I|J|K|E|$L|M]]]]

I found this useful <a href="https://docs.microsoft.com/en-us/dotnet/desktop/winforms/controls/reflect-data-source-updates-in-a-wf-control-with-the-bindingsource?view=netframeworkdesktop-4.8" rel="nofollow noreferrer">.NET documentation</a> that demonstrates how to reset the bindings correctly, using <code>BindingSource.ResetBindings</code>.

blocks|key|598523|text|您可以使用SqlDataAdapter更新DataGridView|type|unstyled|depth|inlineStyleRanges|entityRanges|data|598524|+++++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;
++++++++++++}
++++++++}|code-block|syntax|javascript|598525|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can use SqlDataAdapter to update the DataGridView

<pre><code> 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;
 }
 }
</code></pre>

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 ?

How can I refresh c# dataGridView after update ?

我有一个dataGridView，当我单击任何行时，表单将打开以更新行数据，但在结束更新后，更新表单将关闭，但dataGridView数据不会更新我该怎么做呢？

问如何在更新后刷新c# dataGridView？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在更新后刷新c# dataGridView？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在更新后刷新c# dataGridView？
EN