How to get selected row of detail grid in Master-Detail GridView?

Question

I'm having a problem on getting the selected rows values of a detail grid. I have master-detail grid in a popup control and it works fine. I also enabled the enable selection to have checkboxes but when i try to run GetSelectedFieldValues on ClientSideEvents of a button it always returns "0". What do i do wrong, i couldn't find it?

Here is the detail grid:

                            AutoGenerateColumns="False"

CssFilePath="~/App_Themes/Aqua/{0}/styles.css"

                            CssPostfix="Aqua" 

                            OnBeforePerformDataSelect="gv_ParameterTempD_BeforePerformDataSelect"

ClientInstanceName="gvC_ParameterTempD">

                                <dxwgv:GridViewCommandColumn

ShowSelectCheckbox="True" VisibleIndex="0">

                                </dxwgv:GridViewCommandColumn>

                                <dxwgv:GridViewDataTextColumn

Caption="Detay Kodu" FieldName="PrmDetailCode"

                                    VisibleIndex="0">

                                </dxwgv:GridViewDataTextColumn>

                                <dxwgv:GridViewDataTextColumn

Caption="Seçim Adı" FieldName="PrmDetailName"

                                    VisibleIndex="2">

                                </dxwgv:GridViewDataTextColumn>

                                <dxwgv:GridViewDataTextColumn

Caption="Seçim Adı(Grup)"

                                    FieldName="PrmDetailNameG"

VisibleIndex="3">

                                </dxwgv:GridViewDataTextColumn>

                                <dxwgv:GridViewDataTextColumn

Caption="Seçim Adı(Stok)"

                                    FieldName="PrmDetailNameS"

VisibleIndex="4">

                                </dxwgv:GridViewDataTextColumn>

                                <dxwgv:GridViewDataTextColumn

Caption="Grup Seçimi Yapan"

                                    FieldName="PrmGroupSelector"

VisibleIndex="5">

                                </dxwgv:GridViewDataTextColumn>

                                <dxwgv:GridViewDataTextColumn

Caption="Stok Seçimi Yapan"

                                    FieldName="PrmStokSelector"

VisibleIndex="6">

                                </dxwgv:GridViewDataTextColumn>

                            </Columns>

And this is the button:

                <ClientSideEvents Click="function(s,e)

                {

                    pcc_Question.Hide();

                    gvC_ParameterTempD.GetSelectedFieldValues('PrmDetailName;PrmDetailNameG;PrmDetailNameS',ShowCellValue);

                }"

                />

            </dxe:ASPxButton>

and this is the jsscript:

function ShowCellValue(values) {

    var value = condition.GetText();

    alert(values.length); // here it returns "0"

    if(value != "")

    {

        var newValue = ' ' + value + values + ' = ';

        condition.SetText(newValue);

    }

    else

    {

        for(var i = 0; i < values.length; i ++) {

            value += values[i];

        }

        condition.SetText(value);

    }



}

I don't know what i do wrong,

Thanks for the help

score 0 · Answer 1 · answered Jul 07 '10 at 13:36

0

Am I right in my assumption that the button is residing in the same DetailRowTemplate container? Anyway, it is necessary to access the proper instance of the detail GridView object. To do this, set the grid's ClientInstanceName property to a dynamic value. This should allow you to access the proper grid instance and fetch selected row values. A sample code is available at:

http://www.devexpress.com/Support/Center/ViewIssue.aspx?issueid=Q90007

answered Jul 07 '10 at 13:36

DevExpress Team

11,338
2
24
23

Button is not in DetailRowTemplate, it's outside of the grid. – mehmetserif Jul 07 '10 at 14:21
If so, there can be many detail grids. How do you decide which grid values should be fetched? – DevExpress Team Jul 07 '10 at 14:36
There is only one detail grid, and the button is outside of all grids, it's in an html table. Spesific ClientInstanceName is not enough? – mehmetserif Jul 07 '10 at 15:37
Hmm, I think that I do not quite understand you. Are you using two grids separately? Or do you have a detail grid, residing in the DetailRowTemplate container of the master grid, as shown in DevExpress demos? If the latter case, the number of detail grids at the moment equals the number of visible expanded master rows. That is why I suggested you use the approach with a dynamic ClientInstanceName. – DevExpress Team Jul 08 '10 at 07:30
No, i don't use them separately, detail grid is in DetailRowTemplate but what i want to know is that, is it important to have the button inside of DetailRowTemplate?Because if it's outside of the DetailRowTemplate "Container.VisibleIndex" doesn't work. Also in my case there will be only one master grid and detail grid. – mehmetserif Jul 08 '10 at 08:56
If there is only a single detail grid at a time, your code should work fine. It is not important to have a button inside a template container. So far, I have only two ideas: 1) make certain that the button's AutoPostBack property is set to false; 2) make certain that there are selected rows when this button is clicked. Also, I do not see a column whose field name is PrmDetailName. But you are requesting its value in the script. – DevExpress Team Jul 08 '10 at 09:04
Yes, there is a column whose field name is PrmDetailName. Its VisibleIndex is 2. If the button outside of the DetailRowTemplate, how can i set the VisibleIndex of the DetailGrid. Because on the ClientSideEvents of a AspxButton, Container.VisibleIndex doesn't work. – mehmetserif Jul 08 '10 at 09:12
If the button is outside of the TemplateContainer and there is only a single master row expanded (this is very important) and there are selected rows in this grid, your code should work. I do not see a reason for it to do not work. – DevExpress Team Jul 08 '10 at 11:03
Please let me know how your grids are bound to data source. I.e. did you set DataSourceID property of both grids, or you are setting the DataSource property in runtime and than call DataBind method? If the latter case, please post your code here (I wonder, when you set the DataSource property and when you call DataBind). – DevExpress Team Jul 08 '10 at 11:05
I wrote how i set the DataSource below. – mehmetserif Jul 08 '10 at 13:36

