Iterate array value in Stored Procedure

Question

User-1241097802 posted

I have one web method in which it contains three parameter

  [System.Web.Services.WebMethod]
        public static void GetSaveData(string iName, string iPath, string[] iData)
        { 
             //code
        }

Now i want to insert the iName And iPath in my TABLE 1 with auto increment id. 

PKId	iName	   iPath
1       cyx.jpeg   c:\

Now the iData which is type array contain multiple record. i want to insert this data into TABLE 2 with FK 

Id   FKID   Name	
1    1      Data1
2    1      Data2
3    1      Data3
4    1      Data4

How i can i write STORED PROCEDURE FOR THIS also if TABLE 2 contains error i want to rollback the TABLE 1 value as well