populating a new row at the bottom of grid view

Question

Hi guys, I have a grid view populated with data and at the bottom there is a Add template button so that when user clicks on it, a new row will be populated below and user not only able to view the previous data but there can also add in new records at the same time. How do I populate a new row at the bottom?
Next, how do i make use of the method defined in stored procedure and database.cs to insert new records to database. This is the database.cs:
 

 

public bool Insert_ItemRecords(string itemID, string itemName, string 
itemDesc)
        
{
            
SqlCommand cmd_ItemList = new SqlCommand();

            
cmd_ItemList.CommandText = 
"[VRM].[INSERT_ItemRecords]";
            
cmd_ItemList.CommandType = 
CommandType.StoredProcedure;
            
cmd_ItemList.Parameters.Clear();

            
SqlParameter sqlParaItemID = new SqlParameter("@itemID", SqlDbType.VarChar, 
10);
            
sqlParaItemID.Value = 
itemID;
            
cmd_ItemList.Parameters.Add(sqlParaItemID);

            
SqlParameter sqlParaItemName = new SqlParameter("@itemName", SqlDbType.VarChar, 
100);
            
sqlParaItemName.Value = 
itemName;
            
cmd_ItemList.Parameters.Add(sqlParaItemName);

            
SqlParameter sqlParaItemDesc = new SqlParameter("@itemDesc", SqlDbType.VarChar, 
1000);
           
sqlParaItemDesc.Value = 
fileName;
            
cmd_ItemList.Parameters.Add(sqlParaItemDesc);

            

            return 
executeNotQuery(cmd_ItemList);
        
}

This is the stored procedure:

 

ALTER PROCEDURE [OS].[INSERT_ITEMRecords] 
@itemID 
varchar(10),
@itemName varchar(100),
@itemDesc varchar(1000)

AS
INSERT INTO OS.Items  (itemID, itemName, itemDesc)
VALUES 
(@itemID, @itemName, @itemDesc)

 

How do i do the business logic? Can you guys give me some hints? Thanks