mehmetserif · Answer 2 · 2010-07-08T11:35:30.927

I'm setting the DataSource at Runtime but i do not call DataBind method, because it makes BeforePerformDataSelect of the Detail Grid to perform more than one.

This code set the master grids datasource and bind it:

protected void gv_Answers_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) {

        ConfPrmMTempCollection _ConfPrmMTempCollection = new ConfPrmMTempCollection();
        masterKey = e.Parameters;

        if (masterKey != "")
        {
            man.Add(new SqlOperatorEquality("MAND_CONF_PRM_M_TEMP.PARAMETER_M_TEMP_ID", Convert.ToInt32(masterKey)));
            gv_Answers.DataSource = gc.LoadCollectionFromCollType(typeof(ConfPrmMTempCollection),man);
            gv_Answers.DataBind();

            man.Clear();

        }
    }

And this code is for setting the datasource of the detail grid:

protected void gv_ParameterTempD_BeforePerformDataSelect(object sender, EventArgs e) {

        ASPxGridView detailGrid = sender as ASPxGridView;

        masterKey = detailGrid.GetMasterRowKeyValue().ToString();
        man.Add(new SqlOperatorEquality("MAND_CONF_PRM_D_TEMP.PARAMETER_M_TEMP_ID", Convert.ToInt32(masterKey)));

        detailGrid.DataSource = gc.LoadCollectionFromCollType(typeof(ConfPrmDTempCollection),man);
    }

score 0 · Answer 3 · answered Jul 08 '10 at 18:06

0

I see that you set the master grid's DataSource in the CustomCallback event handler. Try to cache the masterKey value in a Session variable and set the grid's DataSource not only in the CustomCallback event handler but also in the Page_Init method:

protected void Page_Init(object sender, EventArgs e) {
    if(Session["masterKey"] == null)
      return;
    ConfPrmMTempCollection _ConfPrmMTempCollection = new ConfPrmMTempCollection();

            masterKey = Session["masterKey"].ToString();

            if (masterKey != "")
            {
                man.Add(new SqlOperatorEquality("MAND_CONF_PRM_M_TEMP.PARAMETER_M_TEMP_ID", Convert.ToInt32(masterKey)));
                gv_Answers.DataSource = gc.LoadCollectionFromCollType(typeof(ConfPrmMTempCollection),man);
                man.Clear();
            }

    }


    protected void Page_Load(object sender, EventArgs e) {
                gv_Answers.DataBind();
    }

Does this help?

answered Jul 08 '10 at 18:06

DevExpress Team

11,338
2
24
23

But that grid shows up in a PopupControl and there is one another grid to shows that PopupControl. So i can't load this grid on PageInit. Because data is loaded by the value passed from first grid. – mehmetserif Jul 08 '10 at 21:04
The value from the master grid can be saved in a Session variable. When the next request is processed, you will be able to fetch it from the Session and fill the grid with data based on this parameter. I've posted a code before showing how this can be done. Please try this approach, it should work. – DevExpress Team Jul 12 '10 at 17:45
This code loads the grid at page load. But master-detail grid doesn't show up at page load. So i can save the value in a Session variable, but doesn't help to me. All i want to do is that get the field value of a selected row. But i always get an empty variable, "GetSelectedFieldValues" doesn't seem to be working in my case. – mehmetserif Jul 14 '10 at 17:17
I feel as I do not quite understand how the grid works in your application. Could you please describe your task in details? I will try to recreate the problem on my machine and let you know the solution. – DevExpress Team Jul 14 '10 at 18:44
Ok, there is one grid on a page loaded with datas and when you double click on a row, PopupControl shows up. There is a Master-Detail grid on that PopupControl, loads by the value passed from the grid which is on the page. What i want to do is that in the detail grid user will select rows and click add to list. So everything works really fine until "Add to List" case. I can't get the field values on a selected row of the detail grid. Maybe it's not a confusing task but i couldn't really do it. Thanks for your help. – mehmetserif Jul 15 '10 at 09:44
Did you have time to create the problem on your machine? – mehmetserif Jul 16 '10 at 11:34
Not yet :(. I hope to recreate your configuration locally by the end of the week end. BTW, which version are you using? – DevExpress Team Jul 16 '10 at 13:11
Ok, this is going to be very important task for me and i'm using 9.2v of DevExpress. – mehmetserif Jul 16 '10 at 13:14

score 0 · Answer 4 · answered Jul 20 '10 at 08:18

0

I have created a sample project based on your description and it works fine. It is available to download from:

http://www.devexpress.com/Support/Center/ViewIssue.aspx?issueid=Q220495

answered Jul 20 '10 at 08:18

DevExpress Team

11,338
2
24
23

I can't run the project because my devexpress version is 9.2 but you used 10.1 so i got an assembly error and .net version you used is 2.0, mine is .net 3.5. What can i do to debug your project? – mehmetserif Jul 22 '10 at 13:01
You should use the ProjectConverter tool (Start-->Developer Express v2009 vol 2-->Components-->Tools) shipped within the Suite to upgrade my project to your DXperience version. As for the .NET Framework 3.5. VS2008 should be able to open my project and upgrade it. – DevExpress Team Jul 22 '10 at 13:27
Your solution works fine but when i try to convert it to my project i got this error : "A primary key field specified via the KeyFieldName property is not found in the underlying data source.". Is it because i use Collection to load data source? Or are there any other reasons? Thank you. – mehmetserif Jul 24 '10 at 12:59

How to get selected row of detail grid in Master-Detail GridView?

4 Answers4