I am trying to add a new parent child list to DB using treeview.
I have created my table and manually populated it. Now I want to populate it automatically from the view (MVC)
CREATE TABLE Tbl_WBS(
Task_ID INT PRIMARY KEY IDENTITY (1,1) NOT NULL,--Parent
project_Id INT FOREIGN KEY REFERENCES tbl_Projects(project_Id),
Child_Id INT,
WBS_Description NVARCHAR(500) NULL,
Parent_Id INT NULL
)