Becky Bloomwood

Becky Bloomwood

  • NA
  • 119
  • 285.5k

populating a new row at the bottom of grid view

Jan 31 2011 12:09 AM

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

Answers (2)