Bulk Insert using asp.net with xml with sql Queries

Step:1

The for loop which contains the item name so the item name is get it from for loop and save into the xml node

       for(int i = 30; i < Type.Count(); i++)
                    {               

                            //Get Item Name
                            string itemName = ItemName[i];                     

                            sb.Append("");

                            break;
                        }
                    }
                }

                sb.Append("");

               //Insert Method

               Place your insert method here and pass sb.Tostring() as parameter

                using(ItemInfo item = new ItemInfo())
                {
                    item .InsertItems(sb.ToString());
                }

CREATE PROCEDURE [dbo].[InsertItems]
	-- Add the parameters for the stored procedure here
		@xml xml
		
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	INSERT INTO Items
	(		
		ItemName		
	)
	SELECT            
            TempSwot.Item.value('@ItemName', 'VARCHAR(150)')            
    FROM @xml.nodes('/root/row') AS TempSwot(Item)
END