Plz help me RRS feed

  • Question

  • 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#. 
    • Moved by CoolDadTx Thursday, April 3, 2014 5:40 PM ADO.NET related
    Thursday, April 3, 2014 3:39 PM


  • HI

    I hope you are using OledbProvider while deleting records in excel, deleting rows is not supported for excel, you need to use Interop.Excel and try

    you need to use Excel interop services namespace for this is  Micrsoft.Office.Iterop.Excel .

    Thursday, April 3, 2014 4:53 PM