Delphi treeview control that works with mysql "Nested set model" table
€30-250 EUR
Closed
Posted over 9 years ago
€30-250 EUR
Paid on delivery
Managing hierarchical data in mysql besides the "Adjacency List Model" can be done also using "Nested set model" (introducing 2 extra columns in the table: "lft" and "rght")
This model is described here: [login to view URL] where you can find ready code for adding, deleting nodes, displaying tree etc..
What i need is a simple delphi program with a treeview that will represent the hierarchical data from the table. It should allow user to add nodes, subnodes, delete nodes and moving nodes (drag&drop) from one parent to other parent (including its subnodes). These operation on treeview should then update the database table so the table the the treeview represent the same hierarchical structure.
Initial table can be generated using following SQL code:
CREATE TABLE nested_category (
category_id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20) NOT NULL,
lft INT NOT NULL,
rgt INT NOT NULL
);
INSERT INTO nested_category VALUES(1,'ELECTRONICS',1,20),(2,'TELEVISIONS',2,9),(3,'TUBE',3,4),
(4,'LCD',5,6),(5,'PLASMA',7,8),(6,'PORTABLE ELECTRONICS',10,19),(7,'MP3 PLAYERS',11,14),(8,'FLASH',12,13),
(9,'CD PLAYERS',15,16),(10,'2 WAY RADIOS',17,18);
Hello,
I would use a free TVirtualTreeView component which can display multiple columns, allows in-place editing, sorting, etc in your program.
I am a programmer with more than 10 years experience using Delphi and other programming languages, also various RDBMS.
Dear friend ,
I have experience with delphi and mysql
please can you let me know delphi version that you using
Look forward to working with you!!
Best Regards
winnet
Hi,
I'm highly rated Delphi code with high skills in various databases includes MySQL.
I could develop this sample Delphi application for you.
I would like to use free VTV controls for this needs if you don't mind.
It's powerful control with very high possibility.
I'm excited to work with you.
Thanks, Andriy