Intersoft Community - WebCombo - Webcombo databind to WebMethod

Webcombo databind to WebMethod

sinan.biondic@gmail.com — Tue, 05 Mar 2013 04:37:51 GMT

Got it, thanks.

Webcombo databind to WebMethod

bernard — Tue, 05 Mar 2013 02:26:01 GMT

Hi Nikola,

It can't be done if you define WebMethod in System.Web.UI.Page class. You should put it inside WebService class. That's why we need .asmx as Web Service inside your project. Web Service itself have code behind that held WebMethod to get QueryResult. Although, DataSourceSelectArguments will automatically parsed from WebCombo to WebMethod when selecting. However, you can't return a DataTable in ClientBinding with WebService. Also for the snippet code above, the snippet code is not correct because it has WebService as DataSourceType and it will refer to asmx file as WebService. Hope this helps.

Regards,
Bernard

Webcombo databind to WebMethod

sinan.biondic@gmail.com — Mon, 04 Mar 2013 08:41:17 GMT

I'm sorry but i just can't get it together, how am I supposed to do this. How do I pass DataSourceSelectArguments to webmethod, and what should I return. Can I just return the DataTable object? Can you please provide me with sample code on hot to do this, that would be very much appreciated. Also, what should be put in control's markup to define it's connection to webmethod on aspx page. Is the following code correct on that terms?

<ClientBindingSettings DataSourceType="WebService" ServiceUrl="MyPageName.aspx">
    <ServiceMethods SelectMethod="WebMethodName" />
</ClientBindingSettings>

Webcombo databind to WebMethod

bernard — Sun, 03 Mar 2013 23:21:34 GMT

Hi Nikola,

In my sample, I'm using Data Context that automatically built from LINQ to SQL Classes item (dbml). You can see the connection definition in Northwind.designer.cs inside Northwind.dbml. You can use aspx with WebMethod like you mentioned above. You can also define the stored procedure for data retrieval inside it as long as you can access the custom class in WebMethod to get the data. For references, you can look the sample in our WebCombo sample about client binding. And to refresh the value inside ResultBox, you can put the same way like in my sample.

WebCombo2.IsDirty = true;
WebCombo2.NeedClearList = true;
WebCombo2.Values = null;
WebCombo2.ClearSelection();
WebCombo2.RefreshValueItems();

Hope this helps.

Regards,
Bernard

Webcombo databind to WebMethod

sinan.biondic@gmail.com — Fri, 01 Mar 2013 04:07:07 GMT

I guess the webservice can just be replaced with aspx that has a webmethod on it.

This part with northwind database confuses me, can you please show me how webmethods would look if you had a connection to sql server and stored procedure for data retrieval.

Webcombo databind to WebMethod

bernard — Fri, 01 Mar 2013 01:38:08 GMT

Hi Nicola,

To achieve your scenario, I've made you an sample. You can download the sample here.

To refresh Client Binding WebCombo using this script. When you select the first WebCombo, second WebCombo will refresh its value. Hope this helps.

Regards,
Bernard

Webcombo databind to WebMethod

sinan.biondic@gmail.com — Thu, 28 Feb 2013 08:43:15 GMT

I am trying to bind webcombo dynamically. In the page_load event on server side i don't have the information needed to load webcombo data, i have it on client-side. I saw that it was possible to bind combo to webmethod in webservice, but is it possible to bind it to webmethod on .aspx page on which the combo itself is contained.

My problem is that i need to dynamically rebind webcombo on client depending on some input. So when users clicks on different menu options I have to load different data in combo. Is that even possible, and if yes, can someone please give me a working example. I am getting data from stored procedure in sql server. Is there a way, please help!