Keorapetsi Matseme

Keorapetsi Matseme

  • 1.4k
  • 305
  • 2.4k

Create a list of parent child and save to sql DB

Jun 13 2019 2:45 AM
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
)
 

Answers (1)