Jay Dwire

Jay Dwire

  • NA
  • 3
  • 2.5k

How to display form details when selecting a grid value?

Apr 14 2011 5:08 PM

Hello all,
I am hoping someone here will be able to help me convert two examples to using SqlDataSource.  These are the two examples:

http://examples.ext.net/#/GridPanel/Data_with_Details/Form_Details/
http://examples.ext.net/#/GridPanel/Miscellaneous/Details_Window_Remote/

In the first example, I am able to display the grid values from a SqlDataSource but when I select a grid row, I am unable to display its details.  If someone can show me how to modify the code at the top to work with a SqlDataSource, I would be very grateful.  Further, if it would be possible to add a New, Save, and delete button to that first example, that is really what I am trying to get.  The full code is at the example site, but I believe the area that needs to be updated is:

<script runat="server">
    protected void RowSelect(object sender, AjaxEventArgs e)
    {
        string employeeID = e.ExtraParams["EmployeeID"];

        Employee empl = Employee.GetEmployee(int.Parse(employeeID));

        this.EmployeeID.Text = empl.EmployeeID.ToString();
        this.FirstName.Text = empl.FirstName;
        this.LastName.Text = empl.LastName;
        this.Title.Text = empl.Title;
       
        if(empl.ReportsTo.HasValue)
        {
            Employee reportsTo = Employee.GetEmployee(empl.ReportsTo.Value);
            this.ReportsTo.Text = reportsTo != null ? reportsTo.LastName : "";
        }
       
        this.HireDate.SelectedDate = empl.HireDate.HasValue ? empl.HireDate.Value : DateTime.MinValue;
        this.Extension.Text = empl.Extension;
        this.Address.Text = empl.Address;
        this.City.Text = empl.City;
        this.PostCode.Text = empl.PostalCode;
        this.HomePhone.Text = empl.HomePhone;
        this.TitleCourt.Text = empl.TitleOfCourtesy;
        this.BirthDate.SelectedDate = empl.BirthDate.HasValue ? empl.BirthDate.Value : DateTime.MinValue;
        this.Region.Text = empl.Region;
        this.Country.Text = empl.Country;
        this.Note.Text = empl.Notes;
    }

    protected void Store1_Refresh(object sender, StoreRefreshDataEventArgs e)
    {
        this.Store1.DataBind();
    }
</script>


and

<SelectionModel>
                                            <ext:RowSelectionModel runat="server" SingleSelect="true">
                                                <AjaxEvents>
                                                    <RowSelect OnEvent="RowSelect" Buffer="250">
                                                        <EventMask ShowMask="true" Target="CustomTarget" CustomTarget="#{Details}" />
                                                        <ExtraParams>
                                                            <%-- or can use params[2].id as value --%>
                                                            <ext:Parameter Name="EmployeeID" Value="this.getSelected().id" Mode="Raw" />
                                                        </ExtraParams>
                                                    </RowSelect>
                                                </AjaxEvents>
                                            </ext:RowSelectionModel>
                                        </SelectionModel>


Thank you in advance for any help.
Jay


Answers (2)