如何在vb.net中从datagridview删除行后更新数据库 [英] how to update database after delete row from datagridview in vb.net

问题描述

我正在删除数据gridview的双击事件中的行，我只想在vb.net中使用sqlserver作为后端自动更新我的数据库

。

I am deleting row on the double click event of data gridview and i just want to update my database
automatically in vb.net using sqlserver as backend.

推荐答案

您可以使用DataAdapter简要地实现您的目标：

1.使用DataAdapter将数据从数据库检索到DataTable;

2.将此DataTable绑定到datagridview的datasource属性;

3.在datagridview上执行删除;

4.通过创建的DataAdapter的Update方法更新数据库在第1步中。



阅读文章了解细节并根据您的需要进行调整。快乐编码。

You may use a DataAdapter to achieve your objective, briefly:
1. retrieve data from the database into a DataTable using a DataAdapter;
2. bind this DataTable to the datasource property of your datagridview;
3. perform deletion on the datagridview;
4. update the database through the Update method of the DataAdapter created in step 1.

Read this article to learn the detail and adapt it to suit your need. Happy coding.

其实如果你从数据网格中删除数据，它会影响到数据库，ru想要更新datagrid或databse，写清楚你的问题。我认为你需要，删除后你需要刷新数据网格？如果是，只需在delet代码后编写相同的代码，如何将数据绑定到datagrid

Actually if u delete data from data grid,it will affect in database,r u want to update datagrid or databse,write ur question clearly.i think u need,after delete u need to refresh data grid ? if it yes,just write same code after delet code how u bind data to datagrid

这篇关于如何在vb.net中从datagridview删除行后更新数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！