选择/插入/更新/删除Excel 2007文件和C# [英] Select/Insert/Update/Delete Excel 2007 File and C#

问题描述

我正在使用datagridview，并将Excel文件绑定到datagridview.我能够从excel文件读取以及使用datagridview插入该文件.但是我无法删除和更新该文件.提供错误消息此ISAM不支持删除链接表中的数据.".是否有其他最佳方法可以使用datagridview在excel文件上执行这些操作.或者只是我该如何使用C#中的datagridview删除，更新Excel文件中的记录.

I am using datagridview and i am binding my excel file to datagridview. I am able to read from excel file as well as insert to that file using datagridview. But I am not able to delete and update that file. It''s giving error that "Deleting data in a linked table is not supported by this ISAM.". Is there any other best method to perform these operation on excel file using datagridview. Or simply how can I delete, update record in Excel file using datagridview in C#.

推荐答案

亲爱的朋友，

这些链接将对您有所帮助:-

http://www.codeproject.com/Articles/18026/Edit-and-Delete-Multiple-Data-in-DataGrid-in-ASP-N [> http://stackoverflow.com/questions/7315782/display-excel-file- content-in-a-datagridview [ ^ ]

http://www.dreamincode.net/forums/topic /78659-delete-and-add-rows-excel-c％23/ [ http://www.codeguru.com/csharp/.net/net_data/datagrid/article.php/c13041 [ ^ ]

Dear Friend,

These links will be helpful to you:-

http://www.eggheadcafe.com/community/csharp/2/10050689/how-can-i-use-a-datagrid-for-adding--deleting-updating-in-a-windows-application.aspx[^]

http://www.codeproject.com/Articles/18026/Edit-and-Delete-multiple-Data-in-DataGrid-in-ASP-N[^]

http://stackoverflow.com/questions/7315782/display-excel-file-content-in-a-datagridview[^]

http://www.dreamincode.net/forums/topic/78659-delete-and-add-rows-excel-c%23/[^]

http://www.codeguru.com/csharp/.net/net_data/datagrid/article.php/c13041[^]

这篇关于选择/插入/更新/删除Excel 2007文件和C#的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！