Add / Edit records using code behind

5 posts, 0 answers
  1. Debashis Pyne
    Debashis Pyne avatar
    66 posts
    Member since:
    Apr 2010

    Posted 30 Jun 2010 Link to this post

    Hi,

    I am a new user to the Telerik controls.
    My requirements are to display, add, edit, activate and deactivate records from the Radgrid.

    Now the above functionalities are required to be integrated using code behind, c# pages.
    The stored procedures, middle layer c# classes have been written already.

    I need to integrate the controls by creating objects of the classes and then bind the controls usign the methods in the classes.
    I found the edit and add functionalities have been integrated using the ASPX codes, which is not my requirement.

    Code examples would be of great help.

    Thanks.

    Regards,
    Debashis
  2. Shinu
    Shinu avatar
    17764 posts
    Member since:
    Mar 2007

    Posted 30 Jun 2010 Link to this post

    Hello,


    I hope the following code libraries will be of help in achieving the required.
    Update/Insert/Delete with stored procedures and SqlDataSource control
    Manual Insert/Update/Delete using FormTemplate and Sql backend


    -Shinu.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Debashis Pyne
    Debashis Pyne avatar
    66 posts
    Member since:
    Apr 2010

    Posted 30 Jun 2010 Link to this post

    Hi Shinu,

    Thanks for your reply.
    This will help me with my requirements.

    Regards,
    Debashis
  5. Debashis Pyne
    Debashis Pyne avatar
    66 posts
    Member since:
    Apr 2010

    Posted 30 Jun 2010 Link to this post

    Hi Shinu,

    I tried to integrate the edit fucntionality using the examples you provided.
    I encountered with the "ArgumentOutOfRangeException" in the following code:

    protected

     

    void grdActionList_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)

     

    {

    Label1.Text =

    "wow";

     

     

    GridEditableItem editedItem = e.Item as GridEditableItem;

     

     

    //Get the primary key value using the DataKeyValue.

     

     

    //string ActionId = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["Action_Id"].ToString();

     

     

     

    //string CustomerID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["CustomerID"].ToString();

     

     

     

    //Access the textbox from the edit form template and store the values in string variables.

     

     

    'Error'     string JOMCID = (editedItem["JOMC_Id"].Controls[0] as TextBox).Text;

     

     

    Label1.Text = JOMCID;

     

    }

    I have also attached the screenshot of the error.
    Can you please suggest?

    Thanks,
    Debashis

  6. Debashis Pyne
    Debashis Pyne avatar
    66 posts
    Member since:
    Apr 2010

    Posted 30 Jun 2010 Link to this post

    Hi Shinu,

    The above issue have been resolved.

    However I have another issue.
    The issue is:

    When I try to update the record with new data from the textbox, the control doesnot take the new value, but keeps the old value.
    The following is the code:

    *********************************************************************************************************************************************************

     

    //Label1.Text = "wow";

     

     

    GridEditableItem editedItem = e.Item as GridEditableItem;

     

     

    //Get the primary key value using the DataKeyValue.

     

     

    string ActionId = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["Action_Id"].ToString();

     

     

    //Access the textbox from the edit form template and store the values in string variables.

     

     

    string JOMCID = (editedItem["JOMC_ID"].Controls[0] as TextBox).Text;

     

     

    //Label1.Text = JOMCID;

     

     

    //try

     

     

    //{

     

    JOMCMiddleWare.BL.

    Actions oAct = new JOMCMiddleWare.BL.Actions();

     

    oAct._JOMC_ID = JOMCID;

    oAct._Action_Id = System.

    Convert.ToInt32(ActionId);

     

    oAct._Content_Id = 8;

    oAct._Content_Text =

    "c4";

     

    oAct._Updated_By = System.

    Convert.ToInt32(Session[JOMCSession.__Session_User_Id]);

     

    oAct._Module_Id = System.

    Convert.ToInt32(Session[JOMCSession.__Session_Lanuage_Id]);

     

    oAct._Company_Id = System.

    Convert.ToInt32(Session[JOMCSession.__Session_Company_Id]);

     

     

    int iResult = oAct.editAction();

     

    Label1.Text = iResult.ToString();

    *********************************************************************************************************************************************************

    In the above code, the variable JOMCID takes the old value rather the new value from the edit popup form.

    Please suggest.

    Thanks,
    Debashis

Back to Top
UI for ASP.NET Ajax is Ready for VS 2017