Click here to Skip to main content
15,896,063 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello Everyone Good Afternoon.

I have a table in MySQL and I used to Show it using Datagridview and this is what it looks like

Item Name       Qty
Apple            0
Mango            0

I will click Export button and what happens next is that the Data in Datagridview will Extract into an excel sheet same as the Illustration above.
I will edit the Extracted Excel Data and I will put anything I want but for now here is the Example I will do.

Item Name    Qty
Apple         100
Mango         100

I will click the Import Button and the excel will overwrite the Data in Datagridview.
My question here is that How can I update the changes happened in datagridview in Mysql Database using the RefID in Textbox1?

I hope you all get It, Im Using VB.Net and Mysql

TY


What I have tried:

As of now nothing, I tried searching all over the net but I cant find a code that fits my program TY
Posted
Updated 3-May-16 23:45pm
v2
Comments
Richard Deeming 4-May-16 14:29pm    
When the user uploads the Excel file, you'll need to use a library to read it, locate the data you want to import, and update your database. It would probably be easier if you put the data in named cells when you export it, so that you can locate them when you import it.

EPPlus[^];
ClosedXML[^];
The OpenXML SDK[^];

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900