Tony Docherty wrote:I'm not 100% sure I understand your problem so the following may or may not be be appropriate.
1. If your first column has a fixed set of data in it then surely your table already has all the rows it needs and so you should be adding the loaded data piece by piece to the appropriate cells and not be adding new rows.
2. Looking at the data in the image you have provided it looks like your save is saving the column header for each piece of data - please can you show us a sample section of the saved file and the code that is saving the data.
BTW Why are you saving each column header with piece piece of data but not saving the part no? Your file is full of redundant information but is missing what I'd consider a piece of vital information ie which part no the data relates to.
Yes I understand what your part column is for and how it works, the problem is your saved data has no link back to the part the data represents. Now if nothing ever changes this is fine but if you ever change the order of the parts, insert new parts etc then all your saved data will no longer work with the new parts list. It's also very odd that you are blindly relying on the data aligning with the current parts rows yet for every piece of data you are saving the column headers!
Hadijah Mohamad wrote:can you give me your sourcecode? because i can not retrieve image from database. thanks in advance. ...@...