[RESOLVED] Datatable to MySQL Database

[stanav]

You need to read inforamtion on the DataRow.SetAdded method in MSDN. The SetAdded will throw an exception if te row being set has a rowstate <> rowstate.unchanged or rowstate.added. In short, if any of the rows in your new table has a rowsate = modified or delete, your program will crash.
For you progress bar, if you use dataadapter.Update method then all you can do is to set its style to marquee before calling update method, then set style back to blocks after update method. You cannot know the exact progress percentage using the update method. If you're to use an inser command, and execute the command in a loop then you can tell how many rows (or calculate the %) to set your progressbar.value property.