Intersoft Community - WebGrid Enterprise - Reload webgrid data by Changing the WebCombo

Reload webgrid data by Changing the WebCombo

yudi — Sun, 28 Jul 2013 21:04:52 GMT

Glad to hear the good news.

Should you need further assistance or run into any problems regarding our controls, feel free to post it into our forum. We would be happy to assist you again.

Reload webgrid data by Changing the WebCombo

yogoo — Fri, 26 Jul 2013 00:22:04 GMT

Yudi,

Thank you so much for your help, the code is working prefectly fine.

Don.,

Reload webgrid data by Changing the WebCombo

yudi — Thu, 25 Jul 2013 02:45:00 GMT

...
But is it possible that to use the same method and only pass the value of the combo value to that method and update the grid?

E.g. The grid is a infomation of Students and the combo is a list of Class. If i select a Class, the grid will show the studend that belong to that Class.
...

Yes, it is possible to use the same method and pass a value to that method and update the grid.

In order to do this, please set the SelectMethod property of WebGrid to the desired WebMethod, for example: GetStudents.

<ISWebGrid:WebGrid ID="WebGrid1" runat="server"
    BindingOperationMode="ClientBinding" ...>
    ...
    <ClientBindingSettings DataSourceType="WebService"
        ServiceUrl="../WebService.asmx"
        ItemTypeName="Students">
        <ServiceMethods SelectMethod="GetStudents" />
    </ClientBindingSettings>
</ISWebGrid:WebGrid>

The GetStudents WebMethod should be defined like following snippet code so that we can pass select argument into it.

[WebMethod]
public object GetStudents(DataSourceSelectArguments selectArguments)
{
    if (selectArguments.Tag == "condition1")
    {
        // returns list of students based on condition1
    }
    else if (selectArguments.Tag == "condition2")
    {
        // returns list of students based on condition2
    }
}

DataSourceSelectArguments class contains the following properties:

FilterExpression. The string of filter expression based on ADO.NET syntax.
SortExpression. The string of sort expression based on ADO.NET syntax.
MaximumRows. The number of maximum rows to be retrieved.
OperationType. The type of the operation for this request.
StartRowIndex. The start index of the row to be retrieved.
ViewName. The view name or table name to be selected.
RetrieveTotalCount. Specifies whether the results should include total count of the query.
Tag. Custom information passed from client-side.

The Tag property is suitable for use in such scenario. Next, add following JavaScript function in the client-side to be used in ServiceEvents.

function Service_Selecting(control, selectArguments)
{
    ...
    selectArguments.Tag = "condition1";
    ...
}

Note: Service_Selecting function is used in Selecting event. The Selecting event is invoked when the data provider is about to perform data selection.

<ISWebGrid:WebGrid ID="WebGrid1" runat="server"
    BindingOperationMode="ClientBinding" ...>
    ...
    <ClientBindingSettings DataSourceType="WebService"
        ServiceUrl="../WebService.asmx"
        ItemTypeName="Students">
        <ServiceMethods SelectMethod="GetStudents" />
        <ServiceEvents Selecting="Service_Selecting" />
    </ClientBindingSettings>
</ISWebGrid:WebGrid>

Hope this helps.

Reload webgrid data by Changing the WebCombo

yogoo — Wed, 24 Jul 2013 04:52:15 GMT

Thanks you sample.

In you sample, the grid web method will be changed according to the combo value.

But is it possible that to use the same method and only pass the value of the combo value to that method and update the grid?

E.g. The grid is a infomation of Students and the combo is a list of Class. If i select a Class, the grid will show the studend that belong to that Class.

Thanks a lot.

Reload webgrid data by Changing the WebCombo

yogoo — Wed, 24 Jul 2013 04:51:44 GMT

Thanks you sample.

In you sample, the grid web method will be changed according to the combo value.

But is it possible that to use the same method and only pass the value of the combo value to that method and update the grid?

E.g. The grid is a infomation of Students and the combo is a list of Class. If i select a Class, the grid will show the studend that belong to that Class.

Thanks a lot.

Reload webgrid data by Changing the WebCombo

yudi@intersoftpt.com — Wed, 24 Jul 2013 04:07:21 GMT

I have re-uploaded the sample in this post. Please feel free to let us know if you still have problems to download the sample.

Reload webgrid data by Changing the WebCombo

yogoo — Wed, 24 Jul 2013 03:49:23 GMT

Thank you so much for your reply, but why i can't download the sample? is it the problem of my browser?

Reload webgrid data by Changing the WebCombo

yudi — Wed, 24 Jul 2013 03:10:52 GMT

I created a simple sample of WebGrid which will change WebGrid’s data by selecting a table name from an ASP.NET DropDownList control. The grid is bound to a WebService.

Sample's screenshot

Initially, WebGrid will shows Customers data. When selected index of DropDownList get changed, set the ItemTypeName and SelectMethod based on the selected value of DropDownList. And last, invokes the LoadTablesStructureFromXml(string fileName) method to load the desired table structure and restore it to RootTable object of current WebGrid.

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
    string tblName = DropDownList1.SelectedValue.ToString();
        
    if (tblName != null && tblName != "")
    {
        WebGrid1.ClientBindingSettings.ItemTypeName = tblName;
        WebGrid1.ClientBindingSettings.ServiceMethods.SelectMethod = "Get" + tblName;
        WebGrid1.LoadTablesStructureFromXml(Server.MapPath(tblName + ".xml"));
    }
}

For more detail, please check the aspx page and the aspx.cs file of the sample.

I enclosed the sample as attachment. Please have the attached sample evaluated on your end and let us hear whether it helps or not.

Reload webgrid data by Changing the WebCombo

yogoo — Tue, 23 Jul 2013 00:16:22 GMT

Hi,

Do you have any sample code which can demo how the webgrid data reload according the webcombo selection. And the grid is binding with a webservices.

Thanks,

Don.,