CellSelection and database

[bolzi89]

Hi,

i need to pass data from cellselection in a gridpanel to another gridpanel.
The only way I find is to pass with RowIndex and it works if I don' change order in first gridpanel. but if I change this order the row index is wrong.

        
CellSelectionModel cell = new CellSelectionModel();
cell = this.GridPubbliche.SelectionModel.Primary as CellSelectionModel;
int row;
row = Convert.ToInt32(cell.SelectedCell.RowIndex.ToString());
this.RowSelectionModel1.SelectRow(row);

So I need to pass by key, a field in my database. How can I pass data from database in cellselectionmodel?

[bolzi89]

I'm lookinf for something like this https://examples1.ext.net/#/GridPane...s/One-to-Many/
But when I click on a cell (or on a row) I want the corresponding row in the other grid to be selected.
http://i.imgur.com/tRVlW.png

[Daniil]

Hi,

Please use the CellSelectionModel CellSelect event.
http://docs.sencha.com/ext-js/3-4/#!...ent-cellselect

[bolzi89]

Hi, thanks for the reply.
But I can't use CellSelect, i've to use property from DB, something like this, but it doesn't work...

        CellSelectionModel cell = new CellSelectionModel();
        cell = this.GridPubbliche.SelectionModel.Primary as CellSelectionModel;
        string key = cell.SelectedCell.RecordID.ToString();
        this.RowSelectionModel1.SelectById(key);
        this.RowSelectionModel1.UpdateSelection();

[Daniil]

Where do you call this code?

Please provide a full, but simplified, sample to reproduce the problem.

[bolzi89]

Here you are. I've tried to debug this code and string key have correct value, but RowSelection doesn't work.

Aspx code

                            <ext:GridPanel 
                                ID="GridPubbliche" 
                                runat="server"  
                                Title="Opere pubbliche"                              
                                Icon="foldergo"
                                StripeRows="true"
                                Collapsible="true"
                                EnableColumnMove="true" Width="300"
    
                                >
                                <Store>
                                
                                <ext:Store ID="StoreMenuGrid" runat="server">
                                    <Reader>
                                        <ext:JsonReader IDProperty="KEY">
                                            <Fields>
                                                <ext:RecordField Name="KEY" />
                                                <ext:RecordField Name="TITLE" />
                                                <ext:RecordField Name="FATHER" />
                                                <ext:RecordField Name="DESCRIPTION" />
                                            </Fields>
                                        </ext:JsonReader>
                                    </Reader>
                                </ext:Store>

                                
                                </Store>
                                <ColumnModel ID="ColumnModel2" runat="server">
		                            <Columns>
		                                <ext:Column ColumnId="TITLE" Width="294" DataIndex="TITLE" MenuDisabled="true" Sortable="false" />
                                        </Columns>
                                </ColumnModel>

                               <SelectionModel>
                                    <ext:CellSelectionModel runat="server">
                                        <DirectEvents>
                                            <CellSelect OnEvent="Cell_Click" />                        
                                        </DirectEvents>
                                    </ext:CellSelectionModel>
                                </SelectionModel>

                                </ext:GridPanel>
                                
                            
                </West>
                
                <Center>
       
                        <ext:GridPanel ID="GridPanelPubbliche" 
                            runat="server" 
                            Frame="true" 
                            Height="600">
                            <Store>
                                <ext:Store ID="StorePanelGrid" runat="server">
                                    <Reader>
                                        <ext:JsonReader IDProperty="KEY">
                                            <Fields>
                                                <ext:RecordField Name="KEY" />
                                                <ext:RecordField Name="TITLE" />
                                                <ext:RecordField Name="FATHER" />
                                                <ext:RecordField Name="DESCRIPTION" />
                                            </Fields>
                                        </ext:JsonReader>
                                    </Reader>
                                </ext:Store>
                            </Store>
                            <ColumnModel ID="ColumnModel1" runat="server">
                                <Columns>
                                    <ext:Column DataIndex="KEY" Header="Key" Width="150"  />
                                    <ext:Column DataIndex="TITLE" Header="Title" Width="150" />
                                    <ext:Column DataIndex="FATHER" Header="Father" Width="150" />
                                    <ext:Column DataIndex="DESCRIPTION" Header="Description" Width="150" Resizable="true" />
                                </Columns>
                            </ColumnModel>
             
                            <SelectionModel>
                                <ext:RowSelectionModel ID="RowSelectionModel1" runat="server" />
                            </SelectionModel>
                        </ext:GridPanel>

Cs code

    protected void Page_Load(object sender, EventArgs e)
    {
        ActionPlanList apList = new ActionPlanList();

        dprogetti = (DataSet)apList.list(-10);
        dpubbliche = (DataSet)apList.list(-11);
        dgestionali = (DataSet)apList.list(-16);
     
        this.StoreMenuGrid.DataSource = dpubbliche;
        this.StoreMenuGrid.DataBind();
        
        ActionPlanList apGrid = new ActionPlanList();
        DataSet dsGrid;
        dsGrid = (DataSet)apGrid.list(-11);
        this.StorePanelGrid.DataSource = dsGrid;
        this.StorePanelGrid.DataBind();

    }


    protected void Cell_Click(object sender, DirectEventArgs e)
    {

        CellSelectionModel cell = new CellSelectionModel();
        cell = this.GridPubbliche.SelectionModel.Primary as CellSelectionModel;
        string key = cell.SelectedCell.RecordID.ToString();
        this.RowSelectionModel1.SelectById(key);
        this.RowSelectionModel1.UpdateSelection();     
    }

[Daniil]

If a key is really correct, then removing this line

this.RowSelectionModel1.UpdateSelection();

should solve the problem.

[bolzi89]

Same problem... I click on a cell in west grid, but corresponding row in center grid isn't selected...

[Daniil]

Please post a response of Cell_Click.

[bolzi89]

I solved. I've to change string key to int key. I'm so stupid...
However thanks for help and your patience Daniil ^^