mike idowu

mike idowu

  • 1.2k
  • 437
  • 62.2k

ASP.NET MVC - excel upload using stored procedure

Dec 5 2017 5:07 PM
I am using ASP.NET MVC database first. Please how do I upload and save this excel sheet into the database using stored procedure 
 
Table 
 
 
 Excel
 
  CategoryID is auto-generated.
  1. Level 1: is the root parent. Its ParentID should be zero (0)
  2. Level 2 are the direct children of Level 1. Its ParentID is the CategoryID of Level 1 
  3. Level 3 are the direct children of Level 2 Its ParentID is the CategoryID of Level 2
  4. Level 4 are the direct children of Level 3. Its ParentID is the CategoryID of Level 3
  5. It can continue to n level
  6. ParentID1 is the Level. Level 1=1, level2=2
Please how do I go about it

Answers (4)