Perform Edit and delete using grid panel and effect should be refrected to sql server database.

[kavit@bdtpark.com]

Below is my grid panel code:

<ext:GridPanel ID="GridPanel1" Header="false" runat="server" Title="Array Grid" Width="600" Height="320">
                <Store>
                    <ext:Store ID="Store1" runat="server" RemoteSort="false" OnReadData="MyData_Refresh">
                        <Model>
                            <ext:Model ID="Model1" runat="server" IDProperty="company">
                                <Fields>
                                    <ext:ModelField Name="SocialID" />
                                    <ext:ModelField Name="SName" Type="String" />
                                    <ext:ModelField Name="SURL" Type="String" />
                                </Fields>
                            </ext:Model>
                        </Model>
                    </ext:Store>
                </Store>
                <ColumnModel ID="ColumnModel1" runat="server">
                    <Columns>
                        <ext:Column ID="Column1" Visible="false" runat="server" Text="StudentId" DataIndex="SocialID" Flex="1">
                        </ext:Column>
                        <ext:Column ID="Column2" runat="server" Width="75" DataIndex="SName">
                        </ext:Column>
                        <ext:Column ID="Column3" runat="server" Width="250" DataIndex="SURL">
                        </ext:Column>
                    </Columns>
                </ColumnModel>

            </ext:GridPanel>

below code that i have wrote in code behind file to fill grid panel:

   protected void Page_Load(object sender, EventArgs e)
        {
            if (!X.IsAjaxRequest)
            {
                BindSocial();
            }
        }

        protected void BindSocial()
        {
            if (!X.IsAjaxRequest)
            {
                this.Store1.DataSource = SocialManager.GetSocialByP_PID(9);
                this.Store1.DataBind();

            }
        }

        protected void MyData_Refresh(object sender, StoreReadDataEventArgs e)
        {
            BindSocial();
        }

What I need is edit and delete button to perform edit functionality and delete functionality.

[Daniil]

Hi @kavit@bdtpark.com,

To remove a record, please use a Store's remove method.
http://docs.sencha.com/extjs/4.2.0/#...-method-remove

To edit a record, you should choose a way of editing. There is a few in Ext.NET.
https://examples2.ext.net/#/GridPane...s/CellEditing/
https://examples2.ext.net/#/GridPane...ins/RowEditor/
https://examples2.ext.net/#/GridPane...Column/Editor/
https://examples2.ext.net/#/GridPane...n/Over_Editor/
https://examples2.ext.net/#/GridPane...mn/Pin_Editor/

Regarding saving to server. Please investigate the examples of the saving functionality.
https://examples2.ext.net/#/search/saving
https://examples2.ext.net/#/GridPanel/Update/AutoSave/
https://examples2.ext.net/#/GridPanel/Update/Batch/
https://examples2.ext.net/#/GridPane...SqlDataSource/

[kavit@bdtpark.com]

thanks for the reply.


Please check the image. I have this type of requirement.
There are 2 button in each row of grid panel. If user clicks on delete system will show the confirmation message and if user click on ok than record "delete" from the database as well as from the grid panel.
If user clicks on "edit" and a form will be open above the girdpanel in that user can see the record which he/she wants to edit. After modification user will click on save button to save changes.

Note: For Insert new record and update existing record I am using form panel. I already performed Insert Operation.

Please give me reply as soon as possible.

[Daniil]

There are 2 button in each row of grid panel. If user clicks on delete system will show the confirmation message and if user click on ok than record "delete" from the database as well as from the grid panel.

To show a confirmation dialog you can use Ext.Msg.confirm().
http://docs.sencha.com/extjs/4.2.0/#...method-confirm