Loading

Create a list of parent child and save to sql DB

Keorapetsi Matseme

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

)

1 Reply

Know the answer? Post it — somebody with the same question will find it here.