This is a migrated thread and some comments may be shown as answers.

Insert, Update, Delete Using Pop Up

2 Answers 190 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Rajeev
Top achievements
Rank 1
Rajeev asked on 30 Nov 2012, 06:21 PM
I am trying to do Insert, Update and delete using the POP Up window. I am doing all my code (Code behind).  The question is when ever the window pops up to add or update it never closes. IT updates the database but never closes. i have press cancel in order to close it.

 <form id="form1" runat="server">
    <telerik:RadScriptManager runat="server" ID="RadScriptManager1" />
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <script type="text/javascript">
            function RowDblClick(sender, eventArgs) {
                sender.get_masterTableView().editItem(eventArgs.get_itemIndexHierarchical());
            }
        </script>
    </telerik:RadCodeBlock>
    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
       
    </telerik:RadAjaxManager>
    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server">
    </telerik:RadAjaxLoadingPanel>
    <br />
    <div>
        <asp:Label ID="Label1" runat="server" EnableViewState="False" Font-Bold="True" ForeColor="#FF8080"></asp:Label>
        <asp:Label ID="Label2" runat="server" EnableViewState="False" Font-Bold="True" ForeColor="#00C000"></asp:Label>
    </div>




    <br />
    <telerik:RadGrid ID="RadGrid1" runat="server" Skin="Vista" CssClass="RadGrid" GridLines="None"
        AllowPaging="True" PageSize="5" AllowSorting="True" AutoGenerateColumns="False"   
        ShowStatusBar="true" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
        AllowAutomaticUpdates="True" OnNeedDataSource="RadGrid1_NeedDataSource" OnUpdateCommand="RadGrid1_UpdateCommand" OnInsertCommand="RadGrid1_InsertCommand" OnDeleteCommand="RadGrid1_DeleteCommand"  
        HorizontalAlign="NotSet" Width="681px">
        <MasterTableView CommandItemDisplay="TopAndBottom"
            DataKeyNames="ID" EditMode="PopUp">
            <Columns>
                <telerik:GridEditCommandColumn>
                </telerik:GridEditCommandColumn>
                <telerik:GridBoundColumn UniqueName="id" HeaderText="id" DataField="id">
                    <HeaderStyle Width="60px"></HeaderStyle>
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="Fname" HeaderText="First Name" DataField="Fname">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="Lname" HeaderText="Last Name" DataField="Lname">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="City" HeaderText="City" DataField="City">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn UniqueName="Zip" HeaderText="Zip" DataField="Zip">
                </telerik:GridBoundColumn>
                <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="column">
                </telerik:GridButtonColumn>
            </Columns>
            <EditFormSettings InsertCaption="Add new item" CaptionFormatString="Edit ID: {0}"
                CaptionDataField="ID" EditFormType="Template" PopUpSettings-Modal="true">
                <FormTemplate>
                    <table id="Table1" cellspacing="1" cellpadding="1" width="250" border="0">
                        <tr>
                            <td>
                            </td>
                            <td>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                First Name:
                            </td>
                            <td>
                                <asp:TextBox ID="TextBox10" Text='<%# Bind( "Fname") %>' runat="server">
                                </asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                Last Name:
                            </td>
                            <td>
                                <asp:TextBox ID="TextBox11" Text='<%# Bind( "Lname") %>' runat="server">
                                </asp:TextBox>
                            </td>
                        </tr>
                        
                       
                        <tr>
                            <td>
                                City:
                            </td>
                            <td>
                                <asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind( "City") %>'>
                                </asp:TextBox>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                Zip:
                            </td>
                            <td>
                                <asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind( "Zip") %>'>
                                </asp:TextBox>
                            </td>
                        </tr>
                      
                    </table>
                    <table style="width: 100%">
                        <tr>
                            <td align="right" colspan="2">
                                <asp:Button ID="Button1" Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'
                                    runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'>
                                </asp:Button>&nbsp;
                                <asp:Button ID="Button2" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel">
                                </asp:Button>
                            </td>
                        </tr>
                    </table>
                </FormTemplate>
            </EditFormSettings>
        </MasterTableView>
        <ClientSettings>
            <ClientEvents OnRowDblClick="RowDblClick"></ClientEvents>
        </ClientSettings>
    </telerik:RadGrid>


    </form>



using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BusinessLayer;
using Telerik.Web.UI;

namespace Telerik
{
    public partial class Test : System.Web.UI.Page
    {

        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
        {
            RadGrid1.DataSource = NameManager.GetList();



        }
      
    protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e)
    {
        GridEditableItem editedItem = e.Item as GridEditableItem;
        //Get the primary key value using the DataKeyValue.
       string ID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ID"].ToString();
        //Access the textbox from the edit form template and store the values in string variables.
        string FirstName = (editedItem.FindControl("TextBox10") as TextBox).Text;
        string LastName = (editedItem.FindControl("TextBox11") as TextBox).Text;
        string City = (editedItem.FindControl("TextBox5") as TextBox).Text;
        string Zip = (editedItem.FindControl("TextBox6") as TextBox).Text;


        var User = new Name();
        User.id = Convert.ToInt32(ID);
        User.Fname = FirstName;
        User.Lname = LastName;
        User.City = City;
        User.Zip = Zip;
        NameManager.NameUpdate(User);

        
       
    }
    protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
    {
        GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item;

        //Access the textbox from the edit form template and store the values in string variables.
        string FirstName = (insertedItem.FindControl("TextBox10") as TextBox).Text;
        string LastName = (insertedItem.FindControl("TextBox11") as TextBox).Text;
        string City = (insertedItem.FindControl("TextBox5") as TextBox).Text;
        string Zip = (insertedItem.FindControl("TextBox6") as TextBox).Text;


        var User = new Name();
       // User.id = Convert.ToInt32(ID);
        User.Fname = FirstName;
        User.Lname = LastName;
        User.City = City;
        User.Zip = Zip;
        NameManager.NameInsert(User);



        
     
    }
    protected void RadGrid1_DeleteCommand(object source, GridCommandEventArgs e)
    {
       
        }
    }
}

2 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 03 Dec 2012, 05:37 AM
Hi,

The AllowAutomaticInserts and AllowAutomaticUpdates are used for Automatic DataSource Operations.Try setting these properties to false.

aspx:
<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticInserts="false" AllowAutomaticUpdates="false"

Thanks,
Shinu.
0
Rajeev
Top achievements
Rank 1
answered on 03 Dec 2012, 08:01 PM
Thanks. IT worked
Tags
Grid
Asked by
Rajeev
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
Rajeev
Top achievements
Rank 1
Share this question
or